Webmaster Forum / ColdFusion / Database Access / June 2006

Has anyone seen this error?  I don't understand why I can get the below QofQ
code to work properly on my personal developer CF MX server but I can't make it
work on my Department's enterprise CF 5 server?  To me, it seems like the CF 5
server doesn't understand how to process a ...

This is the error I get -
Query Of Queries syntax error. Encountered ". Query Of Queries runtime error.
The Cold Fusion server is running MX 7,0,1,116466.
The sql is "Select * from Invlotquery2 where lotnum = '2011-61-12' ". (The

I have two pages... a SEARCH.cfm and a RESULTS.cfm
On the search page I have the form with an action pointing to the results page
'on submit'... Ok to here!
On the results page I display the first 5 records from the recordset and then

Can anyone help me. I have a ColdFusion application that blows up on the SQL
Query in version MX7. It works fine in MX6 and if I take the SQL query out of
ColdFusion and do a query directly on the database using SQL + it works fine.
Here is the query:

I have query 1 which has a list of names and query 2 which has ratings for the
names.  Every rating from query 2 has a name in query 1, but not every name
from query 1  has a rating in query 2.  I need to make a query of queries that
will result in a list of the suppliers from ...

Hello- I am currently learning coldfusion and I have just connected to a MS
Access database and I have created some dynamically loaded list boxes. One
field has multiple items that are identical. I wish to eliminate the repetition
of this field, how would I do this?

http://www.healthhokkaido.com/files/catalog_getCategories.cfm
I have checked my server and this file exists and i have connected the dsn
correctly.
in the error  is the address below

I have a Table with huge volume of records . table structuer is some thing like
this
country : region : destrict : destination: Activity date : Trailor : T type
what i want eventaully is to create a Text file using perl automatically which

Hi, learning CF and enjoying it, but looking for the best technique to use.
Using Access for the DB and have a website building on the fly with data from
it. I need to add something like an inventory DB function to the site. My
desire is to make it work and look like a form in ...

Is there a way to define a datasource with XML?
My admin is not working on a linux (FC5) with Sun Appserver 9 but I am getting
page translation.
... Cold Fusion without datasourses is like a peanut butter and jelly sandwich

I am in the process of setting up my own webserver at my storefront but am
having some troubles connecting from outside.  I have a machine with server
2003 standard R2 installed and CF7 and SQL server 2000.  I connect to the
server using the console remote desktop, which works ...

I posted this over in Advanced techniques with only one brave, yet
unfortunately uninformed taker...
Anyone here have a clue as to why I'd get the error described in the
text below???

It's advanced for me, at least. I have three tables that I need to use:
[b]Product[/b] (product_id and product_title are the fields)
[b]shipRegion[/b] (shipRegion_ID)
[b]product_shipRegion_shipCharge[/b] (product_id, shipRegion_ID,

    This is probably come up before, but  I'm not having any luck tracking
down info on it. Does anyone have a list of datatype sizes for each type
supported in the CFQUERYPARAM tag's CFSQLTYPE attribute (where applicable)?
Found this documentation:

How to add security to data sources from SQL 2000
I have been doing ColdFusion programming for over 5 years and now I hired an
assistant for myself. So far I didn?t have any security on my data sources but
now I need to add user rights to these so if my assistant make a mistake