I would like to drop this record set into a delimited file. I know how to do it in VFP by I haveing a little trouble in VBScript on an ASP page.

select docindex, required, datatype, docidxval from fndept.docindex where DOCCLASS='FinancialServicing' order by datatype desc, required, docidxval
to file c:\data\test.txt

Anyone have any suggestions?

I am also looking for some help with SQL statements in VB. Does any one know of any references/locations where I can find the scheme like this from VFP:
thanks

SELECT [ ALL | DISTINCT ]
[ TOP nHowMany [ PERCENT ] ]
eColumn1 [ AS ColumnName1 ]
[, eColumn2 [ AS ColumnName2 ] ... ]
FROM [ FORCE ]
[ Database1! ]Table1 [ LocalAlias1 ]
[ [ INNER | LEFT [ OUTER ] | RIGHT [ OUTER ]
| FULL [ OUTER ] ] JOIN
[ Database2! ]Table2 [ LocalAlias2 ]
[ ... ]
[ ON lJoinCondition1 ]
| , [ Database3! ]Table3 [ LocalAlias3 ]
[ ... ] ]
[ WHERE lConditions ]
[ GROUP BY GroupColumn1 [, GroupColumn2 ... ] ]
[ HAVING lGroupFilter ]
[ UNION [ ALL | DISTINCT ] SELECT ... ]
[ ORDER BY OrderCriteria1 [ ASC | DESC ]
[, OrderCriteria2 [ ASC | DESC ] ... ] ]
[INTO CURSOR CursorName [ NOFILTER ]
| INTO TABLE | DBF TableName
| INTO ARRAY ArrayName
| TO FILE FileName [ ADDITIVE ]
| TO PRINTER [ PROMPT ]
| TO SCREEN ]
[ PREFERENCE PreferenceName ]
[ NOCONSOLE ]
[ PLAIN ]
[ NOWAIT ]