Skip to main content
Known Participant
April 16, 2007
Question

cf search

  • April 16, 2007
  • 24 replies
  • 2203 views
Hi, my name is Andy and I know just enough about web design & server-side, client-side stuff to get very frustraited.
I don't need anything too fancy (at least at first). I dont need the client to write to the database and I don't need the data base to change.
Here is what I do need:
On my home page I need the client to have a search box to enter thier zip code (which I guess I need to make my primary key) to find an electrician in thier area which may or may not be there depending on wheter we have one in our data base or not.
If one is there then I need a form to pop up for thier info. When the form is submitted, it needs to SMS to that member's cell phone.
Note: I have all of the network strings for the different phone company carriers but I know there is probably an easier way to do it with CF. For now though, I just need to know how to put a search box on my home page that will query the zip of the different members in my db. Thanks, Andy
This topic has been closed for replies.

24 replies

ace4uAuthor
Known Participant
April 16, 2007
Just tried to email you but it bounced. The email said to watch www.electriciansnet.com (if you want to) to see how it unfolds.
for some reason I cant get the tag to find findElectrician.cfm
ace4uAuthor
Known Participant
April 16, 2007
Should I change this to cfform?
<FORM ACTION="findElectrician.cfm" METHOD="post">
Enter your zip code: <INPUT TYPE="text" NAME="myZip" ... >
<INPUT TYPE="submit">
</FORM>

and should the page that has the search box contain a cfquery at the top?
I'm getting a CF errror- .../findElectrican.cfm not found but I pointed straightto it by dragging and dropping the file with DW
ace4uAuthor
Known Participant
April 16, 2007
Thank YOU!!
I mean that, really. You took the time to write that for me
April 16, 2007
The code below should give you the idea.