My program is a simple client database that holds information on tenants. Each tenant has a LONGBLOB column called 'notes' to hold updated information on them. For tenants that have a long list of notes, when the form is submitted the site actually goes to a 404, so their profile never gets updated. Is there a HTTP limit to POST/GET characters that can be sent? I cannot figure out if this problem is being caused by PHP or IIS, as this has never happened before. Any help is appreciated, sorry if my explanation is bad.

Member Avatar
Member Avatar
+0 forum 6

I'm having some trouble collecting data between 2 different years (ie: December 2011 & January 2012). This is a timeclock system where punches are stored as: DD-MM-YYYY (31-12-2011). I want to be able to search for dates between: DD-MM-2011 through DD-MM-2012 but am coming up empty. When using the same year the query works just fine. Here is my failed code: [code] $sql = "SELECT * FROM timeclock WHERE user = 'mdloring' AND punch_in BETWEEN '26-12-2011' AND '09-01-2012' ORDER BY punch_in DESC"; [/code] There are no MySQL errors, so I think it has something to do with the way I …

Member Avatar
Member Avatar
+0 forum 2

Not sure if this is a PHP problem or IIS7 issue: My form is used for editing client information, and it has worked flawlessly for the last year until now. Some clients have more "Notes" about their file than others, and recently clients with a lot of "Notes" have been causing 404 Errors when trying to update their file. I've already set my post_max_size to 50M, and my memory_limit is set to 128M. My "Notes" column is set to BLOB (I've tried VarChar, Text, LongText, etc...), but to no avail. BLOB columns don't have a max size, so I do …

Member Avatar
Member Avatar
+0 forum 1

I've literally copy and pasted a basic AJAX function from W3 Schools, and for some odd reason it refuses to work on my site...please help. Here is my HTML: [code] <select name="address" onChange="sortAddress(this.value)"> <option value="" selected="selected">Building Address</option> <?php $sql = "SELECT DISTINCT name FROM buildings ORDER BY location"; $result = mysql_query($sql); while($r=mysql_fetch_array($result)) { ?> <option value="<?=$r['name']; ?>"><?=$r['name']; ?></option> <?php } ?> </select> [/code] Below is the AJAX I am using. The bold line errors "Object doesn't support this property or method" [code] function sortAddress(str) { if (str=="") { document.getElementById("txtHint").innerHTML=""; return; } if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, …

Member Avatar
Member Avatar
+0 forum 1

All I am trying to do is place the marker number in the map. I was able to do this with V2 of Google Map API, but now I have not a clue how to do it in V3. I've exhausted Googling this issue, and now come to my favorite forum. Does anyone know how to place numbered label markers using Google Map v3? Thanks, Michael

Member Avatar
Member Avatar
+0 forum 1

I'm really no JavaScript expert, and I have absolutely no idea what exactly is causing this error. I am using a Photo Gallery script called Galleria which uses jQuery/JavaScript to display photos. On my index page load (only in Internet Explorer), a message box pops up saying "Message from Web Page [object Object]". After clicking OK the photo gallery loads and there is no problem. No idea how to fix this, or really what the error means. You can view the error from my site here: [url]http://www.millenniumparkplaza.com/bjb/site/index.php?p=home[/url] Any help is greatly appreciated. I'm getting close to the deadline for this …

Member Avatar
Member Avatar
+0 forum 3

I am building a Leasing Company Property web site, and one option they'd like is to have "Similar Properties" recommended to the visitor. The array contains "Bedroom Type" data (studio, 1 bedroom, 2 bedroom, 3 bedroom). A sample array is: Array ( [0] => Studio [1] => 1BR ) I am trying to figure out a way to retrieve other buildings that "match" similar bedroom types (if a building has a Studio type, I'd like to list that building). Any idea on how I can start writing this? Any and all advice is greatly appreciated, I've never had to do …

Member Avatar
Member Avatar
+0 forum 7

My table has 4 types of "r1": 'Standard', 'HD', 'HD + DVR', 'None' There are 3 types of "status": 'NTC', 'Repair', 'In Progress' All I am trying to do is retrieve all of the rows where r1 = 'Standard' and matches all three of the "status": [code] SELECT * FROM installs WHERE r1 = 'Standard' AND STATUS = 'NTC' OR STATUS = 'In Progress' ORDER BY building, appointment_date ASC [/code] My results continue to pull all the other types of "r1" (HD, HD + DVR, None) and I cannot figure out for the life of me why. Any input would …

Member Avatar
Member Avatar
+0 forum 6

I've been at this for about a week now, and still can't get my Google Map to properly number the markers. Any help would be greatly appreciated. I've done enough "googling" on the subject matter, and finally needed to make a forum thread. My JavaScript code: [CODE]<script type="text/javascript"> function load() { var url = document.location.href; if (url.match("view")) { var map_url = 'single_site.php'; } else { var map_url = 'phpsqlajax_genxml2.php'; if (GBrowserIsCompatible()) { var map = new GMap2(document.getElementById("map")); map.addControl(new GSmallMapControl()); map.addControl(new GMapTypeControl()); map.setCenter(new GLatLng(41.9034,-87.627944),13); GDownloadUrl(map_url, function(data) { var xml = GXml.parse(data); var markers = xml.documentElement.getElementsByTagName("marker"); for (var i = 0; i …

Member Avatar
Member Avatar
+0 forum 2

The End.