-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Michael,
Change your query to:
<CFQUERY NAME="ID" DATASOURCE="assets">
SELECT IDNUMBER
FROM tblsessions
WHERE IDNUMBER = '#IDNUMBER#'
</CFQUERY>
Right now you're telling your database server "Get me the idnumber
from tblsessions where the id NUMBER is two letters"....and your db
server is expecting to see numbers.
Aaron Johnson, MCSE, MCP+I
Allaire Certified ColdFusion Developer
MINDSEYE, Inc.
<phn>617.350.0339
<fax>617.350.8884
<icq>66172567
[EMAIL PROTECTED]
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
