Ive been working on a web map application with OpenLayers as a client side library, geoserver and Postgresql as database. I need to commit the features added on the map into the database.Is there a way i can specify the table in the database where the feature data can be stored? I have generated the KML of the added feature.Now i only need to pass the kml into the geoserver so that the changes can be viewed in database.
I am having no luck with my post form to mysql. It is only posting the first letter of the word/phrase for the text input fields to the mysql database. It is a photo and text post form. The photo and only first letter of text are posting to database. I am using Jqtouch, jquery, and phonegap.
I was wondering if someone could help me out with the following.I'm developing a webshop CMS in which you can create categories. By using jquery's ajax method I'm making a POST request to a PHP script which then handles all the data supplied to it. This works good and all except for the fact that after the query is being executed my HTML doesn't get updated, at least not as well as I want it to.I understand that the common way of working here is to update HTML in the success callback of the ajax method. But the thing is that every category is being displayed as a list item with an id attribute, this id corresponds to the id the category has in the database.If$.ajax tells me that everything went down smoothly and my query has been executed then there's still no way for me to know which id this new category has been given so that I can update the HTML accordingly.
What would be a "smart" way to tackle this? The first thing that comes to my mind is simply calling another script which figures out the last inserted id on the db but that would mean doing an ajax request in the callback of another ajax request? That doesn't sound right to me..
how can I redirect the form to a different database script on a different or same page as this database code? I want to have multiple forms going to different tables, and I want the database scripts kept separate. I just don't understand how the form data knows to be inserted into this database. If I duplicate kilo.js, rename it kilo2.js and use different field names, and attach it to the forms page following kilo.js, then kilo.js is ignored and the original form does not work.
IE 6.0 (not interested in other browsers at the moment)
I have looked everywhere I can find to look and googled until I am cross-eyed and am hoping somebody knows what I'm doing wrong.
I have an HTML application (.hta) working fine, except one thing. I'm trying to write to a local database from a .htm window (opened from the main .hta window) and it doesn't work with any of the combinations I've tried (and I admit to having tried a lot).
Here is one method I've tried:
strSQL = "Update myTable SET myField = 'myValue' WHERE myID = 12;" var db = new ActiveXObject("ADODB.Connection"); db.Provider = "Microsoft.Jet.OLEDB.4.0";0 db.ConnectionString = "Data Source='c:myDirectorymyDatabase.mdb'"; db.Open; db.execute(strSQL);
I can easily access the information in the myDatabase.mdb and display it on the screen.
I can ask for updated information to be input on the screen.
But stuffing that updated information back into the database is the problem.
I got my code for adding my table ( HTML manipulation )But the problem is, that if u click an empty row, it need to change letter from S to Z ( and empty ( space ) So, i actually don't know how i can use those multiple's, so i started scripting from just an space to ... it didn't work.. but i was sure my script works, so i used it on other page .. and it worked ... here is my code
I do not know the value of both PHP-Values, they come from a database. I have tried now some hours to grab the values of this array, because i have to compare them to other values in similar inputs. But I simply do not know how? For a simple test i simply want to change the value of the chosen fields. I tried (nearly) everything from something like $("input[name='combi']").val('test'); to $("input[name='combi'//[//]//[//]]").val('test'); . In PHP I have absolutely no problem, i go simply through the arrays with:
I'm looking to fill out an input box, and onBlur get info from the database and echo it. Very similar to how you register on this site, when you fill out a username, onBlur it checks to see if the username is available and echos yes or no. I want to fill out a username, and when you click out of the textbox, echo the First and Last name if it exists.
The NS_ERROR_DOM_BAD_URI seems to be about cross domain issues but I'm working locally on the actual server so should I be able to access the data? Also why is there an XML parse error when I can see the exact data I want in httpfox's "Content" tab?
I am new to jQuery and I am trying to create an autocomplete textbox. When I use a small test database, it works fine but when I use my production database with over 3000 records, it slows to a crawl. It take >20 seconds to load the page and with each letter I type (even though I set minChars to 3), the browser times out asking if I want to continue running the script. My feeling is I need to use AJAX but I have never done that and don't know how to. I code in classic ASP with an Access database. Can anyone provide some sample code how to do this. Unfortunately I am under a time pressure to complete this project.
I've been reading up on click() and I can't figure out how to get it to run another php script that will remove an ID from a database.. How would I go about doing that? I need to send the current li ID to this php script.
I'm trying to create a countdown timer based upon[URL]...what I'm trying to do: The database has a date, then there is a certain amount of seconds. Say 60*10 = 600 seconds / 10 minutes.
Everytime somebody buys something the datetime in database will be updated to the datetime item was bought. Now my goal is that anyone who is watching the timer in REAL time will have their timer reset to 10 minutes when somebody else buy.
Now the probem is this. The timer works sometimes only. Usually the first 3 times after a page load when somebody buys an item it works. Then it doesn't work. Or work at random intervals. It just doesn't make any sense to me!??
I managed to send data from the form using php & jquery/ajax. But now I need to be able to load that data back onto the form. Is it somehow possible to use the code I have for sending the data to retrieve the data?