Current location: Hot Scripts Forums » Programming Languages » PHP » Could having ^M in a query crash a server?


Could having ^M in a query crash a server?

Reply
  #1 (permalink)  
Old 09-15-04, 12:09 PM
mrnicksgirl mrnicksgirl is offline
New Member
 
Join Date: Mar 2004
Location: Chicago
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Question Could having ^M in a query crash a server?

I can't test this right now ..for reasons too complicated to explain. A script had been saved in dos mode so there was ^M at the end of each line...

this sql statement spans multiple lines:

$sql = "SELECT
empl_key,
bus_office,
bus_div
FROM
data_employee
WHERE
empl_dom = '" . $data['dom] . "'
AND
empl_user = '" . $data['user'] . "'
AND
empl_active = 1";

$result = $db->query( $sql );


And it appeared to crash at the line. (we are using pear, but I don't think that would matter?) There are many other factors that might cause the server to crash..but we thought maybe this might cause it? anybody know?
Reply With Quote
  #2 (permalink)  
Old 09-15-04, 03:44 PM
Eclipse's Avatar
Eclipse Eclipse is offline
Coding Addict
 
Join Date: May 2004
Location: Long Island, New York
Posts: 356
Thanks: 0
Thanked 0 Times in 0 Posts
I can't see why it would but just because I can't see them doesn't mean that they aren't there.
Reply With Quote
  #3 (permalink)  
Old 09-16-04, 03:05 PM
mrnicksgirl mrnicksgirl is offline
New Member
 
Join Date: Mar 2004
Location: Chicago
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Well turns out that query was used to setup session variables and my net admin installed a version of php that is buggy with sessions (4.2.1) and that caused it to bomb.

Nice huh?

On the development site we had version 4.2.3 .... I don't know why he decided to go backwards.


oh well its works now! I don't really think ^m has anything to do with it.

thanks though!
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Free web site, control panel, and dedicated IP with game server purchase for only $25 twastudios General Advertisements 3 10-20-05 06:13 AM
Nested Query in PHP/MYSQL truesilentassassin PHP 2 07-27-04 07:50 PM
Declared Functions skipper23 PHP 4 12-17-03 10:06 AM
index page not showing up skipper23 PHP 3 12-15-03 01:10 PM
FREE Team Speak server w/ every purchase of a Call of Duty Server twastudios General Advertisements 0 10-31-03 01:14 AM


All times are GMT -5. The time now is 04:29 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.