RE: [PHP-WIN] cosine and sin in PHP on Win2K & IIS 5

2001-06-19 Thread Kelvin Luck
Hi, your problem is probably because php expects your angle to be expressed in radians and you are expressing it in degrees... To covert you can use these equations: degrees=radians*(180/PI) radians=degrees*(PI/180) hth, Kelvin. -Original Message- From: Bradley J Bristow-Stagg [mailto:[

RE: [PHP-WIN] anti-advocacy: Larry Seltzer, pcmag May'01 pub.

2001-05-09 Thread Kelvin Luck
If you want to respond to the article somewhere where it will be noticed by the author and people who have read the article then try the feedback form at the end of the article: http://www.zdnet.com/products/stories/reviews/0,4161,2714115,00.html I reckon that should bring our points to the noti

RE: [PHP-WIN] inserting quotes into a database...

2001-05-03 Thread Kelvin Luck
Hi, Thanks for the responses. I'd tried inserting '' instead of ' but I was then addSlashes() afterwards which meant that it didn't work because this had become \'\' before it met the query... It all works fine now, and I have enabled magic_quotes_sybase so I don't have to add any string processin

[PHP-WIN] inserting quotes into a database...

2001-05-03 Thread Kelvin Luck
Hi, I am having trouble inserting single quotes into an mssql database... my queries are taking the form: mssql_query("update discussiontopics set comment = '$comment', title = '$title', zoneid = $zoneID where topicid = $topicID"); If $comment or $title contain any single quote characters I get

RE: [PHP-WIN] inserting a bit into mssql database

2001-05-02 Thread Kelvin Luck
sorry, my mistake. the problem was elsewhere in my sql and nothing to with inserting a "bit"... I've figured it out now, Cheers, Kelvin. -Original Message----- From: Kelvin Luck [mailto:[EMAIL PROTECTED]] Sent: 02 May 2001 12:26 To: php recieve Subject: [PHP-WIN] inserting a

[PHP-WIN] inserting a bit into mssql database

2001-05-02 Thread Kelvin Luck
Hi, I am trying to insert into a column in a mssql 7 database with a datatype of "bit"... I have tried to insert 0, 1, '0', '1' but get an sql error every time ("Incorrect syntax near ...")... I also tried first using settype and setting my variables type to boolean (which seems to me to be the ne

[PHP-WIN] session tracking across a server farm

2001-04-30 Thread Kelvin Luck
Hi, I am just writing a user authentication system in php. I was planning to use session variables to track logged in users as they navigate the site... However, when the site is deployed it will be run on a server farm. Does this break session variables in php? If so does anyone know a way I can

RE: [PHP-WIN] apache 404 handler

2001-04-23 Thread Kelvin Luck
Thanks for the tip - it should be no problem to return 2.5Kb - I probably will be anyway, but to test it I was just returning a small string... Thanks for the help, Kelvin. -Original Message- From: Ben Cairns [mailto:[EMAIL PROTECTED]] Sent: 23 April 2001 10:54 To: [EMAIL PROTECTED] Cc: [

[PHP-WIN] apache 404 handler

2001-04-23 Thread Kelvin Luck
Hi, I know this is slightly off topic but I thought people using apache on windows might well be able to help me out... I have edited my httpd.conf file so that it now contains the line: ErrorDocument 404 /404handler.php This means that if someone goes to a dummy URL (which doesn't exist) on my

RE: [PHP-WIN] MSSQL text fields truncation

2001-04-20 Thread Kelvin Luck
Hi, Thanks for the responses, hit the nail right on the head. It works perfectly now, Cheers, Kelvin. -Original Message- From: Flint Doungchak [mailto:[EMAIL PROTECTED]] Sent: 19 April 2001 19:04 To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: [PHP-WIN] MSSQL text fields truncatio

[PHP-WIN] MSSQL text fields truncation

2001-04-19 Thread Kelvin Luck
Hi, I've got a new problem to do with how long things can be! This time it is from a text field so I would expect there to be no limit. But my text is being cut off after 4096 characters. I am selecting with a mssql_query and then using mssql_fetch_array to get the results. Has anyone run into thi

RE: [PHP-WIN] MSSQL varchar fields truncation revisited

2001-04-18 Thread Kelvin Luck
I had the same problem with a cold fusion page a while ago. It turned out that it was nothing to do with cold fusion but actually because I didn't have the latest version of the MDAC components installed onto my cold fusion server. There was a bug in previous versions which meant only the first 25

RE: [PHP-WIN] mssql and php4

2001-04-18 Thread Kelvin Luck
e someone elses machine... Thanks for all the help, Kelvin. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 18 April 2001 15:18 To: Kelvin Luck Cc: [EMAIL PROTECTED] Subject: Re: [PHP-WIN] mssql and php4 >Any other ideas? Other factors that could affect perfor

RE: [PHP-WIN] mssql and php4

2001-04-18 Thread Kelvin Luck
Thanks for the responses. I am already connecting to my database through TCP/IP (it was set as default in the client network utility). I was just providing the IP address of the database server to the mssql_pconnect function. I just experimented with adding an alias in the client network utility a

[PHP-WIN] mssql and php4

2001-04-17 Thread Kelvin Luck
Hi, I am just starting out with php and have managed to get it running OK on my machine (Win2K) and connecting to an MSSQL 7 database on another machine (on my LAN). However, it seems to run really slowly when accessing the database. It takes around 6 seconds for my simple page to appear... At fir