I have a MAC user that is using BBEdit to create and edit .adp files and the variables sucked out of the database do not show up... The error message is:
Error: can't read "db": no such variableFrom this code:
<% set db [ns_db gethandle] set user_id [ad_verify_and_get_user_id] set selection [ns_db 0or1row $db "select first_names, last_name, email, screen_name, tgn_status, registration_date from users where user_id=$user_id"] # and more not shown...
So, Linux RH7/ AOLserver AOLserver/3.3.1+ad13 / Postgres 7.1 Doesn't like MAC .adp files...
I first disovered that just saving the file in my Windows (DOS) editor makes the file work just fine because saving converts the CR to a CRLF pair.
Also I can translate the MAC CR to the *NiX LF character using this *Nix command:
tr ' ' ' ' < mac1.adp > lixux1.adp
I post this for others who might run into this problem...
I wonder if there are options with BBEDIT to save the file either with the *nix LF or dos CRLF pair so that we don't have to do the "tr..." conversion every time an .adp file is uploaded.
IF there is a BBEDIT user out there, please tell me how to set it up for *nix or dos new lines.