Autofill address details

Scriptcase 9 General
#1

Hello. I’m stuck on something that I hope is an easy fix. I have a simple app: CustomerID, Name, Street, City, State, Zip and Telephone. I want to be able to choose a Name and have the rest of the fields auto complete, I’ve put the following code into an ajax on Change event:
sc_lookup(rs, “SELECT CustomerID, Street, City, State, Zip, Telephone FROM tblcustomers WHERE CustomerID =”. $customerid);

{Street} = {rs[0][1]};
{City} = {rs[0][2]};
{State} = {rs[0][3]};
{Zip} = {rs[0][4]};
{Telephone} = {rs[0][5]};

All that happens is the name changes but everything else remains the same.
I’m embarrassed to admit I’ve spent/wasted over a week on this, please help before I’m served divorce papers:)

#2

you can change
WHERE CustomerID =". $customerid);
with
WHERE CustomerID = {CustomerID}");