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:

Problem in 4.0 store thankyou page (2000) PIXO support (1997) Memory Leak (2000) What is a TAB (2003) storebuilder problems on RedHat 6.1 with webcat 3.08 (2000) Email notification to one of multiple vendors ? (1997) OT : Affiliate Schemes (2002) [WebDNA] Secure Cookies (2009) WebCatalog NT beta 18 problem (1997) [tcpsend] (2001) form variables and missing quantities! (2004) OT - SE robot question (2003) Summing fields (1997) [WebDNA] Captcha question (and free code) (2009) [WriteFile] problems (1997) HELP WITH DATES (1997) Shownext Tricks (2000) [sendmail] questions... (1997) can WC render sites out? (1997) Country & Ship-to address & other fields ? (1997)