search function in ASP!

Monie · #1 Jul 26th, 2004, 04:22

is if posible to do a search function in ASP that can search not just in one database, but it can preview a search result in 2 or 3 database!

Smokie · #2 Jul 26th, 2004, 08:38

Yes of course, just connect and select from each different database on the same page.

Monie · #3 Jul 27th, 2004, 05:19

well..i am not good in coding! i am using MACROMEDIA ULTRADEV 4 to develop my site. as far as i know, each page will be allowed to connect to only one database! maybe some adjustment could be done in the sql command?
if you familiar with that software, could you teach me how?
thanx...

Smokie · #4 Jul 27th, 2004, 08:48

Do you want to select data from different databases or just different database tables?

courtjester · #5 Jul 27th, 2004, 12:31

If it's from different tables and the same database, then you type in your connection at the top of your page FE-

Code: Select all

<% Set connectionToDatabase=Server.CreateObject("ADODB.Connection")
connectionToDatabase.ConnectionTimeout=60
connectionToDatabase.Open "DSN=Mydatabase"%>

Now if your not using a DSN use your regular physical path here...
Then all you have to do is Type in your queries from each of the tables.

Code: Select all

<%
Set recordSet =Server.CreateObject("ADODB.Recordset")
recordSet.Open "SELECT * FROM TableName" ,connectionToDatabase, 1,2
Do While Not recordSet.EOF
	Response.Write(recordSet("Whatever"))
	recordSet.MoveNext
Loop
%>

Then you can just keep on going with your next one. Make sure though that you do not close your connection to the database until you query the last table in it.

Now if your connecting to multiple databases...

Set your connection to the database.

Code: Select all

<% Set connectionToDatabase=Server.CreateObject("ADODB.Connection")
connectionToDatabase.ConnectionTimeout=60
connectionToDatabase.Open "DSN=Mydatabase"%>

Use your tables...

Code: Select all

<%
Set recordSet =Server.CreateObject("ADODB.Recordset")
recordSet.Open "SELECT * FROM TableName" ,connectionToDatabase, 1,2
Do While Not recordSet.EOF
	Response.Write(recordSet("Whatever"))
	recordSet.MoveNext
Loop
%>

Then close the connection...

Code: Select all

<% connectionToDatabase.Close
Set connectionToDatabase=Nothing
%>

Now you can Connect to your next database and start from there.

Code: Select all

<% Set connectionToDatabase=Server.CreateObject("ADODB.Connection")
connectionToDatabase.ConnectionTimeout=60
connectionToDatabase.Open "DSN=Mydatabase2"%>

And then just repeat the above and that'll get ya going. Now Im stil New to ASP , but that's how I do it. It works and it seems fine to me. I haven't had any problems with it so far.

Amari · #6 Jul 29th, 2004, 16:30

hey is it possible to have different go to different pages when they login on my asp site I need a code that tells me how to do that? Like for instants, lets say a person with a free account logins in and goes to the free account page right after they login! well can I make a person with a paid account go to a paid account page after logging in?

courtjester · #7 Jul 29th, 2004, 18:35

You can either do that or store things in their database. For Instance....

Code: Select all

<%
dim var
var = recordSet("Paid")

If var = "" Then
Response.Write("Blah Blah Blah")
Else 
  Response.Write("Howdy, welcome to the paid portion")
End If
%>

Where you can basically put your two pages in one and just let the user see the one that corresponds to him/her. Just make sure you connect to your database first :wink:.

Ohh yeah, you can also use the Response.Redirect tag if you would rather keep them as seperate pages. It's up to you.

Amari · #8 Jul 31st, 2004, 18:47

thx for the addvice, but can I make 2 different types of users go to 2 different pages after logging in?

courtjester · #9 Jul 31st, 2004, 21:25

Yeah, you can do this the coded way, or take a shorter way, but it adds a page.. I'd use the shorter version.. it's much faster IMO.

Code: Select all

<%
dim UserX
UserX = recordSet("UserType")

If UserX = "1" Then
      Response.Redirect("PageForThem.asp")
   Else
      Response.Redirect("PageForOthers.asp")
End If
%>

That will do it for you. This is the shorter way of doing it (code wise). Hope that helps.

Amari · #10 Aug 2nd, 2004, 17:10

thx that worked! I needed that advice! Now do you know how to make a game like cartoonorbit?

Amari · #11 Aug 2nd, 2004, 17:17

Also after then login can you make them view a page for like 5 seconds then be redircted to the real page?

Rob · #12 Aug 2nd, 2004, 18:14

use this code:-

Code: Select all

<META HTTP-EQUIV="refresh"
content="5; URL=http://the URL of the second page">

That gives you a 5 second delay. It needs to be placed in the <head> section.
Use ASP to substitute the URL part of the above for the right page.

Smokie · #13 Aug 3rd, 2004, 07:59

Rob you need to edit that post mate!

Rob · #14 Aug 3rd, 2004, 10:36

:wink:

Amari · #15 Aug 3rd, 2004, 18:02

thx! Also I need to know how to make a game could anyone help or knows a website that would help?

Amari · #16 Aug 3rd, 2004, 18:08

could you explain that script a little more plz?

courtjester · #17 Aug 3rd, 2004, 18:27

what do you need to know about making a game? Do you need to know the programming? The software? The way to store information to a database? The way to transfer Variables from Flash to ASP? How to make something move on button press? plz be more specific. Thanks.

Amari · #18 Aug 3rd, 2004, 19:10

I need to know the software the best software for free and paid software and A little bit or programming!

Amari · #19 Aug 3rd, 2004, 19:13

hey also can I make a person with a paid account go to a regular page but then be able to come back to all the paid account pages? I mean like, make the website site check his account type and redirect him to specific pages?

Amari · #20 Aug 6th, 2004, 19:06

Wow will anyone reply to my question?

		Webforumz.com > Main Forums > Program Your Website > Classic ASP
search function in ASP!