Re: FLASH: He walks, he moves, he's... sockman!

[Helen Triolo]

David Hagellthorn wrote:

> 

> Helen,

> 

> What you have done with the search facility is exactly what I need to do.

> Can you point me in the direction of a tut. Thanks.

> 


Hi David.  The search is done in ASP (and the backend database is

Access).  It's done by passing a variable (eg, searchstr) from Flash to

a VBScript the opens a database connection 


Set conn = Server.CreateObject("ADODB.Connection")

conn.open "iTechnica","",""


and then uses a SQL string to search for the keyword that was passed,

like so:


  sql = "SELECT FlashAnswers.date, FlashAnswers.subject,

FlashAnswers.comment WHERE FlashAnswers.subject Like '%" &

Request.Form("searchstr") &  "%' ORDER BY FlashAnswers.subject"

set rs = Server.CreateObject("ADODB.Recordset")

rs.Open sql, conn, 3, 3


(The SQL string I used is actually a little more complicated, with inner

joins to connect tables and more conditionals, but that gives you the

basic structure you need).  So, if you know ASP already, it's pretty

straightforward.  If not, well, you could search on "asp" in the

flashlist. ;-)  I know there are a couple pointers in there.  One place

many people have found good basic variable-passing-to-asp info is 

http://www.asptoday.com/articles/19991001.htm.  Alternately, you could

do the search in something entirely different (PHP, Cold Fusion), but

it'd still be the same idea.  If you have any specific questions, please

ask!


Regards,

Helen

__________________________________________________________________

i-Technica: Innovative Internet Solutions (http://i-Technica.com)

designeri-technica [dot] com

301-424-6037


flasher is generously supported by...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

     flashforward2000 and The Flash Film Festival

  "The World�s Premier Flash Solutions Conference and Expo"

 March 27-29, Nob Hill Masonic Center, San Francisco, California


-Register before Feb 25 and save $200!!-- www.flashforward2000.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

To unsubscribe or change your list settings go to

http://www.chinwag.com/flasher or email

helpchinwag [dot] com