[ordeith]

query="SELECT COUNT(*) FROM calltable WHERE phonenumber='"&request("phonenumber")&"' AND campaignid=130"

if conn.execute(query) > 0 then

I get a type mismatch on this row.
And yes phonenumber is textformatted in the db and the query works in MySQL tried it via phpMyAdmin.

Help please

[selwonk]

You might need to output your COUNT() to a valid SQL variable name and specify a field to count:

Code:

query="SELECT COUNT(ID) AS Total FROM calltable WHERE phonenumber='"&request("phonenumber")&"' AND campaignid=130"

Then once you execute your query you can look at a variable called Total in your resultant recordset

Originally Posted by ordeith

query="SELECT COUNT(*) FROM calltable WHERE phonenumber='"&request("phonenumber")&"' AND campaignid=130"

if conn.execute(query) > 0 then

I get a type mismatch on this row.
And yes phonenumber is textformatted in the db and the query works in MySQL tried it via phpMyAdmin.

Help please