I am using MX - I just have a feeling the Table is goofy.
I am attempting to convert an Access System to MySQL - with rather poor
results. The original DB was created by a company in London that no longer
exists (Microsolv?) and the client is stuck using an Access 97 DB and front
end. It also appears that they "coded" some of the DB itself - storing info
like {6ED7EA58-DBBF-449C-81AE-96D6F5F6A9EE} instead of "English" or the ID
for English.
If anyone has any ideas about that, please let me know. That may be a
project ender, unless I can find a way to descramble that code.
-Nick
-----Original Message-----
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Friday, July 29, 2005 12:22 AM
To: CF-Newbie
Subject: RE: Dynamic Query Trouble
Are you using CF 5 or something else older than CFMX?
Evaluate() is generally slower than other methods and should be avoided if
possible, but CFMX was the first version to eliminate most of the cases
where it is necessary.
-----Original Message-----
From: Nick Sweeney [mailto:[EMAIL PROTECTED]
Sent: Friday, 29 July 2005 11:17 AM
To: CF-Newbie
Subject: RE: Dynamic Query Trouble
Well - I tried this and I still get the error:
[Table (rows 1 columns NATIONALITYID): [NATIONALITYID:
[EMAIL PROTECTED] ] is not indexable by NationalityID
Why should I not use Evaluate? Too much Processor time or something?
-Nick
-----Original Message-----
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 28, 2005 7:36 PM
To: CF-Newbie
Subject: RE: Dynamic Query Trouble
Don't use Evaluate().
You need <cfset S1 = qryGetSearchType1[ColID1][1]>
(notice the row index as well).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1362
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
