I am a SQL idiot and I need some guidance.

I have Windows Server 2003 and SQL Server 2000 installed on my server. I want to use PureASP 2 to upload files and use SQL to handle the form data. I've been able to get the upload to work (yay!), but as far as using SQL for the form data, I have no clue what to do.

The SQL server software is installed because we have some customized web server software. I didn't setup this software, and I SURE don't want to mess it up!

I may be making sound far scarier than it really is; I'm just completely ignorant about SQL....

Are you at least familar with MS Access? You could use Access to build your database and control your SQL Server from your desktop.

~ ~ ~ ~ ~ ~ ~
Chris Charlton <i>- DMXzone Manager</i>
<font size=1>[ Studio MX/MX2004 | PHP/ASP | SQL | XHTML/CSS | XML | Actionscript | Web Accessibility | MX Extensibility ]</font id=size1>

I now nothing about SQL, and an extremely minimal amount about Access.

Is there a way to make the submit action preform two different commands? There are lots of cgi scripts out there that will send the form data to me, but PureASP pre-fills the form action field with "&lt;%=GP_uploadAction%&gt;". If there were a way to have Submit preform that action, but also preform a cgi script, that would be cool.

Well, <b>DW MX/MX2004 will help code the basic SQL for you</b>, INSERT form data, UPDATE form data, and DELETE form data. <b>But it won't help you make your database structure - which is required!</b> (Tables w/Columns & ColumnTypes, VIEWs, Stored Procedures - if you get that far)

I suggest you look through our <b>Tutorials</b> section: www.dmxzone.com/categories.asp?TypeId=2 . Especially, <i>"Upsize Access database (to SQL Server)"</i> (www.dmxzone.com/showDetail.asp?TypeId=2&NewsId=4131). Of course DMXzone's full of Premium Content/Articles as well, but I couldn't find one that shined for you offhand.

NOTE: <b>I suggest you take a shot at learning Access</b>, since it is the little-brother to SQL Server, and you can make a database in Access and it can easily be upgraded/migrated into your SQL Server. The best place I found to learn Access inside out is Lynda.com, <i>"Learning Microsoft Access 2003"</i> (movielibrary.lynda.com/html/modPage.asp?ID=98), or signup a watch Lynda's <i>"Dynamic Development Using ASP and Macromedia Dreamweaver MX 2004"</i> (ch.3-<i>Working with Databases</i>, and ch.9-<i>SQL Basics</i> - movielibrary.lynda.com/html/modPage.asp?ID=91). I wish we had some more beginner database articles here, but I know these online video tutorials rocks (from personal experience), and they're fast!

~ ~ ~ ~ ~ ~ ~
Chris Charlton <i>- DMXzone Manager</i>
<font size=1>[ Studio MX/MX2004 | PHP/ASP | SQL | XHTML/CSS | XML | Actionscript | Web Accessibility | MX Extensibility ]</font id=size1>

I almost forgot! DW has a tutorial builtin, using an Access database. You may want to sift through that before paying for something, just so you know you've looked at your current resources.