Re: Help! I've fallen in Structured Query Language and can'tget

This WebDNA talk-list message is from

2002

It keeps the original formatting. numero = 40709
interpreted = N
texte = this is what I use to transfer data from SQL to a webcat db.[SQLdsn=sqlserver&username=theusername&password=thesecretpassword&statement=SELECT * FROM vw_ItemFamily][WriteFile webcat.db]str_ItemNumber str_Title cur_Price[foundItems][str_ItemNumber] [str_Title] [cur_Price][/foundItems][/WriteFile][/SQL][!]note the placement of the [founditems][/founditems] and the[writefile][/writefile] tags, for the correct cr on the lines.Hope this helps.Pedro RiveraWebmaster - Designerwww.pssl.compedror@pssl.com714-891-3990 Ext. 817411070 Valley View St.Cypress CA. 90630-----Original Message-----From: Aaron Lynch [mailto:a.list@ninewire.com]Sent: Wednesday, June 19, 2002 12:51 PMTo: WebDNA-Talk@talk.smithmicro.comSubject: Help! I've fallen in Structured Query Language and can't getup.HI all.I'm totally new to SQL so I'm hoping somebody can help me.I have the servername, tablename, username, and password to a remote SQLserver, and I need to retrieve the data off it to move a client site towebcat.That's the extent of what I know about SQL. :)Can somebody help me with a SQL query that'll list all of the fields and getall of the data that I can write to a webcat DB?-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail toWeb Archive of this list is at: http://search.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: Help! I've fallen in Structured Query Language and can'tget (Pedro Rivera 2002)
Re: Help! I've fallen in Structured Query Language and can'tget (Aaron Lynch 2002)
Re: Help! I've fallen in Structured Query Language and can'tget (Pedro Rivera 2002)

this is what I use to transfer data from SQL to a webcat db.[SQLdsn=sqlserver&username=theusername&password=thesecretpassword&statement=SELECT * FROM vw_ItemFamily][WriteFile webcat.db]str_ItemNumber str_Title cur_Price[founditems][str_ItemNumber] [str_Title] [cur_Price][/foundItems][/WriteFile][/SQL][!]note the placement of the [founditems][/founditems] and the[writefile][/writefile] tags, for the correct cr on the lines.Hope this helps.Pedro RiveraWebmaster - Designerwww.pssl.compedror@pssl.com714-891-3990 Ext. 817411070 Valley View St.Cypress CA. 90630-----Original Message-----From: Aaron Lynch [mailto:a.list@ninewire.com]Sent: Wednesday, June 19, 2002 12:51 PMTo: WebDNA-Talk@talk.smithmicro.comSubject: Help! I've fallen in Structured Query Language and can't getup.HI all.I'm totally new to SQL so I'm hoping somebody can help me.I have the servername, tablename, username, and password to a remote SQLserver, and I need to retrieve the data off it to move a client site towebcat.That's the extent of what I know about SQL. :)Can somebody help me with a SQL query that'll list all of the fields and getall of the data that I can write to a webcat DB?-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail toWeb Archive of this list is at: http://search.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Pedro Rivera

DOWNLOAD WEBDNA NOW!

Re: Help! I've fallen in Structured Query Language and can'tget

2002

Top Articles:

Related Readings: