File Upload .csv file directly to database

	Home Register Search Help Login

Sponsors

Hosting from $3.99 per month!

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions. dd

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

File Upload .csv file directly to database

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> File Upload .csv file directly to database

Page: [1]


dzirkelb1 Posts: 1321 Joined: 10/5/2004 From: Cedar Rapids, Iowa Status: offline	File Upload .csv file directly to database - 1/20/2005 15:41:50 I am going to submit a .csv file to my web server (win2000 server, iis5.0, fp2003). At that time, I will rin an .asp script to automatically put the information into the required fields in my database. I have a couple questions in starting this: First off, my file upload simply doesn't work. I have http://www.msultd.com/upload.asp which is as basic as it gets...it uploads a file to the upload folder. It doesn't work at all, it appears as to work, meaning no errors are given, but no file is actually uploaded. What am I doing wrong? The permissions on the upload folder are set to everyone has full control. 2nd...is there a tutorial somewhere that will help me start the automated scripting to add info to the database once I get my upload to work so I dont' have to ask here? :) Thanks!


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: File Upload .csv file directly to database - 1/20/2005 15:47:52 quote: The permissions on the upload folder are set to everyone has full control. Are you certain the IUSR_machinename has write privileges? Not trying to insult, but more often than not, that priv is not set. _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to dzirkelb1)


dzirkelb1 Posts: 1321 Joined: 10/5/2004 From: Cedar Rapids, Iowa Status: offline	RE: File Upload .csv file directly to database - 1/20/2005 15:50:19 added IUSR_machinename to full control in the folder permissions under security and still a no go...do I have to it in IIS? (in reply to rdouglass)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: File Upload .csv file directly to database - 1/20/2005 15:52:48 quote: IUSR_machinename You didn't actually use the word "machinename" did you? _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to dzirkelb1)


dzirkelb1 Posts: 1321 Joined: 10/5/2004 From: Cedar Rapids, Iowa Status: offline	RE: File Upload .csv file directly to database - 1/20/2005 15:54:40 hehe, no...thats not even an option when selecting users :) (in reply to rdouglass)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: File Upload .csv file directly to database - 1/20/2005 16:00:07 Did a small .gif file get uploaded? Have you checked any Event Logs for hints? ...Security, Application, System, etc.? Without looking / testing the code for upload.asp, I wouldn't know where to turn after that.... _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to dzirkelb1)

dzirkelb1

Posts: 1321
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

RE: File Upload .csv file directly to database - 1/20/2005 16:06:32

no gif file, code for the page is this:

<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
</head>

<body>

<form method="POST" enctype="multipart/form-data" action="--WEBBOT-SELF--">
	<!--webbot bot="FileUpload" U-File="_private/form_results.csv" S-Format="TEXT/CSV" S-Label-Fields="TRUE" S-Destination="upload/" -->
	<p><input type="file" name="F1" size="20"><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>

</body>

</html>

Checking into event logs now...unsure on which ones to check really :(

(in reply to rdouglass)


dzirkelb1 Posts: 1321 Joined: 10/5/2004 From: Cedar Rapids, Iowa Status: offline	RE: File Upload .csv file directly to database - 1/20/2005 16:09:58 Only event logs I have running are Application log (nothing related), security log (no events) and System log (billions of warnings saying SMTPSVC Message delivery to the remote domain 'XXXX.com' failed for the following reason: The remote server did not respond to a connection attempt. the domain varies...I'm assuming this is because we do mass emails to our thousands of shoppers in a database and hoping its not a virus and this machine is set up as a spam server {crosses fingers} what log should I hve running? (in reply to dzirkelb1)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: File Upload .csv file directly to database - 1/20/2005 16:26:35 quote: U-File="_private/form_results.csv" That's where it saved the uploaded file on my server when I ran that code on my server. No errors, just puting it exactly where it was told. Is that where you anticipated it going? Try changing the name and test it again to see if that's where the culprit is. _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to dzirkelb1)


dzirkelb1 Posts: 1321 Joined: 10/5/2004 From: Cedar Rapids, Iowa Status: offline	RE: File Upload .csv file directly to database - 1/20/2005 16:49:32 Not really following that...I changed the path on my .asp page to upload, that didn't do anything. Changed it back to the default of fp gives, nothing. Checked the _private folder, nothing. Is that what you meant? To see if it put it into that folder instead of hte upload folder? Right now, I just want to be able to upload a file...have it be a gif, txt, doc, whatever and have it placed on server just as is...I'll worry about the rest later (baby steps!) (in reply to rdouglass)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: File Upload .csv file directly to database - 1/21/2005 10:33:22 quote: Is that what you meant? To see if it put it into that folder instead of hte upload folder? Yup. That script put the uploaded file in that location (on my server anyways). Is that part of the FP Upload components? I don't use any of 'em so I'm not sure I'll be much more help on this particular script. Have you looked at any other Upload scripts? I have one I use but it's not for the VBScript "faint-of-heart"... Quite powerful and customizeable but not a simple copy-n-paste thing. I'd be more than happy to pass it your way if you're interested. _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to dzirkelb1)


dzirkelb1 Posts: 1321 Joined: 10/5/2004 From: Cedar Rapids, Iowa Status: offline	RE: File Upload .csv file directly to database - 1/21/2005 11:02:27 Any sort of upload script I could get would be appreciated...I just want to be able to upload it for now, and customize it later. I've never been able to upload on this server...be it win2000 or win2003, neither let me. I think it is something with the front page extensions...but, I really have no idea. This web is all fubared with the extensions (installed dreamweaver / coldfusion to play around, it wouldn't uninstall, so its all messed up in there...I'ave managed to hack my way around to make it work for the time being) (in reply to rdouglass)

rdouglass

Posts: 9280
From: Biddeford, ME USA
Status: offline

RE: File Upload .csv file directly to database - 1/21/2005 13:26:34

My first page example is just simply a form that posts to an "uploadprocess.asp" page (which is the second page.) I've put 4 input fields (it'll upload up to 4 files at once) but you can change this. *I don't know what the limit is.* You can name either page anything you want but be sure the form posts to the .asp page where the second page's code is put.

Page 1:

<html>

<head>
<title>Choose Files to Upload</title>
</head>

<body>
    <FORM METHOD="POST" ENCTYPE="multipart/form-data" ACTION="uploadprocess.asp">
    <TABLE BORDER=0>
	<tr><td><b>Select up to 4 photos to upload:</b><br>
		 <INPUT TYPE=FILE SIZE=50 NAME="FILE1"><br>
        <INPUT TYPE=FILE SIZE=50 NAME="FILE2"><br>
        <INPUT TYPE=FILE SIZE=50 NAME="FILE3"><br>
        <INPUT TYPE=FILE SIZE=50 NAME="FILE4"></td></tr>
	<tr><td align="center"><INPUT TYPE=SUBMIT VALUE="Upload Photos!"></td></tr>
	</TABLE>
	</FORM>
</body>

</html>

Page 2

<html>

<head>
<title>Upload Results</title>
</head>

<body>
<%

'NOTE - YOU MUST HAVE VBSCRIPT v5.0 INSTALLED ON YOUR WEB SERVER
'	   FOR THIS LIBRARY TO FUNCTION CORRECTLY. YOU CAN OBTAIN IT
'	   FREE FROM MICROSOFT WHEN YOU INSTALL INTERNET EXPLORER 5.0
'	   OR LATER.

DIM strFileName

Class FileUploader
	Public  Files
	Private mcolFormElem

	Private Sub Class_Initialize()
		Set Files = Server.CreateObject("Scripting.Dictionary")
		Set mcolFormElem = Server.CreateObject("Scripting.Dictionary")
	End Sub
	
	Private Sub Class_Terminate()
		If IsObject(Files) Then
			Files.RemoveAll()
			Set Files = Nothing
		End If
		If IsObject(mcolFormElem) Then
			mcolFormElem.RemoveAll()
			Set mcolFormElem = Nothing
		End If
	End Sub

	Public Property Get Form(sIndex)
		Form = ""
		If mcolFormElem.Exists(LCase(sIndex)) Then Form = mcolFormElem.Item(LCase(sIndex))
	End Property

	Public Default Sub Upload()
		Dim biData, sInputName
		Dim nPosBegin, nPosEnd, nPos, vDataBounds, nDataBoundPos
		Dim nPosFile, nPosBound

		biData = Request.BinaryRead(Request.TotalBytes)
		nPosBegin = 1
		nPosEnd = InstrB(nPosBegin, biData, CByteString(Chr(13)))
		
		If (nPosEnd-nPosBegin) <= 0 Then Exit Sub
		 
		vDataBounds = MidB(biData, nPosBegin, nPosEnd-nPosBegin)
		nDataBoundPos = InstrB(1, biData, vDataBounds)
		
		Do Until nDataBoundPos = InstrB(biData, vDataBounds & CByteString("--"))
			
			nPos = InstrB(nDataBoundPos, biData, CByteString("Content-Disposition"))
			nPos = InstrB(nPos, biData, CByteString("name="))
			nPosBegin = nPos + 6
			nPosEnd = InstrB(nPosBegin, biData, CByteString(Chr(34)))
			sInputName = CWideString(MidB(biData, nPosBegin, nPosEnd-nPosBegin))
			nPosFile = InstrB(nDataBoundPos, biData, CByteString("filename="))
			nPosBound = InstrB(nPosEnd, biData, vDataBounds)
			
			If nPosFile <> 0 And  nPosFile < nPosBound Then
				Dim oUploadFile, sFileName
				Set oUploadFile = New UploadedFile
				
				nPosBegin = nPosFile + 10
				nPosEnd =  InstrB(nPosBegin, biData, CByteString(Chr(34)))
				sFileName = CWideString(MidB(biData, nPosBegin, nPosEnd-nPosBegin))
				oUploadFile.FileName = Right(sFileName, Len(sFileName)-InStrRev(sFileName, "\"))

				nPos = InstrB(nPosEnd, biData, CByteString("Content-Type:"))
				nPosBegin = nPos + 14
				nPosEnd = InstrB(nPosBegin, biData, CByteString(Chr(13)))
				
				oUploadFile.ContentType = CWideString(MidB(biData, nPosBegin, nPosEnd-nPosBegin))
				
				nPosBegin = nPosEnd+4
				nPosEnd = InstrB(nPosBegin, biData, vDataBounds) - 2
				oUploadFile.FileData = MidB(biData, nPosBegin, nPosEnd-nPosBegin)
				
				If oUploadFile.FileSize > 0 Then Files.Add LCase(sInputName), oUploadFile
			Else
				nPos = InstrB(nPos, biData, CByteString(Chr(13)))
				nPosBegin = nPos + 4
				nPosEnd = InstrB(nPosBegin, biData, vDataBounds) - 2
				If Not mcolFormElem.Exists(LCase(sInputName)) Then mcolFormElem.Add LCase(sInputName), CWideString(MidB(biData, nPosBegin, nPosEnd-nPosBegin))
			End If

			nDataBoundPos = InstrB(nDataBoundPos + LenB(vDataBounds), biData, vDataBounds)
		Loop
	End Sub

	Private Function CByteString(sString)
		Dim nIndex
		For nIndex = 1 to Len(sString)
		   CByteString = CByteString & ChrB(AscB(Mid(sString,nIndex,1)))
		Next
	End Function

	Private Function CWideString(bsString)
		Dim nIndex
		CWideString =""
		For nIndex = 1 to LenB(bsString)
		   CWideString = CWideString & Chr(AscB(MidB(bsString,nIndex,1))) 
		Next
	End Function
End Class

Class UploadedFile
	Public ContentType
	Public FileName
	Public FileData
	
	Public Property Get FileSize()
		FileSize = LenB(FileData)
	End Property

	Public Sub SaveToDisk(sPath)
		Dim oFS, oFile
		Dim nIndex, conntemp
	
		If sPath = "" Or FileName = "" Then Exit Sub
		If Mid(sPath, Len(sPath)) <> "\" Then sPath = sPath & "\"
	
		Set oFS = Server.CreateObject("Scripting.FileSystemObject")
		If Not oFS.FolderExists(sPath) Then Exit Sub
		
		Set oFile = oFS.CreateTextFile(sPath  & "/" & FileName, True)
		strFileName = FileName
				
		For nIndex = 1 to LenB(FileData)
		    oFile.Write Chr(AscB(MidB(FileData,nIndex,1)))
		Next

		oFile.Close
	End Sub
	
	Public Sub SaveToDatabase(ByRef oField)
		If LenB(FileData) = 0 Then Exit Sub
		
		If IsObject(oField) Then
			oField.AppendChunk FileData
		End If
	End Sub

End Class

Dim Uploader, File
Set Uploader = New FileUploader
Uploader.Upload()

Response.Write "<b>Thank you for submitting your photos.  They are now being uploaded.</b><br><br>This may take a few minutes..<br>"

DIM x
x = 0

If Uploader.Files.Count = 0 Then
	Response.Write "File(s) not uploaded."
Else
	For Each File In Uploader.Files.Items
		
		x = x + 1
		' Save the file - this is where you'd change the path
		File.SaveToDisk Request.ServerVariables("APPL_PHYSICAL_PATH") & "images\"
	
		Response.Write "File Accepted As: " & strFileName & "<br>"
		Response.Write "Size: " & File.FileSize & " bytes<br>"
		Response.Write "Type: " & File.ContentType & "<br><br>"
	Next
End If

%>  
</body>

</html>

I've configured the sample to send the uploaded files to a subdirectory called images and this is relative to the page.

Good luck!

_____________________________

Don't take you're eye off your final destination.

ASP Checkbox Function Tutorial.

(in reply to dzirkelb1)


dzirkelb1 Posts: 1321 Joined: 10/5/2004 From: Cedar Rapids, Iowa Status: offline	RE: File Upload .csv file directly to database - 1/21/2005 14:22:47 Excellent!! It works great! I'll sypher through the code and change it accordingly to my needs on the site. Thanks a million! Now, can you point me in the right direction to a tutorial for the asp script to automatically update my database with the fields uploaded on a xls file or csv file? (in reply to rdouglass)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: File Upload .csv file directly to database - 1/21/2005 14:54:59 quote: Now, can you point me in the right direction to a tutorial for the asp script to automatically update my database with the fields uploaded on a xls file or csv file? I dunno' 'bout a tutorial but you can setup a DSN to a CSV file and treat it just like an MDB file. Once you setup both DSN's, it should be "elementary". _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to dzirkelb1)


dzirkelb1 Posts: 1321 Joined: 10/5/2004 From: Cedar Rapids, Iowa Status: offline	RE: File Upload .csv file directly to database - 1/24/2005 12:06:32 would it be simply creating the connection to the .csv file, then running an update query on my asp page to the database? How would I have the asp page pull the data from one connection and update it to another connection? (in reply to dzirkelb1)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: File Upload .csv file directly to database - 1/24/2005 13:29:35 quote: How would I have the asp page pull the data from one connection and update it to another connection? Do your fields match up directly or do you have to re-arrange anything? Are there column headers to deal w/ etc. If not (and fields are matched and clean), I'd suggest opening the .csv and dumping it into an array. Then loop thru each item in array UPDATE'ing the DB as you loop. That any help? _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to dzirkelb1)

dzirkelb1

Posts: 1321
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

RE: File Upload .csv file directly to database - 1/24/2005 14:51:49

The column headers have to be defined...currently, what happens is the user clicks a button on their form, and it automatically emails it to me in a .xls file. I then run a update query (link the xls file...save it in same spot everytime), and everything is done.

Is it possible to run the update query from an asp page like I have set up? I should be able to simply copy / paste my code on my access database into an update query that pulls it from the linked xls file...couldn't I?

Spose one of the real speedbumps I have on this is how do I make an asp script run while loading a page? Meaning, I want the file to be uploaded..upon uploading the file, they are taken to an asp page (after file is uploaded). At that time, I want the following sql code to run:

INSERT INTO tblMasterEvaluations ( RouteNumber, EvalDate, EvalCode, StoreID, AutoDate, DayOfWeek, [Time], AutoTime, DayPart, Rep, Period, CostOfProduct, CarryOutDriveThru, D1InsectsAndPests, D1RudeBehavior, D1MainEntreeTemperature, D1EntreeOrdered, D1EntreeTemp, D1OtherChicken, D1TotalPointsDocked, DCustomerDealBreakerComments, C1ParkingLot, C1Landscaping, C1TrashContainers, C1Sidewalks, C1Dumpsters, C1TotalPointsDocked, C2Doors, C2ExteriorLighting, C2DtMenuboard, C2Windows, C2DTSpeaker, C2TotalPointsDocked, C3Stocked, C3Clean, C3Odor, C3TotalPointsDocked, C4Clean, C4Caution, C5Ceiling, C5Pictures, C5Decor, C5Walls, C5LightFixtures, C4andC5TotalPointsDocked, C6Counters, C6Menuboards, C6DisplayCases, C6SelfServiceArea, C6Menus, C6AdvertisingMaterials, C7Tables, C7Booths, C7Seats, C7TrashContainers, C8SuppliesStored, C6andC7andC8TotalPointsDocked, CleanlinessPointsPossible, CTotalPointsEarned, CCleanlinessComments, H1FriendlyGreeting, H1GreetingDTWindow, H2AppreciativeClosing, H3Smile, H3Eyecontact, H3FocusedAttention, H1andH2andH3TotalPointsDocked, H4ProblemLAST, H4LASTExecuted, H4Listen, H4Apologize, H4Satisfy, H4Thank, H4HoldingCabinet, H5ProfessionalManner, HLASTBonus, H4andH5TotalPointsDocked, H6Uniforms, H6WellGroomed, H6NeatAndClean, H6PersonalHygiene, H6EmployeeWhoWaited, H6TotalPointsDocked, H7Upsize, H7UpsizeText, HTotalPointsEarned, HHospitalityComments, A1Brand, A1Other, A1ColdSide, A1Drink, A1Piece, A1HotSide, A1Bread, A1Buffet, A1TotalPointsDocked, A2Sides, A2Packaging, A2ChickenType, A2Napkins, A2ChickenPieces, A2Condiments, A3CorrectAmount, A3CorrectChange, A2andA3TotalPointsDocked, A4ConfirmOrder, A4TotalPointsDocked, ATotalPointsEarned, AAccuracyComments, M1Building, M1DTmenuboard, M1Lights, M1DTSpeaker, M1Signs, M1Grass, M1Advertising, M1ParkingLot, M1Sidewalks, M1DTLane, M1TotalPointsDocked, M2Floor, M2Walls, M2Ceiling, M2Lights, M2Doors, M3Entryway, M3Advertising, M3Menuboards, M3Menus, M4Restrooms, M5Tables, M5MusicVolume, M5Temperature, M5Seats, M5Booths, M2andM3andM4andM5TotalPointsDocked, M6BrixLevel, M6BrixLevelText, M6TypeOfDrink, M6Carbonation, M6TotalPointsDocked, MTotalPointsEarned, MMaintenanceComments, P1FreshMoistTender, P1AcceptableColor, P1WithoutExcessiveShortening, P1BreadedProperly, P1ProperTemperature, P1TotalPointsDocked, P2Temperature, P2Fresh, P2AcceptableAppearance, P2FilledProperly, P2ProperTemperature, P2HotSideItem, P2OtherText, P3Temperature, P3Fresh, P3AcceptableAppearance, P3FilledProperly, P3ProperTemperature, P3ColdSideItem, P3OtherText, P2andP3TotalPointsDocked, P4Temperature, P4Fresh, P4AcceptableAppearance, P4ProperTemperature, P4TotalPointsDocked, PTotalPointsEarned, PProductQualityComments, S1GreetedInTime, S2GreetedInTime, S2HoldTime, S1andS2TotalPointsDocked, S3CustomerService, S3OrderTimeMin, S3OrderTimeSec, S3WindowTimeMin, S3WindowTimeSec, S3TotalTimeMin, S3TotalTimeSec, S3Customers, S3TotalPointsDocked, STotalPointsEarned, SSpeedWithServiceComments, CGreeting, CClosing, TotalPointsEarned, RegularPercentage, DealBreakerPercentage, TotalPointsPossible, ActualScorePercentage )
SELECT tblOutputShopInformation.RouteNumber, tblOutputShopInformation.EvalDate, tblOutputShopInformation.EvalCode, tblOutputShopInformation.StoreID, tblOutputShopInformation.AutoDate, tblOutputShopInformation.DayOfWeek, tblOutputShopInformation.Time, tblOutputShopInformation.AutoTime, tblOutputShopInformation.DayPart, tblOutputShopInformation.Rep, tblOutputShopInformation.Period, tblOutputShopInformation.CostOfProduct, tblOutputShopInformation.CarryOutDriveThru, tblOutputShopInformation.D1InsectsAndPests, tblOutputShopInformation.D1RudeBehavior, tblOutputShopInformation.D1MainEntreeTemperature, tblOutputShopInformation.D1EntreeOrdered, tblOutputShopInformation.D1EntreeTemp, tblOutputShopInformation.D1OtherChicken, tblOutputShopInformation.D1TotalPointsDocked, tblOutputShopInformation.DCustomerDealBreakerComments, tblOutputShopInformation.C1ParkingLot, tblOutputShopInformation.C1Landscaping, tblOutputShopInformation.C1TrashContainers, tblOutputShopInformation.C1Sidewalks, tblOutputShopInformation.C1Dumpsters, tblOutputShopInformation.C1TotalPointsDocked, tblOutputShopInformation.C2Doors, tblOutputShopInformation.C2ExteriorLighting, tblOutputShopInformation.C2DtMenuboard, tblOutputShopInformation.C2Windows, tblOutputShopInformation.C2DTSpeaker, tblOutputShopInformation.C2TotalPointsDocked, tblOutputShopInformation.C3Stocked, tblOutputShopInformation.C3Clean, tblOutputShopInformation.C3Odor, tblOutputShopInformation.C3TotalPointsDocked, tblOutputShopInformation.C4Clean, tblOutputShopInformation.C4Caution, tblOutputShopInformation.C5Ceiling, tblOutputShopInformation.C5Pictures, tblOutputShopInformation.C5Decor, tblOutputShopInformation.C5Walls, tblOutputShopInformation.C5LightFixtures, tblOutputShopInformation.C4andC5TotalPointsDocked, tblOutputShopInformation.C6Counters, tblOutputShopInformation.C6Menuboards, tblOutputShopInformation.C6DisplayCases, tblOutputShopInformation.C6SelfServiceArea, tblOutputShopInformation.C6Menus, tblOutputShopInformation.C6AdvertisingMaterials, tblOutputShopInformation.C7Tables, tblOutputShopInformation.C7Booths, tblOutputShopInformation.C7Seats, tblOutputShopInformation.C7TrashContainers, tblOutputShopInformation.C8SuppliesStored, tblOutputShopInformation.C6andC7andC8TotalPointsDocked, tblOutputShopInformation.CleanlinessPointsPossible, tblOutputShopInformation.CTotalPointsEarned, tblOutputShopInformation.CCleanlinessComments, tblOutputShopInformation.H1FriendlyGreeting, tblOutputShopInformation.H1GreetingDTWindow, tblOutputShopInformation.H2AppreciativeClosing, tblOutputShopInformation.H3Smile, tblOutputShopInformation.H3Eyecontact, tblOutputShopInformation.H3FocusedAttention, tblOutputShopInformation.H1andH2andH3TotalPointsDocked, tblOutputShopInformation.H4ProblemLAST, tblOutputShopInformation.H4LASTExecuted, tblOutputShopInformation.H4Listen, tblOutputShopInformation.H4Apologize, tblOutputShopInformation.H4Satisfy, tblOutputShopInformation.H4Thank, tblOutputShopInformation.H4HoldingCabinet, tblOutputShopInformation.H5ProfessionalManner, tblOutputShopInformation.HLASTBonus, tblOutputShopInformation.H4andH5TotalPointsDocked, tblOutputShopInformation.H6Uniforms, tblOutputShopInformation.H6WellGroomed, tblOutputShopInformation.H6NeatAndClean, tblOutputShopInformation.H6PersonalHygiene, tblOutputShopInformation.H6EmployeeWhoWaited, tblOutputShopInformation.H6TotalPointsDocked, tblOutputShopInformation.H7Upsize, tblOutputShopInformation.H7UpsizeText, tblOutputShopInformation.HTotalPointsEarned, tblOutputShopInformation.HHospitalityComments, tblOutputShopInformation.A1Brand, tblOutputShopInformation.A1Other, tblOutputShopInformation.A1ColdSide, tblOutputShopInformation.A1Drink, tblOutputShopInformation.A1Piece, tblOutputShopInformation.A1HotSide, tblOutputShopInformation.A1Bread, tblOutputShopInformation.A1Buffet, tblOutputShopInformation.A1TotalPointsDocked, tblOutputShopInformation.A2Sides, tblOutputShopInformation.A2Packaging, tblOutputShopInformation.A2ChickenType, tblOutputShopInformation.A2Napkins, tblOutputShopInformation.A2ChickenPieces, tblOutputShopInformation.A2Condiments, tblOutputShopInformation.A3CorrectAmount, tblOutputShopInformation.A3CorrectChange, tblOutputShopInformation.A2andA3TotalPointsDocked, tblOutputShopInformation.A4ConfirmOrder, tblOutputShopInformation.A4TotalPointsDocked, tblOutputShopInformation.ATotalPointsEarned, tblOutputShopInformation.AAccuracyComments, tblOutputShopInformation.M1Building, tblOutputShopInformation.M1DTmenuboard, tblOutputShopInformation.M1Lights, tblOutputShopInformation.M1DTSpeaker, tblOutputShopInformation.M1Signs, tblOutputShopInformation.M1Grass, tblOutputShopInformation.M1Advertising, tblOutputShopInformation.M1ParkingLot, tblOutputShopInformation.M1Sidewalks, tblOutputShopInformation.M1DTLane, tblOutputShopInformation.M1TotalPointsDocked, tblOutputShopInformation.M2Floor, tblOutputShopInformation.M2Walls, tblOutputShopInformation.M2Ceiling, tblOutputShopInformation.M2Lights, tblOutputShopInformation.M2Doors, tblOutputShopInformation.M3Entryway, tblOutputShopInformation.M3Advertising, tblOutputShopInformation.M3Menuboards, tblOutputShopInformation.M3Menus, tblOutputShopInformation.M4Restrooms, tblOutputShopInformation.M5Tables, tblOutputShopInformation.M5MusicVolume, tblOutputShopInformation.M5Temperature, tblOutputShopInformation.M5Seats, tblOutputShopInformation.M5Booths, tblOutputShopInformation.M2andM3andM4andM5TotalPointsDocked, tblOutputShopInformation.M6BrixLevel, tblOutputShopInformation.M6BrixLevelText, tblOutputShopInformation.M6TypeOfDrink, tblOutputShopInformation.M6Carbonation, tblOutputShopInformation.M6TotalPointsDocked, tblOutputShopInformation.MTotalPointsEarned, tblOutputShopInformation.MMaintenanceComments, tblOutputShopInformation.P1FreshMoistTender, tblOutputShopInformation.P1AcceptableColor, tblOutputShopInformation.P1WithoutExcessiveShortening, tblOutputShopInformation.P1BreadedProperly, tblOutputShopInformation.P1ProperTemperature, tblOutputShopInformation.P1TotalPointsDocked, tblOutputShopInformation.P2Temperature, tblOutputShopInformation.P2Fresh, tblOutputShopInformation.P2AcceptableAppearance, tblOutputShopInformation.P2FilledProperly, tblOutputShopInformation.P2ProperTemperature, tblOutputShopInformation.P2HotSideItem, tblOutputShopInformation.P2OtherText, tblOutputShopInformation.P3Temperature, tblOutputShopInformation.P3Fresh, tblOutputShopInformation.P3AcceptableAppearance, tblOutputShopInformation.P3FilledProperly, tblOutputShopInformation.P3ProperTemperature, tblOutputShopInformation.P3ColdSideItem, tblOutputShopInformation.P3OtherText, tblOutputShopInformation.P2andP3TotalPointsDocked, tblOutputShopInformation.P4Temperature, tblOutputShopInformation.P4Fresh, tblOutputShopInformation.P4AcceptableAppearance, tblOutputShopInformation.P4ProperTemperature, tblOutputShopInformation.P4TotalPointsDocked, tblOutputShopInformation.PTotalPointsEarned, tblOutputShopInformation.PProductQualityComments, tblOutputShopInformation.S1GreetedInTime, tblOutputShopInformation.S2GreetedInTime, tblOutputShopInformation.S2HoldTime, tblOutputShopInformation.S1andS2TotalPointsDocked, tblOutputShopInformation.S3CustomerService, tblOutputShopInformation.S3OrderTimeMin, tblOutputShopInformation.S3OrderTimeSec, tblOutputShopInformation.S3WindowTimeMin, tblOutputShopInformation.S3WindowTimeSec, tblOutputShopInformation.S3TotalTimeMin, tblOutputShopInformation.S3TotalTimeSec, tblOutputShopInformation.S3Customers, tblOutputShopInformation.S3TotalPointsDocked, tblOutputShopInformation.STotalPointsEarned, tblOutputShopInformation.SSpeedWithServiceComments, tblOutputShopInformation.CGreeting, tblOutputShopInformation.CClosing, tblOutputShopInformation.TotalPointsEarned, tblOutputShopInformation.RegularPercentage, tblOutputShopInformation.DealBreakerPercentage, tblOutputShopInformation.TotalPointsPossible, tblOutputShopInformation.ActualScorePercentage
FROM tblOutputShopInformation;

AND

[code]
UPDATE [MASTER ROUTE TABLE 1998] INNER JOIN tblMasterEvaluations ON ([MASTER ROUTE TABLE 1998].RT1 = tblMasterEvaluations.RouteNumber) AND ([MASTER ROUTE TABLE 1998].[KFC ID] = tblMasterEvaluations.StoreID) SET tblMasterEvaluations.Period = [MASTER ROUTE TABLE 1998]![PERIOD/MONTH];
[/CODE]

Is there a way to have two sql queries run upon loading one asp page?

(in reply to rdouglass)