Flash :: Search Database

[F8] Help With My Design Around Asp Search Database.
I dont think my title explains it. I'm making a website for my mom who does real estate. She pays for this system http://www.redcarpetkeimviking.com/IDX/idx.htm and i want to incorperate it into her site. You can search for houses and bring up listings with it and all that jazz.

The way ive been planning on doing it is having frames and using flash for the menu and top bar. But i was wondering if i could add the idx asp(above system) code into flash(copy paste source) and just have the stuff come up in a flash site?

Its probably a dumb question but i wanted to be sure before i started making the site.

Or if you have any suggestions let me know.

Thanks, Dan.

Search Xml Or Access Database
Hi everyone

this is the first participation for me in this forum

i have some trouble with flash and databases

what i want to do is " access data from external file "XML or Access database" from flash - NOT IN THE WEB - "

i found alot of examples explain how to access xml file and load data from it
but i found most of them not useful for my case

i want make search in the xml file or database
and display the reslut in list

this not a web site , it is a cd

i want to do this using any way xml file or access database or any thing else

i use a smaple xml file like that

<company>
<name> co 1 </name>
<phone> 010 </phone>
</company>

please any one could help me

thanx

ayman

Is Database Search Possible With Flash
what i want to do is make a phone directory. the database maybe in any extension but i want flash movie to read from it and present the datas in a searchable manner....ie we should be able to search the database with keywords that may be actual company name like "hotmail" or it may be a category like "mail service". And it must also be able to load another text file assigned to the loaded data which may contain a short description of the companies that are displayed by the search command.............

I kno it is a complex thing....Anyone if you kno some tutorials which can help me on this please point me to that tutorial.....

please someone advice something....a little info on a single component like search or database or anything small would also be appreciated...

thanks,

Database Search: Php Or Flash
We have a (probably small) news & events database for a corporate site, and need to create a search engine in Flash. Are either of these options better than the other?:

1. Put the search logic into a php script, get flash to call it and just display the results.
-Only relevant results are sent over the internet
-Every search requires a new call to the php/data base

2. Put the search logic into the Flash, and have the php simply to create an XML file
-The entire database is sent over the net work, but only once.
-New search calls data once when movie is loaded, and never has to do it again.

Search Keywordsin Database (via Cfc)
hey folks,

I am trying to get my store to be able to search the keywords column in my database (access)
I have this for my cf function=

<cffunction name="keywordsearch" access="remote" returntype="query" output="false">
<cfargument name="keyword" type="text">
<cfquery name="SearchQuery" datasource="cart">
SELECT ProductDescription FROM products WHERE keywords LIKE '%#keyword#%'
ORDER BY ProductDescription
</cfquery>
<cfreturn SearchQuery>
</cffunction>

Thsi I believe is all well and good,
but I am having problems with the flash side of it.

I have categories that are selectable in the flash movie using variations of this code= buttons have a on release getData (1) / (2) etc...

function getData() {
basic.Products(dataView.getSelectedItem().data);
}
function Products_Result(result) {
_root.infoMC.ProductDescription.text = result.getItemAt(0).ProductDescription;
_root.infoMC.SKUNumber.text = result.getItemAt(0).SKUNumber;
_root.infoMC.UnitPrice.text = result.getItemAt(0).UnitPrice;
_root.infoMC.manufactLink.htmlText = result.getItemAt(0).manufactLink;
_root.infoMC.Information.text = result.getItemAt(0).Information;
_root.infoMC.imageMC.text = result.getItemAt(0).image;
}

But I am unsure how to say look at the searchfield text box, then grab relivant information from the keywords column, and return it to the dataView list box.

Any help would be appretiated in this, but there is no rush.

Thanks

Search In A Mysql Database
I have made the following script to search in a Mysql database. The script works fine the first time you search. Second time if you try to search for some thing else the old search result keep appearing. Is there some way that i can clear the search result when ever i initiate in a new search?

This is my script:

this.createEmptyMovieClip("myForm_europe", 0);
myForm_europe.newSearch = 1;
myForm_europe.searchType = 0;
myForm_europe.searchArea = 0;
myForm_europe.pictureReq = "0";
myForm_europe.fromYear = "0000";
myForm_europe.fromMonth = "00";
myForm_europe.fromDay = "00";
myForm_europe.toYear = "0000";
myForm_europe.toMonth = "00";
myForm_europe.toDay = "00";
myForm_europe.duration = "0";
myForm_europe.continent = "1";
myForm_europe.country = "$country";
myForm_europe.region = "0";
myForm_europe.rCity = "0";
myForm_europe.rooms = "0";
myForm_europe.oldContinent = "0";
myForm_europe.oldCountry = "0";
myForm_europe.oldRegion = "0";
myForm_europe.getURL("../search/searchResults.php", "_parent", "POST");

I have also tried this code:

this.createEmptyMovieClip("myForm", 0);
myForm.newSearch = 1;
myForm.searchType = 0;
myForm.searchArea = 0;
myForm.pictureReq = "0";
myForm.fromYear = "0000";
myForm.fromMonth = "00";
myForm.fromDay = "00";
myForm.toYear = "0000";
myForm.toMonth = "00";
myForm.toDay = "00";
myForm.duration = "0";
myForm.continent = "6";
myForm.country = "$country";
myForm.region = "0";
myForm.rCity = "0";
myForm.rooms = "0";
myForm.oldContinent = "0";
myForm.oldCountry = "0";
myForm.oldRegion = "0";
myForm.getURL("../search/searchResults.php", "_parent", "POST");

Hope you have a solution

/Kafir

Flash CD-ROM Database Search
I am creating a Toy Library CD-ROM probably using Flash since there is a previous version that was done in Flash (or I would consider Director) and need to be able to include a database on the CD-ROM that can be interrogated, i.e. the user can search for toys by keyword and other criteria. The CD must be independant of the web since it is used where there is no Internet access.

No updating of the database needs to happen in the application, read-only is fine its just searching and displaying, but from time to time there are new toys added to the library, and therefore maintaining the database in the form of a text file would be ideal. The CDs are burnt onto CD-R as required not mass produced. The previous version of the project done by someone else. It seems to be some kind of simulated database done by using lots of xml files. It works but I don't know how and seems very cumbersome plus the FLA development files etc are not available.

If this were going on the web (which it isn't) the database would be done in mysql since the database is relational, there are tables linked by foreign keys for categorising the toys by Age, Learning Goals etc, however I was thinking of making it a flat file for this. There are maybe 650 toys so speed may or may not be an issue.

There needs to be a PDF application form on the CD too to print off, and the CD should autorun and be cross platform if possible, PC based if not.

There are also some 'About Us' type pages which need to be scrollable text, which should be easy enough.

I have experience in Flash for the web, database programming in mysql and of 'V12 Database Engine' in Director for CD-ROM work from a long time ago, so should be able to pull this together preferably in Flash with txt or csv file for data but would be grateful for any advice on the best approaches to the searchable database part especially. Perhaps simulating a relational database using RecordSet is possible but I don't know anything about that as my actionscript skills are rusty.

How Do You Do A Wrod Search / Database In Flash 5
How do you do create a database in Flash 5?????

I need the useer to do a word search through a database of names to find what they want.

How Do You Do A Word Search / Database In Flash 5
How do you do create a database in Flash 5?????

I need the useer to do a word search through a database of names to find what they want.

Search String For Most Wordmatches In Database
Hello!

I'm working on a chatbot program and I need to make a search engine in flash. I already have on searchengine that search a string (with the users inputtext in it) and compares it to phrases in a database ( a xml file in this case). But I also need another type of searchengine, since I can't fill a file with all phrases a user might type.

So the searchengine I need, needs to work like this:
When the user have typed in his/hers text, the search will compare it to some databaserecords. And find the databaserecord that matches most words from the user text. So if the user types in:
"I have a terrible headache".

The search will start seeking and the database maybe looks something like this:
1. I sick
2. I happy
3. I stomageache
4. I headache
5. You are sick
6. you're sick
7. you headache

Then it will return record number 4, because it found the word "I" and "headache" there.
Anyone have some tip on how to achieve this?

Thanks in advance!

Search Field With A Lotus Notes Database
I can get this to work in HTML, here is the code for that.

<form action="http://server/Lotus/cd_directory.nsf/ViewSearchGeneric?CreateDocument" method="post" name="form1" id="form1" >
<p style="margin-top: "> <font size="2" color="808080" face="Arial, Helvetica, sans-serif">NatureWorks Directory Search</font><br />
<font face="Arial, Helvetica, sans-serif">
<input name="SearchString" size="25" />
<input name="ViewToSearch" value="Last Names" type="hidden" />

Now let say I use "Smith" for the item to be searched. The address field will display the following.
http://server/Lotus/cd_directory.nsf/Last%20Names?SearchView&Query=FIELD+Display_Name=s mith*

This is much different from the above code. How can I get the same results in a flash file? I've been working with the following ActionScript that someone gave me.

in root U place textfield with var=searchstring
on submit button :
on(replace){
getURL("http://server/Lotus/cd_directory.nsf/ViewSearchGeneric?CreateDocument" ","POST")
}

Thanks

Query (Search) MS Access Database Using Flash MX And ASP
Hi All,

This is my first time to play around with Flash and .ASP. I created a contact list form using Flash MX that has couple fields such as: FirstName, LastName, PhoneNumber, Email and Comments. I have the EXACT same fields defined as TEXT on the MS Access database with an addion of ContactID which is a Primary key and Auto/Number. The table on my MS Access database called Contacts.

I can INSERT contacts information from Flash MX to MS Access using .ASP OK however, now I would like to go furthur by Querying/Search the ContactID (which is the MS Access record) and want it to give me the FirstName, LastName, etc... The problem that I have is when i click Search, it does not return anything. The AddContacts.mdb and QueryContacts.asp files are stored under the /cinformation directory and the flash file .html (.swf) is in the same directory as the index.html file. Please help.

This is how I defined the fields in Flash MX.

First Name, Last Name, Phone Number, Email and Comments as Dynamic Text and Variables as follow: wFirstName, wLastName, wPhoneNumber, wEmail, and wComments respectively. By the way, the box where the user enters the ContactID (record #) is Input Text with the Variable of myrecord.

Below is the values that I defined as soon as the Search button is hit.

on (release) {
loadVariablesNum("http://yourwebsite/cinformation/QueryContacts.asp?Record=" add myrecord, 0);
myrecord="";
wFirstName=FirstName;
wLastName=LastName;
wPhoneNumber=PhoneNumber;
wEmail=Email;
wComments=Comments;
Message="Searching in progress .... Please wait";
}

See my QueryContacts.asp file.

<%
'Pass the ID you got back in the field called record
record=request("Record")
Set objconn=server.createobject("adodb.connection")
objconn.open "provider=microsoft.jet.oledb.4.0; data source=" & server.mappath("AddContacts.mdb")
set objrecord=server.createobject("adodb.recordset")
sql="select * from Contacts where ContactID =" & record

objrecord.Open sql,objconn

if objrecord.eof then

Response.Write "Record Not Found "
'response.end
else

FirstName= server.URLEncode(objrecord.fields("FirstName"))
LastName= server.URLEncode(objrecord.fields("LastName"))
PhoneNumber= server.URLEncode(objrecord.fields("PhoneNumber"))
Email= server.URLEncode(objrecord.fields("Email"))
Comments= server.urlencode(objrecord.fields("Comments"))

Response.Write "First Name - " & FirstName & "<BR>"
Response.Write "Last Name - " & LastName & "<BR>"
Response.Write "Phone Number - " & PhoneNumber & "<BR>"
Response.Write "Email - " & Email & "<BR>"
Response.Write "Comments - " & Comments & "<BR>"

end if
%>

Database Search With Multi-press Button
Hi, I'm trying to create a website that will allow you to search a database by clicking on multiple buttons to narrow your search.

It's like this - If i'm searching for a dog from a database I'll have 5 buttons:
Big Breed
Medium Breed
Small Breed
Hypoalergenic
Puppy

Each button will be blue.
When you click each button once it will turn Green which means you want that trait. When you click the button the second time it will turn Red, which means you don't want that trait. when you leave the button blue, it leaves those options open. So if i wanted a small or medium puppy, i would make the Big Breed button red, and the Puppy button green, and leave the other buttons blue.

Then you click search, and it shows you which Dogs meet your criteria.

How do I do this?

I already have the database, now I just need to know how to make the buttons in flash, and the actionscript that will narrow the search.

Search Engine With Offline Database (msacces/xml)
is there anyone know how to make serch engine system with offline connectivity to database for an interactive cd.
when the search result displayed, it can become a link to another movie?

Senocular XML Search Tutorial (search Query Case Sensitive)
Hi
I've just tried senocular's xml tutorials.

http://www.kirupa.com/web/xml/examples/searchbestof.htm

The search query seems case sensitive. How to make it accept upper and lower case characters. Actually i'm trying to make a search by myself by using the same code.

Search Engine -user Can Search His Pictures With Keywords- HELP
I was reading about search engines and I came across a post. Being fairly new to flash I do not know how to develop this. I have a client who owns a small furniture store. I am setting up his site. He wants it to be all flash based. He has about 300 pictures of his products.I need to make a search engine in Flash so that the user can search his pictures with keywords. I read a suggestion that would fit my needs- create an array of picture names then use a loop to check if the keyword is in the array. I have been going through tutorials with no luck- can someone please help. Maybe start the code the person is talking about so I can just expand on that.

How To Build A Search Engine To Search Ur Own Flash Site?
Hey its Stuart here again.
How do you build a search engine to search ur own flash site?
Do you guys have any links?

Search Page With Search Result From Text File
I want to make search page with search result In Flash, Data will be come frrom TXT file. can any body help my or give me source(FLA)??

Search In Flash Using Atomz Search Services
does anyone have any information on using atomz search service using flash? please reply....
thank you

Search Flash Content In Search Engines
Do you have any experiance how to optimize flash site for search engines?

If swf contains text an links, how can i constrain search engines like Google,... to find this?

Thanks

Flash Search Field - Atomz Search
I currently use Atomz for their search engine. A clients site as of now is all HTML, however I am buidling some flash elements which will incorporate a simple "search" field and submit button.

I will include the HTML, however I am unsure how to make a form in Flash to be able to include the hidden fields, etc. I hope this makes sense, and thank you in advance!

<form method="get" action="http://search.atomz.com/search/" name="search">

<input name="sp-q" class="textbox" id="sp-q" value="Search" size="15">
<input type="hidden" name="sp-a" value="sp1002ad5d">
<input type="hidden" name="sp-p" value="all">
<input type="hidden" name="sp-f" value="ISO-8859-1">

<input type="submit" name="Submit" value="Submit">
</form>

If someone could create a small file, or let me know where to place what code where, please let me know. Any help is greatly appreciated! As well, if you have paypal, I can send a little something for the help!

Database Driven Design Database?
Do forgive my vague query in the title here.

Greetings all. I'm new to the site. Have searched this site and others and did a lot of googling but haven't found what I'm looking for. Perhaps because the query is wrong.

There are two things I would like to accomplish:

1.

I have an archive of over 250 designs which I have titled in a specific alphanumerical order.

I'd like to put up a "catalog" of these designs online on my site (which is the site I want to create).

The functionality should be somewhat like this:

The 250 designs would be broken down into 3 categories.

Each category will have x number of designs (around 80 to 100).

A scrolling navigation for the designs is what I need. Although I have done a scrolling menu in the past, I've never done anything for so many designs.

The designs are already sitting on the server in the database.

I know that I can create the scroll menu such that once the thumbnail in the scrolling menu is clicked, it'll open another section of the page and load the larger version of the design. This is however tedious to do for over 200 designs.

I'm looking for a way that when the mouse clicks on the thumbnail, the place where the full scale of the design would be displayed knows which design to display.

2. The second part of this site should have search capability. For instance, if I key in the following code: SFA-1205 (which is a design number), it can search the database and display the design in the same viewable area I had designated for the first step.

Anyone any ideas?

Thanks in advance,
Raju

Search Help Text Search In Flash
Hello, i'm realy stuck, and I need help... read dead end , i need to make a search on my site in flash, and also i need to explain ... what i need , example, whole site is in flash, and i need when someone wonna to find something just type word or sentence and then find on my site, but not google find or something like that... i wonna something easy, like CTRL + F, but label with find button... if anyone can help me or give me a guide i will be so happy, so thanks

sorry for my english... I hope it's readable )

Database > ASP > Flash > ASP > Database
Alright, so I have my database, ASP code to get the database, and I have my flash movie that gets the ASP. Now I want to send stuff form Flash to ASP and into my Database using a different ASP file. How can I do this?

No Search On Search Engines How To Do It
i i made some sites of well known people a site for their family party and they do not want all the world to see it just friends how can i have it on the net and stop the search engines from finding it
i saw it once one can code in no search or no index or something ,does anyone know
id appreciate it
thanks
faith

Database
Can you, and if so how would you go about creating a flash website that can read to and write to a database. I really need help on this one.

Database
Hello i need a database that views a few pictures on the front page with tekst if you click on it it wil show more pictures with tekst. is there anybodyt who know where i can find this it's for a tourist information site in australia.
please send me a e-mail if you have any info:

al@b2p-connect.nl

Database
I need to make a data base that works together whith Flash 5. How do I do this?
And, is there a easy way to do it? Or just one hard way

Keep the weather cool! ;D

Database
Is there anyway that a flash movie can be manipulated using Script to refer to a Database file from Lotus Approach? It needs to have the ability to search and sort ... Anyone?

Database ? Help Me.....
ok, i'm going to design a site for a music store and they want to be able to sell stuff from the web site, so my question for you is how would i be able to go about this?
what programs should i use, or can i just do it all in flash? do i get in contact with a company and they make it so people can buy stuff off the website using a credit card?
someone told me that i will need to make a database, if that is true how do i go about doing this.
please help me....

thanks-

Database?
Okay, heres a question for all you flash geniuses
is there any way to access a database from a flash movie, and if so, is there any way of displaying those results in the flash movie itself.
You see, i already know how to send variables out of the flash movie, to an asp page, which does the search and displays the results in a new html page.
BUT, is there any way to send the results of the search back to the movie, so it can display the results????
PLEASE HELP
thanx

What....How....Where? Database...
I have minimal to no knowledge on databasing...

Dilemma,

I need an inventory (houses)- searchable by various ways (location, price...etc.)

The site in question is http://www.needrealty.com and it is written totally in flash. I need to be able to search for specific movie clips. I need the search to be able to pop up a movie clip that contains an image, text, and link.

Now questions I have...

What language will I need to learn, PHP MySql CGI???
Not a how but Can this be done/????
Where the heck do I go for starters...

Thank you to anyone who can answer me any of these questions...

Database
I want to upload some files to my website every now and then and have them automatically displayed onto the flash page. How would I go about doing this (using a database or something??)?

ghjr

Database
Hi everyone

When I want to make a cart in flash, which database is the nicer, more efficient, fast... to use?
which language is it using
and does it need scripting between flash and the database
and if yes, which script?
can someone help?
thanks
françoise

XML DATABASE
hey all,
here is my problem. I have designed a site entirely in flash 5 for a client, I have to add a cocktail section to the site, where the user can click on a alchohol brand, for instance "Midori". Once they click this then they get a list of all cocktails that have midori in them on the site. From this they can pick a cocktail and then are shown the ingredients.Does anyone know the best way to do this, I was told XML was the way to go but have never used it before? My problem is that I have no grasp on XML...does anyone have any kind of an example of this?
thanks,
tom