Anyone has done declaring temp table in ASP code, and then populate the temp table, and then inner join with other table and so on? I encounter some sql error it seems indicate asp can't do such operations..
I want to do the following but am not able to do it.I have one query which is:
SQL2 = "SELECT * From totalcloser INNER JOIN zipcode ON totalcloser.zip = zipcode.zip order by totalcloser.zip"
I want to store result of this query in a temp table so that now i can go ahead and compare the results in the temp table with some other table.I know i can do this in Access..but i want to do this by coding (in my program itself) where the query runs and dumps the query results in temp table and then the second query runs and does comparisons and displays the result on screen.Towards the end ,we can flush the contents of the temp table.
Using Option Explicit necessitates that any variable used has to be declared (Dimmed) explicitly but it DOESN'T necessitate that the variable HAS TO BE DECLARED BEFORE the variable is used. For e.g. the code below, which first uses the variable "str" & then declares it, works fine:
I am calling Server.Execute("2.asp") from "1.asp" and expect to have application variables declared in "1.asp" available to the script code in "2.asp", at least this is what the documentations says, but it doesn't work. I am declaring the variables in "1.asp" as public (VBScript). Does anyone have an idea if this is supposed to work?
I am calling function of vb dll from asp. How do i declare the arguments to be passed of string datatype. I tried using Dim but its giving me error. I want to explicitly declare three variable as string.
I need to be able to view a list of files (could be large number!) on a web page and hv been considering using the filesystemobject just to create an array. However their maybe a large number of files and they may need to be sorted.
I am trying to setup an ASP code to write a text file to the client side, not the server side, for the purpose where it will be email attachment.
The following code seems to only work on the server side and was wondering if there as an equivalent out there for the client side since I am trying to avoid potential interruptions on the server side:
Const TemporaryFolder = 2 Dim myFSO, WriteStuff, myAttachment, tfolder Set myFSO = CreateObject("Scripting.FileSystemObject") Set tfolder = myFSO.GetSpecialFolder(TemporaryFolder) if (right(tfolder,1) <> "") then tfolder = tfolder & "" end if myAttachment = tfolder & "test.txt" Set WriteStuff = myFSO.CreateTextFile(myAttachment, True)
how to declare session variables and use it in insert and update sql statements... the scenario is I have:
2 html forms 2 ASP FILES
I am able to trap data from the first form into the acces table..but my second form(which is continuation of first form) has a update query....(ie...it shld update the same record the one inserted from the 1st form )..both the forms work on table in access db
its an annonymus...questionnaite...therefore i am not trapping any user name or login id...but the requirement is the survey made shld be unique....as in no user shld be able to answer the questions twice.
I have data that needs to write to a temp table (there is a lot of data sometimes). Once they are finished, the user approves their input and it goes to a permanent table.
I give them the option of deleting that data by cancelling their request.
The problem I have, just to be on the safe side, what can I do to protect myself if the user closes or perhaps browses away from the page? Is there any sort of an window command whereby I could enable a sort of a kill-like function?
I am trying to write a sub that will delete a spreadsheet file created by the web user. THis is the code I have inserted into the global.asa file, but it is not working.
sub Session_OnEnd 'delete the temporary excel spreadsheet Set objFSO = Server.CreateObject("Scripting.FileSystemObject") objFSO.DeleteFile(Server.mappath("temp/<%=session.sessionid%>.xls")) Set objFSO = Nothing end sub
I have made sure that the temp folder has permissions set for the IUSR_machinename account to be able to delete files. I am running IIS 5 on a windows 2000 server.
I recently installed IIS lockdown, and ever since my ASP pages have been hell. One problem is that now after a user views my ASP page which reads my local Access DB, the temporary file, .ldb, stays in the folder forever!
This temp file is created when a user opens the file, so I checked out the .ldb file and it says the ADMINISTRATOR is opening the file! How can the internet user be using the ADMIN account?! This is not good news! I will share my code for my page; however I have a feeling the code isn't the problem, but a setting is. Code:
I am trying to create a record set using data from two tables. I am using the following code- Dim objRS oracleConnection.CommandText = "SELECT CONTACT.CONT_FNAME, LOGIN.LOGN_USER_EMAIL " &_ "FROM CONTACT INNER JOIN LOGIN ON CONTACT.LOGN_ID= LOGIN.LOGN_ID WHERE CONTACT.CONT_ID LIKE 3" oracleConnection.CommandType = adCmdText Set objRS = oracleConnection.Execute
Set oracleConnection = Nothing
While Not objRS.EOF Response.Write objRS("CONT_FNAME") & " " & objRS("LOGN_USER_EMAIL") objRS.MoveNext Wend
I am getting an error at the line Set objRS = oracleConnection.Execute The error is SQL command not properly ended
I can't seem to get the syntax right for an inner join statement, its based on one main table and two linked tables,
From Employee inner join((Department ON Employee.Department_Code=Department.Department_Cod e) Location ON Employee.Location_Code=Location.Location_Code)
or something to that effect. Employee is the main table and Dept,Location contain all dept/location codes+descriptions.I'm sure its pretty simple just can't get it right.
I have 2 tables I want use join to use their data its working but it will return twice of each record.
this:
strSQL = "SELECT Foods.*,SeFoods.* From Foods INNER JOIN SeFoods ON Foods.food_id = SeFoods.food_id WHERE SeFoods.type = 1 ORDER BY seFoods.sf_id DESC;" .....
I am in the process of creating an ASP application to read a SQL Database. I have imported the database from an Access Database. The Database holds Client details, such as Agent Name, Address, Telephone. etc. in a table called Client Code:
I have been racking my brain with this and I just can't seem to figure it out. Here is what I am trying to do. I have 3 tables named Registration, Events, and Customer.
I want to produce a page that lists all events and the number of attendees and who is attending each event. I assume that the only way to do this is by using an inner join and I am having a hard time grasping it.
My registration page has three fields (customernumber,eventid,eventdate) My events page has five fields (eventid,eventdate,place,description,numberofattendees) and my customer table has three fields that I need to use (firstname,middlename,lastname,customernumber)
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<% Dim conn Dim rs Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection") Set rs = Server.CreateObject("ADODB.Recordset") Set cmd = Server.CreateObject("ADODB.Recordset") conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa" conn.Open
I'm trying to select all the records from a table (usergames) based on the username. I want to then display all the records based on the title of the pin which is my inner join statement. Can I do this or is it easier to just have another sql statement?
sql = "SELECT usergames.pin AS gamecount, searchtable.title FROM usergames INNER JOIN searchtable ON usergames.pin = searchtable.pin WHERE usergames.username = '"&username&"' ORDER BY searchtable.title DESC"
Basically I'm trying to combine an SQL inner join with a delete statement, like:Code:
var cnn = Server.CreateObject('ADODB.Connection'); cnn.Open(Application('cnn')); cnn.Execute('delete * from editors_sections inner join editors on editors_sections.editor_id = editors.editor_id where editor_id='+intEditorId+' and editor.isSectionOne=0 or editor.isSectionTwo=0 or editor.isSectionThree=0'); cnn.Close(); But it gives me the following error:
Incorrect syntax near '*'.
Can this be done, and if so, can anyone see where I'm going wrong (I'm using JScript if that makes any difference?)
i have a few input box for the user to enter. but as u can see that both tables has execno. it's for both tables to connect. that's why i want to check on how i can key in one input box insert into execno in two different tables
I have a table in my DB called members. In that table, I have 2 tables I will be using "username" and "points"
Now, I also have a table called all_matches. This table contains every match report. Over 25,000 of them. I have a "username" field an "outcome" field an "username1" field and "extra_match" field.
What I need to do, is make a query that takes the username from table "members" and find :
using the "username" field in the members table, i need to obtain stats that give me the following. Code:
drop1 - autonumber drop2 - autonumber drop1id in drop2 - number
strsql = "SELECT drop2.drop2id, drop2.drop2, drop2.drop1id" strsql = strsql & " FROM drop2 INNER JOIN drop1 ON drop1.drop1ID = drop2.drop1id where drop2.drop1id = " & drop1id
error msg:
Microsoft OLE DB Provider for ODBC Driverserror '80040e14'[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'drop2.drop1id='.