Discuss "another access problem" in the ASP Development forum.

todd2006 · #1 July 30th, 2008, 10:39 AM

Hi,

I have this query

Code:

str="SELECT Sum(Amount) FROM Registration where Id=" & id & " and RespMsg='Authorized' and Test_Id=" & getno

following are the datatype

Code:

Amount - currency
Id -- number 
Test_Id -- number field
RespMsg -- text field

it gives me this error
[Microsoft][ODBC Microsoft Access Driver] Too few parameters.

Rebelle · #2 July 30th, 2008, 10:43 AM

i think you need the other fields...maybe?...like:

Code:

str="SELECT Id, RespMsg, Test_Id,Sum(Amount) FROM Registration where Id=" & id & " and RespMsg='Authorized' and Test_Id=" & getno

mehere · #3 July 30th, 2008, 10:49 AM

have you tried a response.Write to see if the string is being built correctly

Code:

str="SELECT Sum(Amount) FROM Registration where Id=" & id & " and RespMsg='Authorized' and Test_Id=" & getno
response.Write(str)
response.End

are id and test_id both number fields? have you tried running the query directly in access?

todd2006 · #4 July 30th, 2008, 10:57 AM

rebelle,

I tried ur query it gives me an error

You tried to execute a query that does not include the specified expression 'RespMsg' as part of an aggregate function.

Mehere,

yes both are number fields

str="SELECT Sum(Amount) FROM Registration where Id=" & id & " and RespMsg='Authorized' and Test_Id=" & getno
response.Write(str)

the output is like this

SELECT Sum(Amount) FROM Registration where Id=11 and RespMsg='Authorized' and Test_Id=9

mehere · #5 July 30th, 2008, 11:02 AM

are those fields listed as numbers in your database? what datatype is amount? and have you tried running the above query directly in the access database?

todd2006 · #6 July 30th, 2008, 11:09 AM

I got it had to trim the request.querystring

thanks guys

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
access problem	todd2006	Microsoft Access	4	July 30th, 2008 11:38 AM
MS access distinct datetime problem	todd2006	ASP Development	16	July 24th, 2008 01:05 PM

Discuss "another access problem" 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.