Go Back   DeveloperBarn Forums > Programming & Scripting > ASP Development

Sponsored Links

Discuss "No value given for one or more required parameters Error" in the ASP Development forum.

ASP Development - Learn coding practices and tips to get the best out of your Active Server Pages (ASP). The Classic ASP forum is for ASP/VBScript and ASP/JScript applications.


Reply « Previous Thread | Next Thread »  
 
LinkBack Thread Tools Display Modes
  #1  
Old August 6th, 2008, 02:16 AM
PhloooooIsFlo's Avatar
Barn Newbie

 
Join Date: Jul 2008
Location: Indonesia
Posts: 32
Thanks: 3
Thanked 0 Times in 0 Posts
Rep Power: 1
PhloooooIsFlo is an unknown quantity at this point
Default No value given for one or more required parameters Error

Hi, I'm back (with some problem).

So, I got the error "No value given for one or more required parameters" when I try to viewing some data.
Here's the code

Code:
strOther = "SELECT * FROM ShoppingCart WHERE CustomerCode = '239130793' AND OrderID = '239130793' AND OtherFabricFinishing IS NOT NULL AND ProductID = '351'"
													rss.Open strOther, db, 3, 3 '<<HERE IS THE ERROR>>
													If Not rss.EOF then
														     Response.Write(rss("OtherFabricFinishing"))
													End If
													rss.Close
Anyone can help?
Thank you...
Reply With Quote
Sponsored Links
  #2  
Old August 6th, 2008, 07:27 AM
mehere's Avatar
Super Sarcasm Mistress


 
Join Date: Mar 2008
Location: Wide Awake In Dreamland
Posts: 143
Thanks: 10
Thanked 27 Times in 25 Posts
Rep Power: 1
mehere will become famous soon enough

Awards Showcase
Microsoft SQL Server Classic ASP 
Total Awards: 2

Default

if those fields (CustomerCode, OrderID and ProductID) are number datatypes in your database, then you need to remove the single quotes around them.
__________________
Quote of the Month:
Regret: It hurts to admit when you make mistakes - but when they're big enough, the pain only lasts a second.

Questions to Ponder:
Could it be that all those trick-or-treaters wearing sheets aren’t going as ghosts but as mattresses?

iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm")
copyright © 2008 sbenj69
Reply With Quote
  #3  
Old August 6th, 2008, 08:45 AM
PhloooooIsFlo's Avatar
Barn Newbie

 
Join Date: Jul 2008
Location: Indonesia
Posts: 32
Thanks: 3
Thanked 0 Times in 0 Posts
Rep Power: 1
PhloooooIsFlo is an unknown quantity at this point
Default

Hi Mehere,

Actually the type of both are text... >.<
Did I miss something there?

Thx
Reply With Quote
  #4  
Old August 6th, 2008, 08:46 AM
jmurrayhead's Avatar
The Barnfather

 
Join Date: Mar 2008
Location: Reston, VA, USA
Posts: 818
Thanks: 20
Thanked 74 Times in 71 Posts
Blog Entries: 5
Rep Power: 3
jmurrayhead has a spectacular aura aboutjmurrayhead has a spectacular aura aboutjmurrayhead has a spectacular aura about

Awards Showcase
Microsoft Windows Microsoft .Net Microsoft SQL Server Classic ASP 
Total Awards: 4

Default

This error is also given if there is a misspelled field name.
__________________
jmurrayhead
If you agree with me... click the icon!
If my post solved your problem, click the button in the lower right-hand corner of the post.

Join our Folding team: DeveloperBarn Folding
Reply With Quote
  #5  
Old August 6th, 2008, 08:54 AM
PhloooooIsFlo's Avatar
Barn Newbie

 
Join Date: Jul 2008
Location: Indonesia
Posts: 32
Thanks: 3
Thanked 0 Times in 0 Posts
Rep Power: 1
PhloooooIsFlo is an unknown quantity at this point
Default

Hoya J!! I will check if there is an misspelled field name.. ^^

Thx
Reply With Quote
  #6  
Old August 10th, 2008, 08:31 AM
Shadow Wizard's Avatar
Ask Me About Dragons :D

 
Join Date: Jul 2008
Posts: 23
Thanks: 0
Thanked 4 Times in 4 Posts
Blog Entries: 1
Rep Power: 1
Shadow Wizard is on a distinguished road

Awards Showcase
Microsoft .Net Classic ASP JavaScript 
Total Awards: 3

Default

for better efficnecy, consider changing this line:
Code:
rss.Open strOther, db, 3, 3 '<<HERE IS THE ERROR>>
to this:
Code:
Set rss = db.Execute(strOther)
Reply With Quote
  #7  
Old August 13th, 2008, 11:13 AM
PhloooooIsFlo's Avatar
Barn Newbie

 
Join Date: Jul 2008
Location: Indonesia
Posts: 32
Thanks: 3
Thanked 0 Times in 0 Posts
Rep Power: 1
PhloooooIsFlo is an unknown quantity at this point
Default

Thx bro
Reply With Quote
Reply

  DeveloperBarn Forums > Programming & Scripting > ASP Development

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
too few parameters error todd2006 SQL Development 3 August 4th, 2008 11:16 AM
help is required on php popups! sujith.it PHP Development 1 July 17th, 2008 02:02 PM
[Error] Object Required?!?!? jarvelous ASP Development 2 March 20th, 2008 12:46 PM


All times are GMT -4. The time now is 02:36 PM.



Content Relevant URLs by vBSEO 3.2.0