Title: Message
|
That
sounds cool, I haven't touched VB in years and probably would need to do a
bit of brushing up to do that, but certainly not a bad
idea...
How
difficult do you reckon this is? What's involved?
Is it
as easy as opening a new project VB component, paste the code, save it, register
it and call it?
Taco
Fleur
Tell me and I will forget
Show me and I will
remember
Teach me and I will learn
Taco,
what about writing your VB App that returns XML
as a string from a VB Com component ?
do your ADO specific stuff where it should live
(in VB Code) and just call that from CF
<cfscript>
myObj =
createObject('com','myADOComObj');
strXML = myObj.getXMLString( param1, param2 ....
);
</cfscript>
<cfoutput>#strXML#</cfoutput>
and your done!
Pat
yeah yeah month slate rI am still clowning around
with ADO (I don't give up)
Anyone ANY idea why
ADOConn = createObject("com",
"ADODB.Connection");
ADOConn.Open(
"Driver={SQL
Server};SERVER=.;UID=obscured;PWD=obscured;DATABASE=dbCCDB_development;");
Gives me
An exception occurred when executing a Com
method.
The cause of this exception was that:
AutomationException: 0x80020005 - Type mismatch. in 'Provider'.
Before anyone asks (they always do when you mention ADO) its to get a
stream from FOR XML in MS SQL (yup the topic I touched about 200 times on
this list and 300 times elsewhere.)......
Register now for the 3rd National Conference on Tourism Futures, being held in Townsville, North Queensland 4-7 August - www.tq.com.au/tfconf
| ---
You are currently
subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a
blank email to [EMAIL PROTECTED] Aussie Macromedia
Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
|
