yeah but it stinks of microsoft/vb/asp :) i can't really tell you in IIS, but that's the common reason nginx has a "no input file specified" - people ask about it all the time. On Fri, Dec 19, 2008 at 3:15 PM, Gary Maddock-Greene <gmg@xxxxxxxxxxxxxxxxxxxx> wrote: > the code was generated by Dreamweaver CS3 .. its php! > > How do I check the SCRIPT_FILENAME please? > > "mike" <mike503@xxxxxxxxx> wrote in message > news:bd9320b30812191502t2448ef31xa8ad8758f8638862@xxxxxxxxxxxxxxxxx >> >> first off - you must be coming from ASP for that code :P >> >> second - that error is usually due to the SCRIPT_FILENAME being >> incorrect. not the code in the script. >> >> On Fri, Dec 19, 2008 at 2:54 PM, Gary Maddock-Greene >> <gmg@xxxxxxxxxxxxxxxxxxxx> wrote: >>> >>> Hi Philip, >>> >>> Here is my code ... >>> >>> <?php >>> if (!function_exists("GetSQLValueString")) { >>> function GetSQLValueString($theValue, $theType, $theDefinedValue = "", >>> $theNotDefinedValue = "") >>> { >>> $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : >>> $theValue; >>> >>> $theValue = function_exists("mysql_real_escape_string") ? >>> mysql_real_escape_string($theValue) : mysql_escape_string($theValue); >>> >>> switch ($theType) { >>> case "text": >>> $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; >>> break; >>> case "long": >>> case "int": >>> $theValue = ($theValue != "") ? intval($theValue) : "NULL"; >>> break; >>> case "double": >>> $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : >>> "NULL"; >>> break; >>> case "date": >>> $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; >>> break; >>> case "defined": >>> $theValue = ($theValue != "") ? $theDefinedValue : >>> $theNotDefinedValue; >>> break; >>> } >>> return $theValue; >>> } >>> } >>> >>> $colname_rsSearch = "-1"; >>> if (isset($_GET['product_name'])) { >>> $colname_rsSearch = $_GET['product_name']; >>> } >>> mysql_select_db($database_MyDatabase, $MyDatabase); >>> $query_rsSearch = sprintf("SELECT * FROM products WHERE product_name LIKE >>> %s", GetSQLValueString("%" . $colname_rsSearch . "%", "text")); >>> $rsSearch = mysql_query($query_rsSearch, $MyDatabase) or >>> die(mysql_error()); >>> $row_rsSearch = mysql_fetch_assoc($rsSearch); >>> $totalRows_rsSearch = mysql_num_rows($rsSearch); >>> ?> >>> >>> - Gary >>> >>> >>> "Philip Graham" <philip@xxxxxxxxxxxx> wrote in message >>> news:200812191734.10664.philip@xxxxxxxxxxxxxxx >>>> >>>> >>>> On December 19, 2008 17:20:32 Gary Maddock-Greene wrote: >>>>> >>>>> Hi, is it possible to de-bug a 'no input file specified' error. I get >>>>> the >>>>> error when trying to run my search script but do not know whats causing >>>>> it. >>>>> Is it a common error? >>>> >>>> What code/command/request is causing the error? >>>> >>>>> >>>>> PHP5 with MySQL adn IIS7 >>>>> >>>>> Thanks >>>>> >>>>> - Gary >>>> >>>> -- >>>> Philip Graham >>>> Lightbox Technologies >>>> Suite 312 240 Catherine St. >>>> Ottawa, ON, K2P 2G8 >>>> 613-686-1661 ext. 102 >>> >>> >>> -- >>> PHP General Mailing List (http://www.php.net/) >>> To unsubscribe, visit: http://www.php.net/unsub.php >>> >>> > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
