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:
really wierd browser truncating (1997)
Append command (2000)
Multiple prices (1997)
Running _every_ page through WebCat ? (1997)
Nesting FoundItem Context (1997)
RE: Ongoing group search problems ... (1997)
Snake Bites (1997)
createfolder default behavior (1998)
textarea inputs and returns (1999)
What do the &x=5&y=8 mean? (2002)
OT: Mobile Phone "mailto:" (2008)
Error Type 3 (1999)
WebCat2 several catalogs? (1997)
Store Builder (1999)
RE: Price recalc based on quantity (1997)
Summary search -- speed (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
Changing price for a SLU based on options (size, etc.) (1997)
More EudoraPro Email Options (1998)
Major bug report on rootbeer (1997)