Re: Every other record deleted
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 63661
interpreted = N
texte = On Thu, 22 Dec 2005 10:49:29 -0600 Donovan Brooke
wrote: > Well, I didn't see anything from first glance that would delete > every other record exactly. Thanks for the extra set of eyes > > A couple of comments.. > > Your use of [URL][/URL] should be increased greatly, unless you > have very maticulous form variable checks. If someone puts an > "&" or "=" in the zip (for example), it will mess with your editing context. > There are other examples as well... but URL'ing just about every > value in an append will eliminate those problems. I didn't [url] the inputs that I 'control' i.e. the zipcode is entered via a drop-down, etc. Actual form here: http://www.searchboise.com/login.html I'll keep looking though, because this is on the top of my mind as a potential culprit... > > I don't know exactly what you mean by "shared server" but if > there is a chance that database could be hit by more than one > user at the same time, you may want to put the [exclusivelock db=..] > context to work. I do this in any sensitive database. Shared server = other websites (my own & other developers) sites all hosted at once. Theoretically, all sites are protected from one another via sandboxes, but as for users hitting my ..dbs simultaneously, yes that is highly probable. > > Lastly, if you are on apache, I would make use of the global > search shell command (not sure what the best one would be) > and look for any file that contains the > phrase "listings_UNAPPROVED.db" to see if there is a stray > file somewhere that could have caused the "every other issue". I am on apache, but that's where things get over my head and I honestly don't know what access I do/don't have regarding apache. My server admin typically handles apache issues. I'll look into this a little more. Thanks again for your help. -Dan ------------------------------------------------------------- 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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
On Thu, 22 Dec 2005 10:49:29 -0600 Donovan Brooke wrote: > Well, I didn't see anything from first glance that would delete > every other record exactly. Thanks for the extra set of eyes > > A couple of comments.. > > Your use of [url][/URL] should be increased greatly, unless you > have very maticulous form variable checks. If someone puts an > "&" or "=" in the zip (for example), it will mess with your editing context. > There are other examples as well... but URL'ing just about every > value in an append will eliminate those problems. I didn't [url] the inputs that I 'control' i.e. the zipcode is entered via a drop-down, etc. Actual form here: http://www.searchboise.com/login.html I'll keep looking though, because this is on the top of my mind as a potential culprit... > > I don't know exactly what you mean by "shared server" but if > there is a chance that database could be hit by more than one > user at the same time, you may want to put the [exclusivelock db=..] > context to work. I do this in any sensitive database. Shared server = other websites (my own & other developers) sites all hosted at once. Theoretically, all sites are protected from one another via sandboxes, but as for users hitting my ..dbs simultaneously, yes that is highly probable. > > Lastly, if you are on apache, I would make use of the global > search shell command (not sure what the best one would be) > and look for any file that contains the > phrase "listings_UNAPPROVED.db" to see if there is a stray > file somewhere that could have caused the "every other issue". I am on apache, but that's where things get over my head and I honestly don't know what access I do/don't have regarding apache. My server admin typically handles apache issues. I'll look into this a little more. Thanks again for your help. -Dan ------------------------------------------------------------- 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://webdna.smithmicro.com/
"Dan Strong"
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:
[WebDNA] Converting a CSV file to a WebDNA db automatically? (2016)
Two stores, one server (1998)
Date Calulation (1997)
What file? (1997)
Separate SSL Server (1997)
Locking up with WebCatalog... (1997)
Too Much Rootbeer Free Offer (1997)
[WebDNA] preventing hackers from posting their own (altered) (2009)
DomainList (2005)
carriage returns in data (1997)
Cart Template (1997)
PCS Frames (1997)
Return records from another (1997)
Question re: FlushDatabases (1997)
Almost a there but..bye bye NetCloak (1997)
[WebDNA] Why doesn't this returnraw redirect to the new page? (2009)
[ShowIf] and empty fields (1997)
A few questions. . . (1997)
Image maps/Webcat (1997)
Grant, please help me ... (1997)