You need to set up a datasource in the cf administrator, then on your .cfm
page do the following:
<cfquery datasource="yourDatasourceName" name="qGetStuff">
SELECT ID, foo
FROM tbl_stuff
</cfquery>
You can use the resulting query object in any number of ways.
You might want to take a look at:
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Part_3_CFM
L_Ref_1.html
And
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Part_3_CFM
L_Ref_1.html
Amongst others.
Cheers
-----Original Message-----
From: ismail cassiem [mailto:[EMAIL PROTECTED]
Sent: 18 November 2008 13:08
To: cf-talk
Subject: Re: Create a lookup to point to a DB where I specify a query
It's not that I have no connection, I have a blank HTML page where I need to
setup lookups. I don't know the code to insert in blank html - where i can
specify a server name, user,password, and query string.
Then use the query string in lookup select drop down.
Code examples of lookup with connection code specified.
Regards
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315429
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
