[jQuery] Re: Ajax check username - ASP and Access DB

2009-09-28 Thread MorningZ
Take an example page in php that you want to mimic, and simply have asp send back to the browser the same information On Sep 28, 3:58 am, factoringcompare firstfacto...@googlemail.com wrote: Hi, Reasonably new to web building. I am now just updating my site with jQuery (first time user).

[jQuery] Re: Ajax check username - ASP and Access DB

2009-09-28 Thread factoringcompare
OK, I am trying to get this example to work : http://papermashup.com/jquery-php-mysql-username-availability-checker/ This is the php code I can't mimic: ?php include(dbConnector.php); $connector = new DbConnector(); $username = trim(strtolower($_POST['username'])); $username =

[jQuery] Re: Ajax check username - ASP and Access DB

2009-09-28 Thread MorningZ
This is the php code I can't mimic: Really? the code is super simple: - Open connection to the database - Take the posted value of username, trim it, and make lower case - Clean up the string to help prevent SQL injection attack - Take that username and check against the database - echo

[jQuery] Re: Ajax check username - ASP and Access DB

2009-09-28 Thread factoringcompare
I can’t get it to work. Something strange is happening. To manually check if the client side code is working I put “1” in the server side page with a .php extension and sure enough I can get the code to work. If I do the same with a .asp page it has no effect. Any thoughts what’s going on? On

[jQuery] Re: Ajax check username - ASP and Access DB

2009-09-28 Thread MorningZ
Why do you have a page with a php extension? As for helping further, it would be a huge help if you post some non- working code... you could have a bad selector, bad syntax, who knows... On Sep 28, 3:15 pm, factoringcompare firstfacto...@googlemail.com wrote: I can’t get it to work.

[jQuery] Re: Ajax check username - ASP and Access DB

2009-09-28 Thread factoringcompare
OK, thank you for taking the time out to look at this issue for me. Ok this is the code client side page: !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http:// www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd html xmlns=http://www.w3.org/1999/xhtml; head meta

[jQuery] Re: Ajax check username - ASP and Access DB

2009-09-28 Thread James
When you return response in your AJAX, it's not 1. It's htmlhead.../html. jQuery doesn't automatically go through your HTML and look in the body to find the 1. In your server-side code, you don't return the whole HTML page. You just return the String 1 (without the quotes). Such that if you load

[jQuery] Re: Ajax check username - ASP and Access DB

2009-09-28 Thread factoringcompare
Thank you James that worked. I can now move on and try and code the DB connection. On Sep 28, 10:22 pm, James james.gp@gmail.com wrote: When you return response in your AJAX, it's not 1. It's htmlhead.../html. jQuery doesn't automatically go through your HTML and look in the body to find

[jQuery] Re: Ajax check username - ASP and Access DB

2009-09-28 Thread factoringcompare
OK, now got the backend working with the following code: %...@language=VBSCRIPT% !--#include file=Connections/car.asp -- % Dim rsUser__MMColParam rsUser__MMColParam = 1 If (Request.Form(username) ) Then rsUser__MMColParam = Request.Form(username) End If % % Dim rsUser Dim rsUser_numRows