Re: Empty fields in database are causinf [if-field bla] toevaluate to true

[Frank Miedreich <miedreich@acm.org>]

******    message to minivend-users from Frank Miedreich <miedreich@acm.org>     ******

>******    message to minivend-users from Daniel Ceregatti <primus@sh.nu>
>******
>
>Hello,
>
>I recently imported a file which was exported by an excel spreadsheet in
>tab delimited format into my products database, using a method provided
>to me by predecessor. Basically, I open vi, s/""/|/g, s/"//g, s/|/"/g to
>eliminate all the double quoting. I then copy it to products.asc and
>make a query, forcing minivend to re-read it. Once I browse through my
>new products using a flypage.html, I keep getting empty
><select></select> tags on some fields which are supposed to be empty. I
>would like to have browsed the mailing list if I could, but apparently
>it's down to keep the robots out. I hope this is an easy issue to solve,
>I have to have this up very soon. Btw, I've only been using minivend for
>2 days now. (Is it obvious? :)
>
>Thanks in advance.
>
>Daniel Ceregatti
>
>primus@_nospam_.sh.nu
>-
>To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
>email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
>Archive of past messages: http://www.minivend.com/minivend/minivend-list

I suggest you check the content of products.asc.

If the relevant field has one or two quotes in it, it is not empty.

Unless you really need quotes in some database fields, I suggest you do
s/"//g in vi instead.

Frank

--
Frank Miedreich
Max-Planck-Institut fuer psychologische Forschung


-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list