[phorm] [Phorm:] Re: Alert 010 - Unable to open DB variables file
- From: webbbs@xxxxxxxxx
- To: support@xxxxxxxxx
- Date: 23 May 2003 14:02:59 -0000
The following new message has been posted on Phorm Support Forum at
<http://www.phorm.com/support/>.
***************************************************************************
MESSAGE: (#2729) Re: Alert 010 - Unable to open DB variables file
<http://www.phorm.com/support/?rev=2729>
AUTHOR: Caleb Shiffer
DATE: May 23, 2003 at 10:02 a.m. EST
Reply To: (#2728) Re: Alert 010 - Unable to open DB variables file
Author: Patrick O'Hara
Date: May 22, 2003 at 8:33 p.m. EST
Ok, now here's what I've got:
<?php
# This is the global configuration file. It's read every time Phorm runs.
# If the form calling Phorm has a local (form-specific) configuration file,
# settings in it will override settings here.
# This variable indicates that a local config file is NOT required.
$trade = $trade . "%";
$have = $have . "%";
$need = $need . "%";
$trade_col = "";
$have_col = "";
$need_col = "";
if (is_array($HTTP_POST_VARS)) {
while (list($temp_key, $temp_value) = each($HTTP_POST_VARS))
if ($temp_value == "ON") {
if (ereg("^have_", $temp_key))
$have_col .= "$temp_key,";
if (ereg("^need_", $temp_key))
$need_col .= "$temp_key,";
}
}
substr_replace($have_col, "", -1);
substr_replace($need_col, "", -1);
$PHORM_RCONFIG = "N";
$PHORM_ALERTTO = "caleb.shiffer@xxxxxxxxxxxx"; // Change to your email address
$PHORM_TO = "caleb.shiffer@xxxxxxxxxxxx"; // Change to your email address
$PHORM_SUBJECT = "Form Data"; // The subject of the email message
$PHORM_TMPL = ph_GENERIC; // A generic email template
$PHORM_ACK = "ack.htm"; // A generic ack template
$DHost = "localhost";
$DUser = "lebshif_lebshif";
$DPass = "mjbyy64e";
$DBase = "lebshif_tickets";
$PHORM_MYTABLE = "Tickets";
$PHORM_MYVARS = "TradeType=trade%, Have=have%, Need=need%, email=email,
AIM=AIM, bridge=bridge, ants=ants, nancies=nancies, desc=Description";
?>
I've tried moving the "trade", "have", and "need" variables to the beginning
of the list since they were being populated by the "desc" values... but now
all I get is a blank column for the first 3 fields. And an email telling me
there's an error in the SQL syntax.... also, the email that usually gets sent
with all the selections made, is coming through empty.... I'm guessing I
didn't manipulate the code you posted correctly, although I am really trying
to understand it all! Thanks again!
Caleb
***************************************************************************
This is an automatically-generated notice. If you'd like to be removed from
the mailing list, please visit Phorm Support Forum at
<http://www.phorm.com/support/>, or send your request to webbbs@xxxxxxxxxx If
you wish to respond to this message, please post your response directly to the
board. Thank you!
-------------------------------------------------
You are receiving this message because you are subscribed to the Phorm mailing
list. To send messages to the mailing list, simply send email to
phorm@xxxxxxxxxxxxx from the address you have subscribed. You may unsubscribe
from the list by sending email to phorm-request@xxxxxxxxxxxxx with
'unsubscribe' in the SUBJECT field.
Other related posts:
