I did something similar recently. Basically a form which requires approval before being saved.

So, I created a copy of the table which normally holds the form data.
On save, the data is saved to...

You should ask this question over in the .net forum....

I feel your pain. We have several applications written in classic asp. We are starting all new projects in VS2008, .NET platform.

All of our legacy asp code is maintained via Dreamweaver CS3 or...

With ASP, you want to use the QueryString Collection of the Request Object.

http://www.w3schools.com/ASP/coll_querystring.asp

So, you would code something like this:

Dim email
email =...

CSS styled XHTML is much better for a blog. gridviews would probably just create too much extra html and probably even table tags.... :S

If this is a public site, forms and javascript are not a really good idea in terms of accessibility. Industry best practice is actually to have all forms working _without_ javascript, and then you...

I dunno, that was 2 years ago :P !!

This helps a lot actually. Too much classic asp on the go.

The c# code is awesome. I was trying to avoid using too many system resources by using a DataReader, but looks like that backfired.
...

Some strange errors occurring in my asp.net website.

I was using the MS ApplicationBlocks.data.dll to connect o my SQL database. Once I started testing my website on IIS as opposed to the ASP.NET...

This is c# code, not classic asp, you should ask this in the ASP.NET forum.

Sounds like a web application to me. I would recommend heading over to w3schools (http://www.w3schools.com/ado/)..... best place to start learning classic asp IMHO.

Look up the ADO, ASP and...

This article explains how. (http://drnicwilliams.com/2006/11/21/diy-widgets/)

Try doing a response.write(Request.Form("buttons")) on your decision.asp page and let me know what the value is when you click on either button.

Ok, the answer lies in your use of request.form, which is incorrect.

You are requesting the value of your form. You must request the value of a form item, not the form itself.

So you have
...

Can you post your form html? Thanks.

There is probably just a disconnect between the form item names and your form processor code.

That would depend on the ShockwaveFlash1 object. You could use a loop from 1 to 13 to cut down on the code, but if the object doesn't allow setting multiple variables in one call, you really don't...

use the split function using : as your find character.

Then, using your array set your textboxes = to the proper indices.

textbox.text = myarray(1) etc.

myarray(0) will hold the text...

The command object needs to know how to connect to your database. So yes, you need either a connection string or a connection object. I can't remember if a command object can use just the...

How about using javascript?

document.myform.submit;

You're welcome! Your previous use of addnew was suspect to say the least! I'm glad your up and running again.

I would now suggest you start using parametrized queries...

This tutorial should get you going. (http://www.15seconds.com/issue/010718.htm)

Can you please verify the exact line and highlight it? I havn't see the addnew method used like that before, not saying it won't work, but just to make sure.

Try setting the activeconnection first:

set comm=Server.CreateObject("ADODB.Command")
comm.ActiveConnection=conn

I usually just use:

rstest.Open "tablename", constr, 2, 2

First off, thats C# and not asp. This needs to be in the ASP.NET forum.

Second, if it worked fine and then SQL Connect suddenly stops, check your database not your code.

You probably have an...

You don't give us much to go on here. Do you have a sample page, or a link to the control page?

Typically javascript like so will work:

var txtValue =...

freevbcode.com has some really good classic asp code for download. I'd start there.

aashishn86, you cannot use named parameters without first declaring them.

Try

rstest.Open "test", constr, 2, 3, 512


See here for more numeric values....

You don't have adCmdTable defined. ASP doesn't have the built in definitions as does VB. You need to declare it first.

do this before you set the commandtype:

dim adCmdTable
adCmdTable = 2
...

Most hosts support uploading your own 404.asp and check there first by default. Also, try this page for more information. (http://www.aspemporium.com/tutorials.aspx?tid=15)

I'd use either php or ASP.NET. I've lost any hope in classic ASP over the years . :)

Ok, this isn't really hard. You just need javascript. Of course navigation with JavaScript is almost never a good idea, but here is how.

I'm assuming you have a page called index.asp. index.asp...

I've seen crazy stuff like this before.
Try this query:

set batable = adoDataConn.execute("Select bands.band from bands order by viewcount desc limit 10")
dim bandName
do while not...

Is there a specific reason you are using excel as a database? It is not a very scalable method. If your users really need to access the data as an excel spreadsheet you can always give them the...

Try using disconnected recordset, then apply the recordset to the database after editing.


Dim rst As New ADODB.Recordset
Dim xData(2, 1) As String

Private Sub Form_Load()
xData(0, 0) =...

I could not agree with you more. This is a large code base that I've inherited from a previous developer so most of the code was already written....

For those newbies reading this, parametrized...

Note: I debated whether this should go in ASP forum or SQL Server forum and I think it belongs here.

Ok, I have a classic ASP web application, a custom intranet, which has been used in 7-8...

All this means is that you have more up-front planning to do.

You must map the current db structure to a new db structure.

This all takes time of course, and it's your job to communicate to...

The warning should reference a file and line number. Paste that line and surrounding code.

You need a new connection object for each database. If you aren't using classes, just have three recordsets, one for each database.

I'm sure there is a better way to do all of this, but without...