Sorry for the late repaly.
Everything working as planned
Thanks.
Yew12
Last Activity: Apr 27 '08, 08:45 PM
Joined: Mar 14 '08
Location:
-
Ok first form the one which get the users input
[PHP]<form name="form1" method="post" action="Logon1. php">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFF F">
<tr>
<td colspan="3"><st rong>Login </strong></td>
</tr>
...Leave a comment:
-
I have changed it so it now reads
[PHP]$sql="SELECT * FROM $tbl_name WHERE username='$user name' and password='$pass word'";
$stmt=odbc_prep are($conn, $sql) or die (Print "odbc prepare error".odbc_err or());
$result=odbc_ex ecute($stmt) or die (Print "result error ".odbc_error(). '-'.odbc_errormsg ());
[/PHP]
Any other ideas.
Thanks so muchLeave a comment:
-
Thanks, added it in the error reads
result error 07001-[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
I have tried looking checking that the names are right and everything but still no luck.
Also thanks for helping a novice you are helping more that you think.Leave a comment:
-
Thanks very much, but unfortunatly i still get an 07001.Leave a comment:
-
I get the result error. with out a odbc error number.Leave a comment:
-
Sorry I will try to clarify,
I have one HTML page with two input boxes on and it passes the variables username and password to this php script where I want to check to see if they are valid and if so send them to another page, if not then display message "Wrong Login".
Any other questions just ask.Leave a comment:
-
Simple Login using Ms Access ODBC
I am trying to create a simple login for my webpage, but Im a bit of a novice and cannot see where Im going wrong any help would be much appreciated.
I'm using an access database and ODBC.
The code I have got is below;
[PHP]<?php
$tbl_name="tblC ustomer";
$connstr = "DRIVER={Micros oft Access Driver (*.mdb)}; DBQ=" . realpath("2Poin tB.mdb").";";... -
Thanks very much that help a lot. At least now I get an error.
[PHP]<html>
<head><title> Customer Information Updated</title></head>
<body>
<?php
$connstr = "DRIVER={Micros oft Access Driver (*.mdb)}; DBQ=" . realpath("2Poin tB.mdb").";";
$conn=odbc_conn ect($connstr,'' ,'') or die(Print "connect error: ".odbc_error()) ;...Leave a comment:
-
Trying to update data in access database
I have been trying to update the details in a access database but, all I get is a white screen and all the errors I have built-in give me no help at all.
All help is greatly appreciated.
[PHP]<html>
<head><title> Customer Information Updated</title></head>
<body>
<?php
$connstr = "DRIVER={Micros oft Access Driver (*.mdb)};... -
T_constant_encapsed_string
I'm hoping some one will know where I've gone wrong with the following.
[PHP]<?php
putenv("TNS_ADM IN=/u1/oracle/Produdcts/shu10g/network/admin");
$con = OCIlogon("Usern ame","Password" ,"shu10g");
$query "Begin p_room_content( 1,1,:var_room_i d, :var_fixture_id , :var_fixture_de scription); End; ";
$stmt = OCIParse($con, $query)... -
Connecting to a Access database using ODBC and no DNS
Hi, I'm having problems connecting to a Microsoft Access database. Im using PHP and ODBC but im not using a DNS.
The scripts below give no errors but I they only give me a blank white screen.
Any would be greatly appresiated. Please help.
Script 1
[php]
<HTML>
<HEAD>
<TITLE> Browse the race table </TITLE>
</HEAD>
<BODY>
... -
Using a text box disply date and time.
We are trying to get the following script to display the full date and time. The field we are calling does have both date and time in. Unfortunatly its only returning the date.
So I tried putting the sql "to_date('Adate ','dd/mm/yyyy hh24:mi')" to disply the full field. No Luck
Any help is much appresiated. Thanks.[php]<HTML>
<HEAD><TITLE> Property Results </TITLE>
</HEAD>... -
Sorry I found out that () brackets were the key, so I include the code for others
Select TO_CHAR(adate, 'dd/Mon/yyyy hh24:mi')as adate, to_CHAR(ADATE + ("Duration(Min) "/1440), 'dd/Mon/yyyy hh24:mi') as NEW_ADATE, "Duration(M in)" from Appointment;
Thanks anywayLeave a comment:
-
Adding minutes to a date field
Ok I have a date field called ADATE and I want to add the column "Duration(M in)" to this date.
I have had ago at the code but it still doesn't work.
I have tried dividing the added "Duration(M in)" but the answers are incorrect each time.
Select TO_CHAR(adate, 'dd/Mon/yyyy hh24:mi')as adate, to_CHAR(ADATE + "Duration(Min)" , 'dd/Mon/yyyy hh24:mi') as NEW_ADATE, "Duration(M in)"... -
Yew12 replied to PL/SQL:PLS-00410 duplicate fields in RECORDTABLE or argument list are not permittedin OracleThanks
Now to execute the code we used the following statment
VARIABLE g_error VARCHAR2(200);
EXECUTE p_check_room_al loc_dates (26, 1, '12-MAR-2008', '24-MAR-2008', :g_error);
Print g_error;
As we know that the following booking is already in use it does give the error and does not insert the record, but if we enter data that should not fail the g_error comes back blank but...Leave a comment:
-
Yew12 replied to PL/SQL:PLS-00410 duplicate fields in RECORDTABLE or argument list are not permittedin OracleAfter messing with the code some more and taking out the line p_error varchar
the compliation errors go away.
But the script still doesn't perform the correct action.
hope this helps...Leave a comment:
-
Yew12 replied to PL/SQL:PLS-00410 duplicate fields in RECORDTABLE or argument list are not permittedin OracleNo. It gives me the response
Warning: Procedure created with compilation errors.
So I used the following script to check the errors.
show errors procedure p_check_room_al loc_dates
That's how I got the unhelpful responses from PL/SQLLeave a comment:
-
Yew12 replied to PL/SQL:PLS-00410 duplicate fields in RECORDTABLE or argument list are not permittedin OracleSorry but we are unsure as to what you mean.
If you are meaning the p_error then we have used it several times.
This procedure is only going to be used on one table.
Thank you very much for your patience with a novice.Leave a comment:
-
Yew12 started a topic PL/SQL:PLS-00410 duplicate fields in RECORDTABLE or argument list are not permittedin OraclePL/SQL:PLS-00410 duplicate fields in RECORDTABLE or argument list are not permitted
Hi,
The following code is supposed to stop a booking being made if falls between another bookings start and end date.
Unfortunately I get the following error message
PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted
Any help would be greatly appreciated.
Thanks in advance
[code=oracle]
CREATE OR REPLACE PROCEDURE...
No activity results to display
Leave a comment: