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:

Webstar V and Webcatalog (2001) RE: Languages (1997) Bulletin Board.... (2000) [date format] w/in sendmail (1997) Ooops-Serial Number for NT (1997) why won't this TCPConnect/Send work? (2004) Alternating colors (1997) [addlineitems] display (1997) WebCat 3.04-3.07 plug-in dying on server.... (2000) why is this line in GeneralStore? (1998) 2.0 Info (1997) Shopping cart not being assigned (1999) Country & Ship-to address & other fields ? (1997) [WebDNA] search command problem (2009) How to Display text in empty fields (1997) Display [price] in banner ad (1998) Ampersand Character (&) (1997) [OT] Getting a domain listening on port 443 and port 80? (2003) The IBC root beer has arrived! (1997) Answer: WebDelivery downloads alias, not original ? (1997)