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:

pc (1997) WebCat2 - [format thousands] (1997) RE: Upload (1998) WebCat2 Append problem (B14Macacgi) (1997) Misc Stuff That Might Help (1997) Format Thousands Looks Busted (2000) WebDNA handler in Httpd.conf being erased (2005) Frames and WebCat (1997) [Webcat 2]Next (1997) Bugs in IE 6.0 ? (2003) WebMerchant Problem (1999) WebCatalog Upgrade Pricing? (1997) [WebDNA] Triggers issue, or sendmail? (2012) no global [username] or [password] displayed ... (1997) Search design (1997) Search or Lookup before Append (1998) no global [username] or [password] displayed ... (1997) Show shoppingcart after remove last item (1997) [WebDNA] Not even sure what to ask for help on. . . :( (2008) Updating fields from different platforms (1998)