On dinsdag 2 december 2003 9:41 Nitin told the butterflies:
> is this declared in php or javascript??
> depends on the syntax.....
>
> ----- Original Message -----
> From: "Caroline Jen" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, December 02, 2003 9:38 AM
> Subject: Select Records From the Database
>
>
> > I got "null" after selecting records from a table in
> > the database. The table is created by me. I know how
> > many records will be selected. Just cannot be null.
> >
> > I cannot help wonder if my SELECT statement is correct
> > - I want records to be selected if user_role is equal
> > to the userrole I supplied AND if journal_category is
> > equal to the category I supplied. My statement is:
> >
> > String query = "SELECT user_name FROM members WHERE
> > user_role = '" + userrole + "' AND journal_category = '" + category
> > + "'";
> >
> > Do anybody see any mistake?
> >
Looks like JavaScript to me ..
- php and Perl use $Var for variables and concats with a .
- ASP concats with the & sign, not sure about the "Variable name
prepending character" there might be none..
- JavaScript concats with + and has no "variable name prepending
character"
But unless you're sending the query over the QueryString or some other cool
thing in JavaScript I don't think I see anything happening with this little
fella.
Where and how are you trying to do something, Caroline?
Wouter
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
