Search found 92 matches
- Thu Jul 30, 2009 4:08 am
- Forum: PHP - Code
- Topic: schedule tasks Batch file
- Replies: 6
- Views: 183
Re: schedule tasks Batch file
Reinstalled PHP 5, now everything working correctly 
- Wed Jul 29, 2009 6:28 am
- Forum: PHP - Code
- Topic: schedule tasks Batch file
- Replies: 6
- Views: 183
Re: schedule tasks Batch file
Ok, you where right I had two php.ini's
Now the code executes from the command line but throws an error about a missing dll "php4ts.dll"
Thanks
Geoff
Now the code executes from the command line but throws an error about a missing dll "php4ts.dll"
Thanks
Geoff
- Wed Jul 29, 2009 5:48 am
- Forum: PHP - Code
- Topic: schedule tasks Batch file
- Replies: 6
- Views: 183
Re: schedule tasks Batch file
Thanks, I'm using PHP CLI Shown by typing php -v C:\Documents and Settings\ajlsvradmin>php -v PHP 5.2.5 (cli) (built: Nov 8 2007 23:18:51) Copyright (c) 1997-2007 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies Also there is only one php.ini on the IIS server and this ha...
- Wed Jul 29, 2009 4:26 am
- Forum: PHP - Code
- Topic: schedule tasks Batch file
- Replies: 6
- Views: 183
Re: schedule tasks Batch file
No none of them work when called from the batch file. I did have an "include" to a connection php file but have moved all this into my main php file. Now its fails on the mysql_connect() Its like when mysql is called from the command line it doesn't exist, but if called from the browser it...
- Tue Jul 28, 2009 7:13 am
- Forum: PHP - Code
- Topic: schedule tasks Batch file
- Replies: 6
- Views: 183
schedule tasks Batch file
Hello I have the following bat file that calls up a php script @echo OFF "c:\Progra~1\php\php.exe" email_open_vsi.php %* This is supposed to run a php script that fires off an email however I cant get it to work from the batch file, running the php script from the browser is not a proble...
- Mon Mar 02, 2009 6:27 am
- Forum: PHP - Code
- Topic: Query was empty
- Replies: 0
- Views: 95
Query was empty
Hello I have a tick box on my form ($commupdate) which decides if extra data is posted to a DB or not. The code if ( $commupdate == 'on' ) { $sql="update projects set VSI_NUMBER='$VSI_NUMBER',DESC1='$DESC1',Salesman='$Salesman',ENGINEER ='$ENGINEER',Prod_Spec ='$Prod_Spec' ...
- Thu Jan 08, 2009 7:35 am
- Forum: PHP - Code
- Topic: Insert into mysql condition checkbox
- Replies: 3
- Views: 241
Re: Insert into mysql condition checkbox
Finally sorted it by commenting the below line out, dont know what it was doing there but
it was causing the page to display "Query was empty" error, due to $sql1 being empty
Thanks
it was causing the page to display "Query was empty" error, due to $sql1 being empty
Code: Select all
//$result=mysql_query($sql1,$connection) or die(mysql_error());- Thu Jan 08, 2009 4:20 am
- Forum: PHP - Code
- Topic: Insert into mysql condition checkbox
- Replies: 3
- Views: 241
Insert into mysql condition checkbox
Hello I have the following code which insert values into two mysql tables "projects" and "project_comments" $sql="update projects set VSI_NUMBER='$VSI_NUMBER',Salesman='$Salesman',ENGINEER ='$ENGINEER',Prod_Spec ='$Prod_Spec' ,CUSTOMER ='$CUSTOMER',SALESGROUP ='$...
- Wed Jul 16, 2008 9:33 am
- Forum: Databases
- Topic: MSSQL Query on a Query??
- Replies: 4
- Views: 633
Re: MSSQL Query on a Query??
Found the answer here
http://forums.devshed.com/ms-sql-develo ... 54974.html
The dreaded, evil "select star" apparently!
thanks
Geoff
http://forums.devshed.com/ms-sql-develo ... 54974.html
The dreaded, evil "select star" apparently!
thanks
Geoff
- Wed Jul 16, 2008 8:26 am
- Forum: Databases
- Topic: MSSQL Query on a Query??
- Replies: 4
- Views: 633
Re: MSSQL Query on a Query??
Thanks
I added
I now get this?
Server: Msg 207, Level 16, State 3, Line 2
Invalid column name 'Finmth'.
I added
Code: Select all
HAVING Finmth ='0'
Server: Msg 207, Level 16, State 3, Line 2
Invalid column name 'Finmth'.
- Wed Jul 16, 2008 7:34 am
- Forum: Databases
- Topic: MSSQL Query on a Query??
- Replies: 4
- Views: 633
MSSQL Query on a Query??
Hello I have a query which displays data in a specified way SELECT Count([ECR].ECR_Number) AS CountOfECR_Number,CAST(DATEPART(mm, CreatedDate) AS NVARCHAR) + '/'+ CAST(DATEPART(yy, CreatedDate) AS NVARCHAR)AS fn,CASE CAST(DATEPART(mm, CreatedDate) AS NVARCHAR) + '/'+ CAST(DATEPART(yy, CreatedDate) A...
- Fri Jul 04, 2008 8:57 am
- Forum: PHP - Code
- Topic: Order by specified Array?
- Replies: 2
- Views: 159
Re: Order by specified Array?
Thanks Chris I managed to generate the require sort order within SQL using ms access first now I need to convert the sql used by access, there are difference between the two, IIF in access and CASE in mssql. SELECT Count([dbo_ECNs by month].ECN_Number) AS CountOfECN_Number, [dbo_ECNs by month].theda...
- Thu Jul 03, 2008 6:32 am
- Forum: PHP - Code
- Topic: Order by specified Array?
- Replies: 2
- Views: 159
Order by specified Array?
Hi I have this code which returns 12 results, I would like them ordered by a specified Array, ie 10/2007, 11/2007, 12/2007, 01/2008 etc etc at the moment they are ordered like below. 33 1/2008 30 10/2007 28 11/2007 22 12/2007 30 2/2008 35 3/2008 35 4/2008 23 5/2008 27 6/2008 31 8/2007 38 9/2007 $con...
- Mon Jun 02, 2008 9:19 am
- Forum: PHP - Code
- Topic: Dropdown Refresh problem!
- Replies: 3
- Views: 426
Re: Dropdown Refresh problem!
Ok, solved
If anyone else has this problem the fix was to change
to
Not to sure why it worked but it does.
thanks
Geoff
If anyone else has this problem the fix was to change
Code: Select all
$cat=$HTTP_GET_VARS['cat'];Code: Select all
$cat=$_GET['cat'];thanks
Geoff
- Thu May 29, 2008 5:41 am
- Forum: PHP - Code
- Topic: Dropdown Refresh problem!
- Replies: 3
- Views: 426
Re: Dropdown Refresh problem!
Think it may be something to do with this section ////////// Starting of first drop downlist ///////// echo "<select name='cat' onchange=\"reload(this.form)\"><option value=''>Select one</option>"; while($noticia2 = mysql_fetch_array($quer2)) { if($noticia2['cat_id']==@$ca...