>I have two queries on the same page, both are pulling info by an client_id
>and one other field but on one of the queries i keep getting this error.
Without seeing your code the only advice I can give is to fully scope your
variables. For example, instead of using #project# use #qryName.project#
(where qryName is the name of a query) or #form.project# or whatever. You
may have variables named "project" in multiple scopes, and CF may be
inadvertently reading the wrong scope. If you fully scope the variable when
you reference it then CF has less quess work to do, which means less chance
of errors (and it will run faster too).
Post your code if you still have problems. A piece of advice, however:
change your mail client to send in PLAIN TEXT format to this list. The list
server doesn't seem to be accepting HTML formatted messages. It botches the
MIME encoding and any code you include will come through all botched up.
This makes reading the post difficult, which in turn means less chance of
you getting an answer.
Regards,
Seth Petry-Johnson
Argo Enterprise and Associates
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.