Zack Frankowski
|
Posted: 01/07/2005, 1:19 PM |
|
Hi All!
Quick question -- When I use a select statement ie: select * from apsvehicles where tag = '$tag' - it doesn't pull any results. When I change $tag to 4717 in the statement and hard code it, it works. When I leave out the where portion it works. I've tried using sql(q{$sqlstatement}) and making the sqlstatement = "select * from apsvehicles where tag = '$tag'; and nothing ever seems to work.
Any help would be much appreciative!!
Thanks - Zack
|
|
|
mrachow
Posts: 509
|
Posted: 01/09/2005, 1:00 AM |
|
The apostrophe (being right sql syntax) is preventing the $tag from being expanded.
Try To build something like
...where tag = '" . $tag . "'...
_________________
Best regards,
Michael |
|
|
Magnus
|
Posted: 07/13/2005, 10:16 AM |
|
Dear All;
I have a table in my database named 'registration' Then I have a form where people put in their username, password,email address,gender etc. I have another form called 'login' where user will type his username and password to have access to the website. My problem is that I don't know the correct sql statement I will use to allow already registered user into my website. I tried the code below but it retrieves all username and password from the 'registration' table but I want to check if the username and password corresspond with the login information.
Note: I am using JSP
String sqlQuery = "Select * From registration ";
ResultSet result = sqlStatement.executeQuery(sqlQuery);
while ( result.next() )
{
String user = result.getString("username");
String pass = result.getString("password1");
if( (request.getParameter("userName") == user)&& (request.getParameter("password")== pass) )
{
String redirectURL = "projectlist.jsp";
response.sendRedirect(redirectURL);
}
else
{
out.print("Did You Forgot Your Username And Password\n");
}
}
|
|
|
wkempees
|
Posted: 07/13/2005, 11:02 AM |
|
I am no JSP man.
The way you propose to do things is probably not the best and safest way
BUT
Your Select statement should be
SELECT * FROM registration WHERE username=user and password=pass
Please translate this to your language requirments.
IF user and pass are correctly filled you will end up with ONE row.
IF not result will be zero rows.
Hope this helps.
But I would recommend using the Login logic supplied by CCS.
That would (at least in PhP) return the Id for the user, after that
things are easy.
greetz,
Walter
|
|
|
Permana
|
Posted: 08/10/2005, 2:53 AM |
|
I Have a problem:
I have jsp file which is connect to Ms Acces, when i execute quey...there is an error:
C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\Test_jsp.java:67: cannot resolve symbol
symbol : method executeQuery (java.lang.String)
location: class java.lang.String
ResultSet _rs = sqlStatement.executeQuery(sqlQuery);
What shoud I do, so i may access my table in Ms Access ...
thx.
|
|
|