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

PhloooooIsFlo · #1 August 6th, 2008, 02:16 AM

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...

mehere · #2 August 6th, 2008, 07:27 AM

if those fields (CustomerCode, OrderID and ProductID) are number datatypes in your database, then you need to remove the single quotes around them.

PhloooooIsFlo · #3 August 6th, 2008, 08:45 AM

Hi Mehere,

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

Thx

jmurrayhead · #4 August 6th, 2008, 08:46 AM

This error is also given if there is a misspelled field name.

PhloooooIsFlo · #5 August 6th, 2008, 08:54 AM

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

Thx

Shadow Wizard · #6 August 10th, 2008, 08:31 AM

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)

PhloooooIsFlo · #7 August 13th, 2008, 11:13 AM

Thx bro

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

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.