dlcmpls

This is a bugger. I ran the query you mentioned. All the password fields that should have been populated with the ENCODE are empty. All the other password fields that were not populated with encode do have text in them - though its mush. I've attached a screen shot. Any additional ideas? [attachment deleted by admin]

I ran the whole query via phpMyAdmin. Same result. No data in the PASSWORD field. The field type for PASSWORD is char(100)

I'm viewing the database via phpMyAdmin. The field for PASSWORD is empty. The field is populated for other records that I created during testing, so I know that it's possible to insert data into that field. If I run the SELECT statement you mention, I get some odd looking characters: �-*��

Well, removing the single quotes around the ENCODE removed the error message I was getting, but now the field in my db that should be populated is empty. Here's my updated query: mysql_connect("localhost", "user", "pass") or die(mysql_error()); mysql_select_db("dbname") or die(mysql_error()); mysql_query("INSERT INTO members (ID, rec_no, email, PASSWORD, firstname) VALUES('', '', 'boo@somewhere.com', ENCODE('pw101', 'key101'), 'dave' ) ") or die(mysql_error()); Query runs fine, but no insert into the PASSWORD field in my db.

Sorry about that. I modified my code to remove real variable data. Here's my code: mysql_connect("localhost", "username", "password") or die(mysql_error()); mysql_select_db("dbname") or die(mysql_error()); mysql_query("INSERT INTO members (ID, rec_no, email, PASSWORD, firstname) VALUES('', '', 'ENCODE('pw101', 'key101')', 'pass2', 'dave' ) ") or die(mysql_error()); I've modified the variables in the connect and select strings. Here's my error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pw101', 'key101')', 'pass2', 'dave' )' at line 2

I need a little help with encode. I'm just learning how to work with ENCODE and DECODE. I've written this sql query, which works just fine (minus the encode): mysql_connect("localhost", "username", "password") or die(mysql_error()); mysql_select_db("dbname") or die(mysql_error()); mysql_query("INSERT INTO mymembers (ID, rec_no, email, PASSWORD, firstname) VALUES('', '', 'grr@t.com', 'pass2', 'dan' ) ") or die(mysql_error()); Now I want to try and ENCODE the password, so I wrote this query: mysql_connect("localhost", "username", "password") or die(mysql_error()); mysql_select_db("dbname") or die(mysql_error()); mysql_query("INSERT INTO mymembers (ID, rec_no, email, PASSWORD, firstname) VALUES('', '', 'grr@t.com', ENCODE('pw101', 'key101'), 'dan' ) ") or die(mysql_error()); But that query fails and throws this error message: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pw101', 'key101')', 'pass2', 'dave' )' at line 2" This seems to be a quotation mark issue to me. Can anyone help me write a sql insert that will use ENCODE on the password? Thanks in advance for any help.

I tried this: AND subscriptions.recieve_by IN('mail','both','e-mail') but that returned 0 records. Here's more of my query, including the mysql_error which doesn't return an error: $dbh=mysql_connect ("$Host", "$User", "$Password") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("$DBName"); /******************************************** Write the query, call it, and find the number of fields /********************************************/ $export = mysql_query(" (SELECT subscribers.bfname, subscribers.bname, subscribers.baddr1 as addr1, subscribers.baddr2 as addr2, subscribers.bcity as city, subscribers.bstate as state, subscribers.bzip as zip, subscribers.email as email, subscribers.user_id, subscribers.password, subscriptions.expiration_date, subscriptions.type FROM subscribers, subscriptions WHERE saddr1 = '' AND subscriptions.user_id = subscribers.user_id AND (subscriptions.recieve_by = 'mail' OR subscriptions.recieve_by = 'both') ) UNION (SELECT subscribers.bfname, subscribers.bname, subscribers.saddr1 as addr1, subscribers.saddr2 as addr2, subscribers.scity as city, subscribers.sstate as state, subscribers.szip as zip, subscribers.email as email, subscribers.user_id, subscribers.password, subscriptions.expiration_date, subscriptions.type FROM subscribers, subscriptions WHERE saddr1 <> '' AND subscriptions.user_id = subscribers.user_id AND (subscriptions.recieve_by = 'mail' OR subscriptions.recieve_by = 'both') ) ORDER BY bname, bfname, user_id, expiration_date DESC "); the "recieve_by" column in my table is varchar(10) I know that the dash in "e-mail" isn't a problem because I can change the AND to: AND (subscriptions.recieve_by = 'e-mail' OR subscriptions.recieve_by = 'both') and I don't get an error. Could it be a Union problem? I don't have a recieve_by column in both tables. Would that cause a problem?

Here's my current sql statement which gives me almost what I want: mysql_select_db ("$DBName"); /******************************************** Write the query, call it, and find the number of fields /********************************************/ $export = mysql_query(" (SELECT subscribers.bfname, subscribers.bname, subscribers.baddr1 as addr1, subscribers.baddr2 as addr2, subscribers.bcity as city, subscribers.bstate as state, subscribers.bzip as zip, subscribers.email as email, subscribers.user_id, subscribers.password, subscriptions.expiration_date, subscriptions.type FROM subscribers, subscriptions WHERE saddr1 = '' AND subscriptions.user_id = subscribers.user_id AND (subscriptions.recieve_by = 'mail' OR subscriptions.recieve_by = 'both') ) UNION (SELECT subscribers.bfname, subscribers.bname, subscribers.saddr1 as addr1, subscribers.saddr2 as addr2, subscribers.scity as city, subscribers.sstate as state, subscribers.szip as zip, subscribers.email as email, subscribers.user_id, subscribers.password, subscriptions.expiration_date, subscriptions.type FROM subscribers, subscriptions WHERE saddr1 <> '' AND subscriptions.user_id = subscribers.user_id AND (subscriptions.recieve_by = 'mail' OR subscriptions.recieve_by = 'both') ) ORDER BY bname, bfname, user_id, expiration_date DESC "); See the 2nd AND? That gives me 2 bits of data about how a user receives their newsletter. But there's a third option which is "e-mail." I need the query to include anyone who has a recieve_by set to "e-mail." (yes, I know "recieve" is misspelled!) If I simply extend both AND's like this: AND (subscriptions.recieve_by = 'mail' OR subscriptions.recieve_by = 'both' OR subscriptions.recieve_by = 'e-mail' ) I get a 500 internal server error. What am I doing wrong?

Hi everyone. I want to use php to protect some files. The files are of different types: pdf, skp, dwg. I can handle creating a php page that requires authentication. That's easy. BUT, let's say a user logs in to my php page, and then is presented with a list of links for pdf's. User clicks a link and I open the pdf in a new window. All is good so far. But now the user can copy and paste the url into an email and send the url to an evil person. The evil user now has direct access to my pdf via the url. By the way, I know a user can simply save my pdf and then forward it to whoever they want. I have to live with that. I know I could restrict access to a directory with a .htaccess file, and then put all my pdf's in that restricted directory, but for a variety of reasons, that's not gonna work. Maybe my real question is "How can I hide the url of my pdf from a user." That by itself would solve my problem. Can anyone help?

Hi all. I have a customer who wants a search engine for pdf files on their website. I’ve done a bit of checking and this basic approach seems to be the way to go: 1. upload the pdf to a temp dir. 2. run pdftotext on it (part of the xpdf package) 3. store the pdftotext output in db. 4. store the orig pdf in a dir on the server for later download. I'm wondering if there is an existing application that I can use, rather than start from scratch? Does anyone have any suggestions for an existing App? In no suggestions for an existing app, do you have any general suggestions for creating this type of app? Thanks, dlc

Yes, php is enabled. To recap, this code works fine: <?php $to = "bill@bob.com"; $subject = "Check it out!"; $message = "test message"; $from = "someone@somewhere.com"; $headers = "From: $from"; mail($to,$subject,$message,$headers); ?> and an email gets sent. But with this code, no email is sent: <?php $myemail="jane@jane.com"; $to = "bill@bob.com"; $subject = "Check it out!"; $message = "test message"; $from = "someone@somewhere.com"; $headers = "From: $myemail"; mail($to,$subject,$message,$headers); ?> I don't understand why simply changing the name of the variable in $headers line would disable the script.

i use a webhost in minneapolis, visi.com. The files are on a Windows server.

Yep, I understand that Flame. Let's drop the idea of a form for now. Why doesn't this script work: <?php $myemail="jane@jane.com"; $to = "bill@bob.com"; $subject = "Check it out!"; $message = "test message"; $from = "someone@somewhere.com"; $headers = "From: " . "$myemail"; mail($to,$subject,$message,$headers); ?>

Thanks phreeek. but that didn't work. I tried this code: <?php $myemail="jane@jane.com"; $to = "bill@bob.com"; $subject = "Check it out!"; $message = "test message"; $from = "someone@somewhere.com"; $headers = "From: " . "$myemail"; mail($to,$subject,$message,$headers); ?> And no luck. One thing I don't understand at all...why would replacing one variable ($from) with another ($myemail) cause a problem to begin with?

Hello all. I have no hair left! I'm working with a very simple email script, but I'm having trouble getting the script to work with a "from" email address supplied via a form (or even hard coded). Here's the code that I know works (with no references to the external form) <? $to = "bill@bob.com"; $subject = "Check it out!"; $message = "test message"; $from = "someone@somewhere.com"; $headers = "From: $from"; mail($to,$subject,$message,$headers); ?> Works a-ok. But, now I want the "From" email address to be the email supplied by the user of the form. So I have an input field called "Email" in my form. If I try to modify the above code like so: <? $to = "bill@bob.com"; $subject = "Check it out!"; $message = "test message"; $from = "someone@somewhere.com"; $headers = "From: ($_POST)"; mail($to,$subject,$message,$headers); ?> No email gets sent. In fact, I can't even set a hard code my own variable in the above code like so: <?php $myemail="myemail@someplace.com"; $to = "bill@bob.com"; $subject = "Check it out!"; $message = "test message"; $from = "someone@somewhere.com"; $headers = "From: $myemail"; mail($to,$subject,$message,$headers); ?> That doesn't work. No email gets sent which confuses me because I'm simply replacing one variable ($from) with another ($myemail) in the $headers line. What am I missing? Any help would be greatly appreciated. dlc

Well, that's the problem. I can't create new folders above the root and I can't place files in the same location as the root.

Hello everyone. I have a small php/mysql app. For that app I have a file called appglobals.php. In that file is a bunch of stuff, including variables used to define the user name and password for the mysql database. By including this appglobals.php file in all files that need access to the db, I only have to maintain the db info in 1 place. For security reasons I like to place my appglobals.php file one leve above the site root. So for example, if the site root is "httpdocs" I like to put my appglobals.php one level above that directory. Normally this works fine, but my new web host doesn't allow files to be placed in the same location as "httpdocs." I could move my file into the root, but that's less secure. Given that I can't put my file one level above the root, I'm wondering if anyone has suggestions as to what to do next. I have to put my file in the httpdocs directory, so what's the best way to secure the file there yet still make it available to my app? Thanks in advance. dlc

Hi all. I have a problem that has stumped me. I have a web page that displays a list of businesses (pulled from a mysql db). On that page is a check box that, when ticked, allows the user to save that business for later review. So let's say my page shows 5 businesses. The user may want to save 1, 3, or all of the businesses. Saving the businesses works fine for me. Here's where I get stuck. I want the page to recognize when a user has already saved a business. So for example, if the user has already saved Business3, I want to replace the "save it" check box with a text message that says something like "You have already saved this business." I don't know how to make this happen. I don't really need coding help, I need an explanation of how I would conceptually do this sort of thing. Thanks dlc

I think I understand Ginger. All of your assumptions are basically correct. Basically the "for each" will loop through each of the Posted variables thus inserting a record for each variable. Correct? Do I have to have an array established before sending anything to the "foreach" function? Or will that simply loop through ANY posted variable called businessid? Right now, Page1, where all the businesses are listed, has a hidden form variable called "businessid" and that value is populated with a query. That all works fine. Now, from Page1, do I have to have some sort of array on that page to pass all the businessid's or can I simply post Page1 to Page1Processor and the foreach will recognize all the businessid's and loop through them? Thanks. dlc

Hi All. I'm a little stuck. I have a web page that lists businesses. Let's say the page display's 5 businesses at a time. Each business has a checkbox that let's the user indicate if they want to "save" that business for future reference. This way the user can generate a list of favorite businesses - like restaurants for example. So out the 5 businesses displayed the user may want to save 1, 3 or 5. I'm stuck on how to do the php/mysql query to insert multiple rows of saved businesses. The bits of data to be save are userid, businessid, savedbusinessid. So if a user decides to save 3 out of the 5 businesses how do I write the php/mysql query to do this? Thanks in advance. dlc

Thanks Wuhtzu. I got the code. Works like a charm. As always, the folks here at the "freaks" forum are the greatest! dlc

Hi all. I need a little help with a small problem. I've written a bit of script that allows a user to change the font size on a web page. I am aware that this can be done via browser settings, but the client wants the feature on the web page. My script uses a cookie to keep the users font choice persistent. However, when I run the script, the web page doesn't recognize the users font choice unless I refresh the page. Once I refresh the page, everything works fine. So I'm confused as to why the browser doesn't recognize the font choice right away. Any suggestions? Here's my code: <?php //////// CHECK TO SEE IF THE FONTCHOICE VARIABLE IS FOUND IN THE URL. THE VARIABLE WILL BE PASSED IF A USER CLICKS A LINK TO CHANGE THE FONT SIZE //////// IF WE FIND THE VARIABLE fontchoice SET A COOKIE SO THE USERS FONT CHOICE WILL PERSIST if ($_GET['fontchoice']) { setcookie(CookieFontSize, $_GET['fontchoice'], time() +60*60*24*7*365); } //////// CHECK TO SEE IF A COOKIE EXISTS. IF IT DOES, SET THE FONT SIZE TO THE USERS DESIRED SIZE if(isset($_COOKIE['CookieFontSize'])) { $fontsize = $_COOKIE['CookieFontSize']; echo "Your font size is " . $fontsize; } //////// NO COOKIE FOUND SO SET THE FONT SIZE TO A DEFAULT OF 12 else { $fontsize = "12" ; echo "No font set!"; } ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Untitled Document</title> <style type="text/css"> <!-- p, li, br, div, span, td { font-family: Arial, Helvetica, sans-serif; font-size: <? echo $fontsize ; ?>px; color: #000000; text-decoration: none; } .style12 {font-size: 12px} .style18 {font-size: 18px} .style24 {font-size: 24px} .style30 {font-size: 30px} --> </style> </head> <body> <p>Lorem ipsum dolor sit amet. </p> <p> </p> <hr> <p> </p> <p>change font size:</p> <p><a href="cookie.php?fontchoice=12" class="style12">A</a> <a href="cookie.php?fontchoice=18" class="style18">A</a> <a href="cookie.php?fontchoice=24" class="style24">A</a> <a href="cookie.php?fontchoice=30" class="style30">A</a> </p> </body> </html>

Hi All. I have a rather simple Find/Replace script that I use on a couple of large sites. The script works flawlessly on Unix machines, but when I try to run it on a Windows machine, the script fails. When I run the script on Windows, the feedback tells me the script ran, but when I look at the files, nothing happened. Can anyone tell me why? My script is below and attached. Note that I hard coded the variable to be Found and Replaced for testing/simplicity. The variables can be found on lines 74 and 75. Note that the script is exactly the same on both server OS's except for line 83 which is the path. Any help is greatly appreciated. ------------------ <html> <head> <title>Batch string find and replace</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8895"> <link rel="stylesheet" href="image/style.css" type="text/css"> </head> <body bgcolor="#FFFFFF" text="#000000"> <table width="500" border="0" cellspacing="0" cellpadding="0" align="center" background=""> <tr> <td> <div align="center"><B>Result of batch content replace</B></div> </td> </tr> </table> <br> <table width="500" border="0" cellspacing="0" cellpadding="0" align="center"> <tr> <td bgcolor="#6B4D44"> <table width="500" border="0" cellspacing="1" cellpadding="0"> <tr> <td bgcolor="#FDF6EB"> <br> <table width="470" border="0" cellspacing="0" cellpadding="3" align="center"> <tr> <td width="470"> <? //For vertion 4.2 or higher extract($_POST); extract($_GET); $checkbox_num="3"; function get_dir_and_file($dir) { static $data = array(); $file = ''; $handle = ''; $full_file_name = ''; if ( $handle = opendir( $dir ) ) { while( false != ( $file = readdir( $handle ) ) ) { if ( $file != '.' && $file != '..' ) { $full_file_name = $dir . '/' . $file; if ( filetype( $full_file_name ) != 'dir' ) $data[] = $full_file_name; if ( filetype( $full_file_name ) == 'dir' ) get_dir_and_file( $full_file_name ); } } closedir( $handle ); } return $data; } function checkbox_select($num,$array) { for($i=0;$i<$num;$i++) { if($array[$i]) { $index=$array[$i]; $Field[$index]=1; } } return $Field; } //////// BEGIN SCRIPT MOD BY DLC. 051106 MOD'S MADE SO THIS SCRIPT CAN RUN STANDALONE, WITHOUT USER INPUT. $word1 = 'head' ; $word2 = 'myhead' ; $directory = 'y' ; $postfix[0] ='htm' ; $postfix[1] ='html' ; $postfix[2] ='php' ; // $allsuffix = 'y' ; //////// THIS PATH MUST BE SET FOR EACH SERVER INDIVIDUALLY! MOVE THIS LINE TO THE FILE ON THE CLIENT SERVER!!!! $path = '/web/root/www/what/' ; //////// END MOD BY DLC function check_file($filename,$word1,$word2,$bigflg,$backupflg,$postfixarray,$allsuffix) { if($allsuffix) { $Fp=fopen($filename,"r"); $Contents=fread($Fp,filesize($filename)); fclose($Fp); $word2=stripslashes($word2); $word1=stripslashes($word1); //////// REMOVED BY DAVE. 051106. THESE 2 LINES REMOVED LINE BREAKS AND SCREWED UP THE HTML LAYOUT. //$word1=ereg_replace("\r","",$word1); //$Contents=ereg_replace("\r","",$Contents); $Contents=str_replace("|","\##",$Contents); $word1=str_replace("|","\##",$word1); $word2=str_replace("|","\##",$word2); $word1=quotemeta($word1); if($bigflg) $pos=ereg($word1, $Contents); else $pos=eregi($word1, $Contents); if($pos) { if($backupflg) { $new_filename=$filename.".bak"; $wfp=fopen("$new_filename","w+"); fputs($wfp,$Contents); fclose($wfp); } if($bigflg) $new_Contents=ereg_replace($word1,$word2,$Contents); else $new_Contents=eregi_replace($word1,$word2,$Contents); $new_Contents=str_replace("\##","|",$new_Contents); $wfp=fopen("$filename","w+"); fputs($wfp,$new_Contents); fclose($wfp); return $filename; } else return false; } elseif($postfixarray) { $pstr=strrchr(basename($filename),"."); $pstr=substr($pstr,1,(strlen($pstr)-1)); if($postfixarray[$pstr]==1) { $Fp=fopen($filename,"r"); $Contents=fread($Fp,filesize($filename)); fclose($Fp); $word2=stripslashes($word2); $word1=stripslashes($word1); //////// REMOVED BY DAVE. 051106. THESE 2 LINES REMOVED LINE BREAKS AND SCREWED UP THE HTML LAYOUT. //$word1=ereg_replace("\r","",$word1); //$Contents=ereg_replace("\r","",$Contents); $Contents=str_replace("|","\##",$Contents); $word1=str_replace("|","\##",$word1); $word2=str_replace("|","\##",$word2); $word1=quotemeta($word1); if($bigflg) $pos=ereg($word1, $Contents); else $pos=eregi($word1, $Contents); if($pos) { if($backupflg) { $new_filename=$filename.".bak"; $wfp=fopen("$new_filename","w+"); fputs($wfp,$Contents); fclose($wfp); } if($bigflg) $new_Contents=ereg_replace($word1,$word2,$Contents); else $new_Contents=eregi_replace($word1,$word2,$Contents); $new_Contents=str_replace("\##","|",$new_Contents); $wfp=fopen("$filename","w+"); fputs($wfp,$new_Contents); fclose($wfp); return $filename; } else return false; } else return false; } } set_time_limit(0); echo "Begin time=".date("H:i:s")."<br>"; if(isset($postfix)) { $totalarray=checkbox_select($checkbox_num,$postfix); $totalarray_num=count($totalarray); if($selfpostfix) { $sarray=explode(",", $selfpostfix); for($i=0;$i<count($sarray);$i++) { $index=$sarray[$i]; $totalarray[$index]=1; } } } elseif($selfpostfix) { $sarray=explode(",", $selfpostfix); for($i=0;$i<count($sarray);$i++) { $index=$sarray[$i]; $totalarray[$index]=1; } } $realnum=0; if($directory) { $dirdata=get_dir_and_file($path); $dirnum=count($dirdata); for($i=0;$i<$dirnum;$i++) { if(file_exists($dirdata[$i])&&$dirdata[$i]!="index.php"&&$dirdata[$i]!="reok.php") { $file1=check_file($dirdata[$i],$word1,$word2,$big,$backup,$totalarray,$allsuffix); if($file1) { $realnum++; echo $dirdata[$i]."..........<font color=red>replaced ok!</font><br>"; } else echo $dirdata[$i]."..........pass!<br>"; } } } else { $dirnum=0; $handle=@opendir($path); while ($file = readdir($handle)) { if($file!="."&&$file!="..") { $filepath=$path."/".$file; if(file_exists($filepath)&&is_file($filepath)&&$filepath!="index.php"&&$filepath!="reok.php") { $file1=check_file($filepath,$word1,$word2,$big,$backup,$totalarray,$allsuffix); if($file1) { $realnum++; echo $filepath."..........<font color=red>replaced ok!</font><br>"; } else echo $filepath."..........pass!<br>"; $dirnum++; } } } } echo "End time=".date("H:i:s")."<br>"; echo "Total file=$dirnum<br>"; echo "Replaced file=$realnum<br>"; //////// BEGIN SENDING THE EMAIL $domain = $_SERVER['HTTP_HOST']; $clientemail = "myemail@somewhere.com" ; $rundate = date("l dS of F Y h:i:s A"); $subject = "Successful - $domain"; //////// SET THE MESSAGE CONTENT FOR THE CONFIRMATION EMAIL $messagecontent = "Process performed and successful for:<br><br><strong>$domain</strong><br><br> on $rundate.<br><br><br> <B>Result of process:</B><br><br> <blockquote> Total files Processed = $dirnum<br><br> Updated files = $realnum<br><br> File Path = $path<br><br> </blockquote> "; $headers† = 'MIME-Version: 1.0' . "\n"; $headers .= "To: $clientemail" . "\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\n"; // Additional headers $headers .= "From: dave@catwired.com" . "\n"; //$headers .= 'Cc: myemail@somewhere.com' . "\n"; //$headers .= 'Bcc: myemail@somewhere.com' . "\n"; // Mail it mail($to, $subject, $messagecontent, $headers); ?> </td> </tr> </table> <br> </td> </tr> </table> </td> </tr> </table> </body> </html> ----------------- [attachment deleted by admin]

Hello everyone. I have what I think is a simple issue, but it's turned my mind to mush! Here's the situation. I have a query that pulls 4 records from a mysql db. Let's say that each record is the name of a fruit: Orange, Lemon, Lime, Grape. The fruits are in that order in the db. Record 1 is "Orange", Record 2 is "Lemon" etc. My table has 2 fields - FruitID and FruitName, and 4 records. I have the query working with a "while" statement so the list of fruit prints to the screen just fine. Of course, the list prints as reflected in the db. Orange is first, followed by Lemon, then Lime etc. What I'd like to do is reorder the fruit for printing. Or, to put it another way, what if I wanted to print each Fruit name just once, but in different places in a web page, not as a list? How do I do this? I assume I have to use some sort of array and assign each fruit to a variable that can be echoed to the screen. Here's my working code for reference: $Link = mysql_connect("$Host", "$User", "$Password") or die ('I cannot connect to the database.' . mysql_error()); mysql_select_db("$DBName"); $fruitquery = mysql_query("SELECT * FROM fruit"); while($Row = mysql_fetch_array($fruitquery)) { print ("$Row[FruitName]"); } Any suggestions? I know this can't be difficult but my brain just isn't grasping the answer. Thanks dlc

Thanks Ken. That does indeed work. I think you were right about the extraneous characters. I was using DreamWeaver to edit the file. I used BBEdit instead, cleaned up all the spaces etc and it works fine now. Frustrating! But thank god for the forum users!