[SOLVED] Having issue with ajax processing in scripcase 7. Please Help !

Scriptcase 7 Discussion
#1

Hello,
I am using Scriptcase 7 and i watched video 2 of E- learning to how to do it correctly , but no help was found.

I did as it is told there, but when i select state it don’t show me city according to it ?

what i am doing wrong ?

can anyone help me do we need to change anything in database too ? like foreign key and any kind of such freaks ?

please help me out.

#2

I think you missed something somewhere. In steps: create a select on both fields. Don’t do anything, but check if the selects are working. If not, look at your table, sql etc. Next you go to the first field and scroll down until you find the ajax event. There you set the checkbox and select the field to be updated. Check it (a star will appear before the field) regenerate and run. It should work now. If you change the first field, a trigger should go off to the second to refresh it’s values.

#3

yea i checked that all but what i found missing are:

  1. dropdown not showing in city field.
  2. have they set anything as foreign key ???

as i have set city field as VARCHAR and in video it says INT, but if i save it as INT then how come it will save Char in its field ???

#4
  1. You haven’t made the field of select type.
  2. You don’t have to declare foreign keys.

AFAIK it doesn’t matter if you use int or varchar, but in the latest you need to use quotes. I.e. where city=’{mycity}’

#5

yea i am doing exactly you told from starting … but still i am stuck…

#6

NVM i got the issue, i was not doing it bit 1% correct… :slight_smile: figured it out… :slight_smile: Thanks a lot again !