Re: Appending Record Prob

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 37337
interpreted = N
texte = Problem solved:in [Append db=testcatalog.db]RoomCategory=[RoomCategory]&ProductType=[ProductType]&SKU= [SKU][/Append]I had [Append db=TESTcatalog.db]RoomCategory=[_ADD_RC]&ProductType=[_ADD_PT]&SKU=[_ADD_SKU ][/Append]looking @ the form var's, we noticed this little headache and cursed it to hell. :)here's the code as it stands now, i'll reincorporate it into the designed page. Untitled Document [text]_SKU=[/text] [text]_producttype=[/text] [text]_RoomCategory=[/text] [text]_editmode=[/text] [text]_ADD=[/text] [text]_ADD_RC=[/text] [text]_ADD_PT=[/text] [text]_ADD_SKU=[/text] [text]_verify=[/text] [text]_submit=[/text] [text]_appendrecord=[/text]
ADD a Record:
[showif [_verify]=1] Is this correct?

Room Category:[_ADD_RC]
Product Type:[_ADD_PT]
SKU:[_ADD_SKU]

or go back number found is: [numfound]
index of number found is: [index]
[formvariables] [name] = [value]
[/formvariables]
[/showif] [showif [_appendrecord]=1]record added.[Append db=testcatalog.db]RoomCategory=[RoomCategory]&ProductType=[ProductType]&SKU= [SKU][/Append] number found is: [numfound]
index of number found is: [index]
[formvariables] [name] = [value]
[/formvariables]
[/showif] ----- Original Message ----- From: Gene Beljaeff To: WebCatalog Talk Sent: Friday, July 20, 2001 2:45 PM Subject: Re: Appending Record Prob > Have you tried using 'static' data instead of variables in the append context? For example, ...&DB_FIELD=test... instead of ...&DB_FIELD=[url][incomingVariable][/url]... ? > > Also, copy and paste your actual code so we can view it. Possibly you have a syntax error you're not seeing. > > Gene > > > >I have tried both what you and glenn have said to no avail :( ....it's > >still adding a new, but blank, record > > > >The only other thing I can think of doing is doing it command form, but > >EVERYone has said that using commands is a bad thing. > > > >Any other suggestions guys? > > > > > >----- Original Message ----- > >From: Aaron Lynch > >To: WebCatalog Talk > >Sent: Friday, July 20, 2001 2:25 PM > >Subject: Re: Appending Record Prob > > > > > >> You should wrap every field in a [url] when appending > >> > >> > >> > >> > >> ]On 7/20/01 11:21 AM, The Defendant Glenn Busbin > >> Confessed: > >> > >> >> > >> >> > >> >> When I download the db from the web server and open it, I see a new > >record > >> >> created, yet it has blanks in the fields. Anyone know what the problem > >is? > >> >> > >> > > >> > Try using [replace] instead of [append] and use &append=T in the code. > >> > > >> > ------------------------------------------------------------- > >> > 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 > >> System Administrator > >> NineWire Digital Solutions || http://ninewire.com > >> > >> A common mistake that people make when trying to design something > >completely > >> foolproof is to underestimate the ingenuity of complete fools. > >> -Douglas Adams > >> > >> > >> ------------------------------------------------------------- > >> 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/ ------------------------------------------------------------- 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: Appending Record Prob (Ron Ceballos 2001)
  2. Re: Appending Record Prob (Gene Beljaeff 2001)
  3. Re: Appending Record Prob (Ron Ceballos 2001)
  4. Re: Appending Record Prob (Aaron Lynch 2001)
  5. Re: Appending Record Prob (Glenn Busbin 2001)
  6. Appending Record Prob (Ron Ceballos 2001)
  7. Appending Record Prob (Ron Ceballos 2001)
Problem solved:in [Append db=testcatalog.db]RoomCategory=[RoomCategory]&ProductType=[ProductType]&SKU= [SKU][/Append]I had [Append db=TESTcatalog.db]RoomCategory=[_ADD_RC]&ProductType=[_ADD_PT]&SKU=[_ADD_SKU ][/Append]looking @ the form var's, we noticed this little headache and cursed it to hell. :)here's the code as it stands now, i'll reincorporate it into the designed page. Untitled Document [text]_SKU=[/text] [text]_producttype=[/text] [text]_RoomCategory=[/text] [text]_editmode=[/text] [text]_ADD=[/text] [text]_ADD_RC=[/text] [text]_ADD_PT=[/text] [text]_ADD_SKU=[/text] [text]_verify=[/text] [text]_submit=[/text] [text]_appendrecord=[/text]
[thisurl]?_ADD=1&_verify=1>ADD a Record:
[showif [_verify]=1] Is this correct?

Room Category:[_ADD_RC]
Product Type:[_ADD_PT]
SKU:[_ADD_SKU]
[thisurl]?_submit=1>

or go back number found is: [numfound]
index of number found is: [index]
[formvariables] [name] = [value]
[/formvariables]
[/showif] [showif [_appendrecord]=1]record added.[Append db=testcatalog.db]RoomCategory=[RoomCategory]&ProductType=[ProductType]&SKU= [SKU][/Append] number found is: [numfound]
index of number found is: [index]
[formvariables] [name] = [value]
[/formvariables]
[/showif] ----- Original Message ----- From: Gene Beljaeff To: WebCatalog Talk Sent: Friday, July 20, 2001 2:45 PM Subject: Re: Appending Record Prob > Have you tried using 'static' data instead of variables in the append context? For example, ...&DB_FIELD=test... instead of ...&DB_FIELD=[url][incomingVariable][/url]... ? > > Also, copy and paste your actual code so we can view it. Possibly you have a syntax error you're not seeing. > > Gene > > > >I have tried both what you and glenn have said to no avail :( ....it's > >still adding a new, but blank, record > > > >The only other thing I can think of doing is doing it command form, but > >EVERYone has said that using commands is a bad thing. > > > >Any other suggestions guys? > > > > > >----- Original Message ----- > >From: Aaron Lynch > >To: WebCatalog Talk > >Sent: Friday, July 20, 2001 2:25 PM > >Subject: Re: Appending Record Prob > > > > > >> You should wrap every field in a [url] when appending > >> > >> > >> > >> > >> ]On 7/20/01 11:21 AM, The Defendant Glenn Busbin > >> Confessed: > >> > >> >> > >> >> > >> >> When I download the db from the web server and open it, I see a new > >record > >> >> created, yet it has blanks in the fields. Anyone know what the problem > >is? > >> >> > >> > > >> > Try using [replace] instead of [append] and use &append=T in the code. > >> > > >> > ------------------------------------------------------------- > >> > 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 > >> System Administrator > >> NineWire Digital Solutions || http://ninewire.com > >> > >> A common mistake that people make when trying to design something > >completely > >> foolproof is to underestimate the ingenuity of complete fools. > >> -Douglas Adams > >> > >> > >> ------------------------------------------------------------- > >> 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/ ------------------------------------------------------------- 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/ Ron Ceballos

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:

Rhapsody? (1997) [WebDNA] test 2 (2009) How can I Add several Items into the cart at once? (1997) New cart in ShoppingCarts (2003) WebCat for Unix?? (1997) sku not found (1997) Updating Prices in DB (working) (1999) ConvertChars (1998) For those of you not on the WebCatalog Beta... (1997) Problems adding stuff to the shopping cart. (1997) Capitalize (2000) 'page impression' techniques for banner ads (1999) WebCat and Mac OS X Server problem (2001) Location of Browser Info.txt file (1997) How can I record purchases to a database? (1998) Re2: frames & carts (1997) upgrading (1997) [WebDNA] Why doesn't this returnraw redirect to the new page? (2009) Country & Ship-to address & other fields ? (1997) Kaaaaahhhhhhhnnnnnnn! (1997)