Eddie: That looks like it just might do the trick .. thanks :)
Nick: Yes, that makes sense, I think, except our database structure isn't
quite work that way .. I don't think. Hmm .. I'm doing too much thinking ..
I'll have to look into that a bit more just be be sure.
Thanks,
Todd Ashworth
----- Original Message -----
From: "Eddie Shipman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 28, 2000 3:20 PM
Subject: RE: DSNless connections
> I've seen a tip on how to do this with ADO.
>
http://forums1.allaire.com/DevConf/Index.cfm?CFID=194029&CFTOKEN=13562140&&M
essa
> ge_ID=232685
>
> And here's some source posted a couple weeks ago:
>
> <!--- COM to ADO to OLEDB --->
> <CFOBJECT TYPE="COM" NAME="MyConnection" CLASS="ADODB.Connection"
> ACTION="CREATE">
> <cfset isopen =
> MyConnection.Open("Provider=Microsoft.Jet.OLEDB.4.0;Persist Security
> Info=False;Data Source=d:\web\acacia\acacia.mdb","","",-1)>
> <CFOBJECT TYPE="COM" NAME="MyRS" CLASS="ADODB.Recordset"
> ACTION="CREATE">
> <cfset tmp = MyRS.Open("select * from groups", MyConnection,1,1,1)>
> <cfoutput>#myrs.recordcount#</cfoutput>
> <CFSET MyRS = "">
> <CFSET MyConnection = "">
------------------------------------------------------------------------------
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.
