Hi,
I have to schedule a program to run every night on a Windows 2003 machine.
To work correctly, this program require that the user that is running it must be LOGGUED (I cannot use the RUN AS XXX ACCOUNT function). So what I want to do is to automate everynight the Windows Login with the...
Well, my friends, the problem was the double double quotes. Also, by putting 200,* in the rows, everything came identical on every browser.
Thanks for your help.
Nick
Hi,
I'm developping an application and some of my users are on Safari for MAC.
I'm using a page with two horizontal frames. height of the first is 270 Height of the second is 530.
On IE it looks fine, but on Safari for MAC, it looks more like a 400 of height for both. Any code I can put to...
Really really strange here....
It works fine if I put the following code :
echo "<td bgcolor=\"$row_color\" align=\"center\" class=\"texte\">$date_created<br>$date_resolved";
$nb_days =(strtotime($date_resolved) - strtotime($date_created))/86400;
echo "<br>".$nb_days;
echo "</td>"...
The variables come from a MSSQL query which is done just before the function.
For the query, I do the usual code :
While ($ligne_students_quitted = mssql_fetch_array($result_students_quitted))
{
extract ($ligne_students_quitted);
$nb_days =(strtotime($date_resolved) -...
Yeah, I thought about this one. But when I remove the Quotes, if gives me this error :
Warning: strtotime() [function.strtotime]: Called with an empty time parameter. in c:\Inetpub\wwwroot\inv-dev\administrator\list_laptops_cases.php on line 247
If I just echo my variable $date_created and...
Ok, I tried with your example and everything works fine if I put the dates mannually in the code.
But if I try to use the variables, it just doesn't work. Here is my code :
$nb_days =(strtotime('$date_resolved') - strtotime('$date_created'))/86400;
Both strtotime return -1. I've enter...
Hello there,
I have a question,
I work on a system with a MSSQL database for DB server and PHP.
The MSSQL server date format is the following :
Feb 3 2005 12:00AM
I have two date fields and I just want to calculate the number of days between those two dates.
I tried with the following code...
Hi,
In a page, i'm using an array variable with multiple values.
Is there a way to transfert the entire variable values to another page without using a Form tag?
Can I put arrays in a session variable ?
Thank you.
I looked at the output of the Query and it is Null (not false).
I also tried to put the resource link identifier and it still doesn't work.
What is strange is the fact that it does only that to INSERT and UPDATE Queries, not for SELECT.
Another strange thing is the fact everything works fine...
Hi,
I have an application working fine on a Win2K machine, SQL7 client, and PHP5.
I Try (for internal reasons) to switch it to a WinXP, SQL2000, PHP5.
After the switch, everything works fine except for one thing. When I make a INSERT or UPDATE query, the query runs, but I always get the OR...
Thanx for your answers people. I'll be able to do what I want.
I'm working in a controlled environment (Intranet) so everyone have their Javascript enabled.
This forum is really useful.
Hi,
I need to use more that one submit button on a form (with a different value being processed).
With the TYPE="SUBMIT", everything works fine with the following code:
<form action="test2.php" method="POST" name="test">
<INPUT TYPE="SUBMIT" NAME="SUBMIT1" VALUE="1">
<INPUT TYPE="SUBMIT"...
Ok,
I found that Scope_identity is working only on SQL 2000 (I'm in 7.0)
What i'm using is the following query :
INSERT INTO tbl_cases (equipment_id, date_created, status, other_problem, owner, case_school, username, password, case_user_id)
SELECT
'$session_id_equipment',
'$now_date',
'1'...
Hi.
I'm using MS-SQL in my application and PHP.
I've been told to use SCOPE_IDENTITY() to get the the identity ID I just entered in a SQL query Insert.
Anyone know how to use this so I can use this identity in my PHP code ?
Thank you.
It's the same for doublequotes, MSSQL seems to take it as a normal character.
When the field is Null, is takes it as a blank variable.
If I write NULL, MSSQL takes it as a normal string.
So, after all, I think that checking only for quotes will do the job.
Thank for your support and advices.
For what I know, backslashes seems to be a character like any other one. I've done a couple of tests, and MSSQL always return the value, with the backslash included.
My concerns are that the little function only handle quotes (').
If I look at php.net, it says that mysql_real_escape_string handle the following characters: NULL, \x00, \n, \r, \, ', " and \x1a.
If I just handle quotes, is that a big security breach in my system ?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.