PCMech Forums - View Single Post - More ASP and Access problems. Please help ASAP

UncaDanno · 12-22-2000, 11:14 AM

Good follow-up, mosquito. A bit easier to read than what I was going to reply with.

Art, the problem is that Request.QueryString("TicketNumber")is passed as a variant to the database. And the ticket number is stored as a number.

Try:
" WHERE Follow_up.TicketNumber = " & cint(Request.QueryString("TicketNumber"))

12-22-2000, 11:14 AM	#7
UncaDanno Member (9 bit) Join Date: Dec 1999 Location: Midland, NC, USA Posts: 292	Good follow-up, mosquito. A bit easier to read than what I was going to reply with. Art, the problem is that Request.QueryString("TicketNumber")is passed as a variant to the database. And the ticket number is stored as a number. Try: " WHERE Follow_up.TicketNumber = " & cint(Request.QueryString("TicketNumber"))