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 = 40718
interpreted = N
texte = Doesn't this also assume you know that str_Title exists?I don't know the fieldnames in the Db.On 6/19/02 1:18 PM, Pedro Rivera mashed the following keys :> this is what I use to transfer data from SQL to a webcat db. > > [SQL > dsn=sqlserver&username=theusername&password=thesecretpassword&statement=SELE > CT * 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 Rivera > Webmaster - Designer > www.pssl.com > pedror@pssl.com > 714-891-3990 Ext. 8174 > 11070 Valley View St. > Cypress CA. 90630 > > -----Original Message----- > From: Aaron Lynch [mailto:a.list@ninewire.com] > Sent: Wednesday, June 19, 2002 12:51 PM > To: WebDNA-Talk@talk.smithmicro.com > Subject: Help! I've fallen in Structured Query Language and can't get > up. > > > 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 SQL > server, and I need to retrieve the data off it to move a client site to > webcat. > > 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 get > all 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 to > > Web 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/ ------------------------------------------------------------- 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:
Doesn't this also assume you know that str_Title exists?I don't know the fieldnames in the Db.On 6/19/02 1:18 PM, Pedro Rivera mashed the following keys :> this is what I use to transfer data from SQL to a webcat db. > > [SQL > dsn=sqlserver&username=theusername&password=thesecretpassword&statement=SELE > CT * 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 Rivera > Webmaster - Designer > www.pssl.com > pedror@pssl.com > 714-891-3990 Ext. 8174 > 11070 Valley View St. > Cypress CA. 90630 > > -----Original Message----- > From: Aaron Lynch [mailto:a.list@ninewire.com] > Sent: Wednesday, June 19, 2002 12:51 PM > To: WebDNA-Talk@talk.smithmicro.com > Subject: Help! I've fallen in Structured Query Language and can't get > up. > > > 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 SQL > server, and I need to retrieve the data off it to move a client site to > webcat. > > 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 get > all 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 to > > Web 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/ ------------------------------------------------------------- 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/
Aaron Lynch
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
How do you hide [math]stuff[/math] (1997)
Where's Cart Created ? (1997)
SKU lookup (1997)
Shipping calculations (1997)
[WebDNA] What's the next step? (2015)
latest version? (1998)
Where is f2? (1997)
Reversed words (1997)
[WebDNA] 2 cookies, same name different value (2016)
day of year (2001)
problems with 2 tags (1997)
problem serving foreign languages text (1997)
Showif, Hideif reverse logic ? (1997)
Help name our technology! (1997)
(ot) sitemap generator (1998)
log out (2001)
using showpage and showcart commands (1996)
Big Databases (1997)
WebCommerce: Folder organization ? (1997)
WebCat2.0 [format thousands .0f] no go (1997)