Hi all,
I have implemented the index server query via CF as outlined in the article
by Robert Everland on CF Comet
http://www.cfcomet.com/cfcomet/index_server/index.cfm?ArticleID=0306FEED-E87
3-4D21-881655F4EFB68127
and am wondering if the MaxRecords can be set before setting the query.
Yes, it can be done when looping round the recordset and creating the CF
query but I was hoping to gain a better understanding of the process and
this is a starting place.
Also it'd be good to know what the parameters indicated in the code are
doing:
<--SNIP-->
/* Create an instance of the ADO Connection COM object */
MyConnection = CreateObject("COM", "ADODB.Connection");
/* Set connection variables; the provider will stay the same */
MyConnection.Open("provider=msidxs;Data Source=#Catalog#", "#UserName#",
"#Password#", -1);
^
|
here
/* Execute the SQL against the ADO connection */
MyRecordset = MyConnection.Execute(SQL, 0, 8);
^ ^
| |
here
/* Return a collection of the fields returned by the SQL */
MyFields = MyRecordset.Fields;
<--SNIP-->
I have a feeling that this might be answered by Robert Everland himself ....
Thanks,
Keith
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
