Mailing List Archive


Back to the month index Back to the list index
CSM30014 (CSM30014@PAT.ITCARLOW.IE)
Thu, 15 Apr 1999 16:29:31 UTC 

Message-Id: <199904151533.QAA19161@tyndall.itcarlow.ie>
From: "CSM30014" <CSM30014@PAT.ITCARLOW.IE>
Date: Thu, 15 Apr 1999 16:29:31 UTC
Subject: Re: MSQL-LIST digest 617

Hey everyone,
                        I'm back with an entirely new problem! I'll explain:
I'm using w3-sql to create my web pages. The user can enter
values into text boxes, drop-downs, etc. So far they can add and
view info. in multiple tables linked to the web pages. I cannot get
my code to save ammendments to data existing in multiple tables
or delete records from multiple tables - editting and deleting from a
single table is fine with the if loop I've been using but now I need to
do it to multiple tables! Here's my code (I have only tried to edit so
far):

if ($EDITORDEL != "EDIT")
   {
    if (msqlQuery($db,"delete from sample2 where
idnum = $idnum") < 0)
       {echo("<CENTER><B>Could not delete $idnum
- $ERRMSG</B></CENTER>\n");}
    else
       {echo("<CENTER><B>Record $idnum
deleted</B></CENTER>\n");}
   }
else
   {
    if (msqlQuery($db, "update sample2"+
        " SET LoginID = '$LoginID',"+
        " Password = '$Password'"+
        " where idnum = $idnum") < 0)
        {echo("Error: $ERRMSG\n");}
    else
        {
        msqlQuery($db, "update test2"+
        " SET name = '$name',"+
        " number = '$number'"+
        " where number = $idnum");
        echo("<CENTER><B>record
updated</B></CENTER>\n");
        }
   }
msqlClose($db);
>

As you can see when the user clicks either the EDIT or DELETE
check box and clicks OK then the record where idnum = $idnum is
deleted, otherwise produce the error message. Else update the
record (and records in other tables) with the new values.

Any help would be appreciated.

                                Thanking you in advance,
                                                                        Alan.
From dl4g@virginia.edu Thu Apr 15 13:41:41 1999
Received: from mail.virginia.edu (mail.Virginia.EDU [128.143.2.9])
        by services.bunyip.com (8.8.5/8.8.5) with SMTP id NAA20476
        for <msql-list@services.bunyip.com>; Thu, 15 Apr 1999 13:41:27 -0400 (EDT)
Received: from unix.mail.virginia.edu by mail.virginia.edu id aa08889;
          15 Apr 99 13:41 EDT
Received: from node3.unix.Virginia.EDU (node3.unix.Virginia.EDU [128.143.2.33])
        by unix.mail.Virginia.EDU (8.8.7/8.8.7) with ESMTP id NAA302980
        for <msql-list@services.bunyip.com>; Thu, 15 Apr 1999 13:40:14 -0400
Date: Thu, 15 Apr 1999 13:40:14 -0400 (EDT)
From: Dave Ladd <dl4g@virginia.edu>
X-Sender: dl4g@node3.unix.Virginia.EDU
Reply-To: Dave Ladd <david@virginia.edu>
To: msql-list@services.bunyip.com
Subject: w3-msql won't work for me
In-Reply-To: <Pine.BSF.3.96.990224171443.514K-100000@fawn.hughes.com.au>
Message-ID: <Pine.A41.4.05.9904151315510.81718-100000@node3.unix.Virginia.EDU>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Hello all,

Here's the URL:
http://www.server.domain/~adminuser/cgi-bin/w3-msql.cgi/test1.html

Here's the error message:
W3-mSQL Error! - Can't stat script file (/test1.html)

Error at line 1

The test1.html test file is located in the user's (adminuser)
public_html directory.

Any ideas? I know this is probably an easy one, but I can't find it
in the documentation. And, I'm using 2.0.1 .

Thanks,
Dave Ladd 

--