Mailing List Archive


Back to the month index Back to the list index
Roberto Cota Rivas (al527892@mail.mty.itesm.mx)
Tue, 24 Sep 1996 15:22:18 -0600 (CST) 

Date: Tue, 24 Sep 1996 15:22:18 -0600 (CST)
From: Roberto Cota Rivas <al527892@mail.mty.itesm.mx>
Subject: [mSQL] [w3-msql] HELP WITH QUERY...
Message-Id: <Pine.A32.3.91.960924151756.59376A-100000@academ07.mty.itesm.mx>

Greetings!!
I am running w3-msql in an AIX machine...
I have the following problem:

I first declare a table with '<table>'

then the following:

<!msql if ($nombre_grupo!="")>
 <!msql query "SELECT DISTINCT materia, maestro, periodo, area,
   clasificacion, fecha FROM grupos WHERE materia=$nombre_grupo
   ORDER BY materia" r1>
 <TR>
 <!msql print_rows r1 "<TD>@r1.0<TD>@r1.1<TD>@r1.2<TD>@r1.3
   <TD>@r1.4<TD>@r1.5</TR>">
<!msql fi>

$nombre_grupo is the name of a menu in a Search form...
And I get the following error message:

W3-mSQL Error ! - mSQL Database Error
                            Error at line 29

                    parse error near "Artificial"

Where "Artificial" is the value of $nombre_grupo.

Line 29 is the <!msql query...> line.

Any suggestions?

Thanx!!!

Sincerely,
Roberto

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!