Actually, no lol. If you post your code, I can give you an update code snippet to show you what you need to do.

For this, and most cross-page checks, you have many options, but all options you...

it's done in your meta tags under the content portion. You put the path to your file within the content, and it automatically downloads.

depending on if you need it flexible, you can just write it in:
response.write("<form name=""form1"" id=""form1"" action """ & request.servervariables("SCRIPT_NAME") & """ method=""post"">")...

Actually, when you're adding rows, you do not select anything. Proper usage would be:

rs.open
rs.Add
rs.Fields...
rs.Fields...
rs.Update
rs.Requery

Set up some mail settings on your page. Find out which suits your server and the version of ASP you're using. Then supply the settings, and just mail them. Although, you must have a mail server. If...

That's odd, cause it should allow spaces.

Did you do it this way?
<input type="textbox" id="tb1" name="tb1" value="<%= rs.fields("column") %>" />

You just need to do something like this:

Create all your checkboxes, and order them however you wish since it doesn't matter.

They all need to have the same name, but different ID's.

By...

This is not an easy task at all sir.

But that's Classic ASP for you.

You might want to try looking something up, a third part control, that will do it for you. Try searching for "Cute Editor".

There is an easier way, at least in the long run. However, it takes longer to build.

What you would need to do is build a page on your clients web server that retrieves the information. When it...

Instead of all these if's, else if's, etc. Use select case statements. It's much faster and the server doesn't have to read every if statement, just till the one it reaches.

Will improve...

Actually vbscript/vb.net works the same in asp.net.

It's not much of a conversion, and is much easier to do in vb.net than regular vbscript.

However, it would take time to learn the controls of...

Are you stuck with doing this in ASP?

Asp.net would be much better for this.

Not in classic asp, however in asp.net yes.

Otherwise you redirect to yourself:
Dim strURL
strURL = Request.ServerVariables("SCRIPT_NAME")

If Len(Request.ServerVariables("QUERY_STRING")) > 1...

Yes I am sure it works, but you shouldn't rely on users being narrow minded about how to enter in their address.

You should have an identifier that separates all of them, IMO

Yes but how do you differentiate between the inputs?

Do you have checkboxes or something?

But please answer me this... so what happens if my address is..

15011 Via Hondonado apt. E
San Diego, CA 92129

How would you handle that, and how would you split the strings?

My suggestion,...

whatinput = "Coldstreet 123A 12345 Freezytown"


array = whatinput.split(" ")


SQL = "SELECT CL.organisation, CA.street,CA.zipcode,CA.city,RG.state,RG.stateID,KO.county,KO.countyID "&_
"FROM...

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=dbtest.mdb.dsn; User ID=gthompson; Password=Password4"

must have the semi-colons.

lose the brackets, they were there to tell you that you put your password and username. Lose all [] from the string.

Yes it is. Okay then this is how I would do it:
'Prebuilt SQL query is set to sql up to WHERE clause

Dim array()

array = words.split(" ")

For numero = 0 To UBounds(array)
If numero = 0...

When replacing a word, you have to replace all occurances:
conn.Open = "Provider=Microsoft.Jet.OLEDB.4.0 Data Source=[dbtest.mdb.dsn] User ID=[username] Password=[password]"

Set search =...

Where = "Coldstreet 123A 12345 Freezytown"

Okay, now obviously this is:

123 Coldstreet (apt. A??)
Freezytown, (State?), 12345

Right?

So change MM_dbtest_STRING to "conn"

WHenever dreamweaver codes something, like MM*, it creates a separate file to read off the data within it. Search for a file with MM in it, and then you can...

With city, do a split at the space, and then do the following:

For numero = 0 To UBounds(array)
sql &= " OR city LIKE '%" & array(numero) & "%'
If numero > 0 Then sql &= " OR city LIKE '%" &...

do a google search for

"pure asp upload"

You need a connection in order to use the recordset:
Dim MM_dbtest_STRING
Set MM_dbtest_STRING = Server.CreateObject("ADODB.Connection")
MM_dbtest_STRING.Provider = "Connectionstringhere"
Get a...

is MM_dbtest_STRING declared, and set? Sounds like it isn't.

You cannot insert data into two tables in one query, not in ODBC.

You will have to create two separate queries, one to insert data in each table.
INSERT INTO tbl1 (UserName, Password, FullName,...

yeah, but no one will hire me.

it's crappy.

You can download some software that will check where your bottle necks are, to see what lines are taking the most time to complete. However, glad to hear it's working.

REPLACE is a special keyword, what it says is that it will insert the record if it does not exist, however, if it does then it will overwrite or REPLACE it.

That's why I said in MySQL it will be...

check to make sure your data type of the fields. Keep in mind that all strings must have single quotes, like you have. However, all integers must have NO QUOTES otherwise it will not insert.
...

oh if it's MySQL, then yes there will need to be changes.

I don't use this stuff, so I don't truly know. But yes, I do think you can do that. However, make sure noquotes and it is single quotes. Also make sure that you are not replacing it with a period,...

Make sure that your server.MapPath path is correct. This means that this page has to be in the same directory as the database. That lies within your "Server.MapPath("Mypgdb.mdb") portion. Also make...

Well for the regex, what you can do is do the search for the hyphenless version. Then when inside the search, do a regex replace command to remove all hyphens. That way it will match regardless

You will only have one connection, but multiple record sets.

Change this a bit to do a more sophisticated join:
SQL = "SELECT CL.organisation,...

you would have to remove them, or use some very complex regex which would be extremely slow. Something would be like:
[a-Z|-] for each character. You would end up having to search every character,...

Yup, you get to mark as solved below your last post. it will go to me. Thanks :)

The period is a wild card. You would first need to replace the string that you are working with. replace all "-" for "." and then setup your regex. This way it will match: email and e-mail. However,...