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:

    
  1. Re: Help! I've fallen in Structured Query Language and can'tget (Pedro Rivera 2002)
  2. Re: Help! I've fallen in Structured Query Language and can'tget (Aaron Lynch 2002)
  3. Re: Help! I've fallen in Structured Query Language and can'tget (Pedro Rivera 2002)
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)