Heheh Adrain I was looking for that url :)
-----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 24 October 2003 15:37 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT ValueList() in T-SQL Scroll to the bottom... http://www.sqlteam.com/item.asp?ItemID=2368 Ade -----Original Message----- From: Justin [mailto:[EMAIL PROTECTED] Sent: 24 October 2003 15:33 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT ValueList() in T-SQL > You could use COALESCE to build a valid list. > If your on mssql. I am. Version 7. Not sure how to that? If I have Email ------------- [EMAIL PROTECTED] [EMAIL PROTECTED] How do I get [EMAIL PROTECTED],[EMAIL PROTECTED] SELECT EMail From Table Thanks -----Original Message----- From: Paul Fennell [mailto:[EMAIL PROTECTED] Sent: 24 October 2003 15:14 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT ValueList() in T-SQL -----Original Message----- From: Justin MacCarthy [mailto:[EMAIL PROTECTED] Sent: 24 October 2003 15:14 To: Cfuk Subject: [ cf-dev ] OT ValueList() in T-SQL Hi all, Anyone know of T-SQL to do the same as ValueList() ??? Am I stuck with a cursor? Thanks Justin -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
