ASP/Access SQL Statment
Given the following that results from a form which has multiple checkboxes with the same name value, the resulting string when stored into a variable is this - 129,200,323,330 I used the replace function and got this - 129 OR 200 OR 323 OR 330.
I want to somehow use these values (ints) to specify the particular records in an access database and populate a record set.
When I do this, I get nowhere - "Select * From images WHERE id=" & img_ids
Whereas img_ids is the above string...
View Replies
ADVERTISEMENT
i need help with this simple IF then statment.
i want to do this
Code:
IF
response.write objrs ("ok2show") = y
THEN
<img src="http://auditors.demosales.netauditimages<%Response.Write objRS("cnum") %>.bmp" alt="Demonstrator" width="800" height="600"border="7" >
ELSE
<img src="http://auditors.demosales.netauditimagesdefaultimage.jp g"
it's not working it's getting hung up at the response.write objrs part.
View Replies
View Related
I have an sql statment with an in statment for ID . I'm trying to get the CompanyID in ( ) but all i get is just the word companyID with no value . i used response.write request.form("companyID") so i know the value is coming to the other page, this is what i have now.
Response.Write ("& CompanyID & ")
and this is what i see
& CompanyID &
how do i get the value of companyID in ().
View Replies
View Related
what is missing fromt his sql statment its for an asp page that displays a list of results?
rs.Open "SELECT * FROM downtime WHERE downtime.Entrydate = #" & mediumdate&"# AND Supervisors_name<>"none"", conn,1
i get a message saying expected end of statment and it worked up until i added the AND Supervisors_name<>"none" in to the statment?
View Replies
View Related
I am trying to pass a variable from another page to a sql statment. The variable specifies the one of the columns that I want the sql query to return. I also want to display field contents of the column later in my page. I can't seem to get this to work. Can someone give me a hand? Here is my code:
View Replies
View Related
i have this variable:
name="Jones, andrew"
when i update the table it gives an error
here is my update code:
str= "UPDATE tblnames SET Name = '" & name & "' WHERE Id ='" & getid & "'"
can someone tell me whats wrong with it because the name variable has a comma in it.
View Replies
View Related
I'm not an hardcore programmer but i try to do a simple search in my asp pages.
I've a database .
I've try this code:
rs.Open "SELECT titre , sstitre , carac , gastro , historique , cepage FROM catalogue WHERE titre , sstitre , carac , gastro , historique , cepage LIKE '"&Request.Form("Sstring")&"'" , conn
But i've that's generate an error in my explorer...
View Replies
View Related
I have a sql statement that pulls up a certain amount of records according to a requirement. Let's say that 20 records show up. I want to get to the 5th one. Well now I know that I can use the move() function to enable that, but it is the same page.
The page executes the sql statement and by default shows the last record in the query. Now when I ask for the 5th record the page is reloaded, the sql statement exectures AGAIN and the 5th record shows up. Is there way to ask for the 5th record without having to re-executing the SQL statement?
View Replies
View Related
I've got the following statment in my website:
<%
if session("memberId") = objrs.fields("memberId") then
%>Some Id<%
else
%>Different Id<%
end if
%>
The problem is, if boths are the some number it still displaing Different Id.
Is there anyone can tell me what am I doing wrong?
View Replies
View Related
Now here is my insert statment and it is giving me this error message:
Insert Record
'strSQL2 = "INSERT INTO tblCONTENT_Links (LinkID, ContentOwner_UserGroupID, ContentGrouping, LinkHeaderOrder, LinkDescription, LinkName, LinkURL, LinkHeader, LinkHeaderCategory, LinkRefSite, Active, Archive, UpdatedDate, UpdatedBy, PasswordProtected, CommonLibrary) values ( 141, 7,'public', " & Category & " ,'" & DocumentName & "','" & DocumentTitle & "', '" & Document & "', 0 , 28 , 'www.skyclimber.com', -1 , 0 , #8/27/2004# , 0 , 0, -1)"
IE error:
Syntax error in INSERT INTO statement.
View Replies
View Related
I'm using the following code on my website:
if left(session("lastPage"), 5) <> "admin" then
session("return") = session("lastPage")
else
session("return") = ""
end if
My problem is even the "left(session("lastPage"), 5) is equal to "admin" it still not equal the variable session("return") to "". Can anyone please tell me why or what Im doing wrong?
View Replies
View Related
how i would go about using an if statment against a field in a database.
i.e
if id = "fieldname"
then
do this
else
do this
end if
I am still learning asp and would be very greatful if someone could help me.
View Replies
View Related
What is wrong with this statment:
SQL = "SELECT tblEmployee.*, tblDepts.deptdesc, tblEmployee.Inactive FROM tblEmployee INNER JOIN tblDepts ON tblEmployee.DeptID = tblDepts.deptid WHERE " & request.form("txtSearchIn") & " LIKE '%%" & request.form("txtSearch") & "%%'" & " ORDER BY LastName, FirstName"
I am getting a error:
Syntax error (missing operator) in query expression 'LIKE '%%%%''.
View Replies
View Related
I am hoping that some one can tell me how to add an ORDER BY statement to the following:
<% set rst = createobject("adodb.recordset")
set rst = conn.execute("select RegClassID, StartDateTime, EndDateTime, Description, Location, SpecialNotes from CAL_EVENTS_REG_CLASSES where RegistrationID = "&RegistrationID)
if not rst.eof then %>
The recordset returns fine, execpt I need to be able to order it ASC
View Replies
View Related
im trying to write a sql statment that will insert a variable number of fields into a database the code below is what i want to do but i know this wont work anyone any ideas?
or even if this can be done?
sSQL = "INSERT INTO sometable("&For Each field In Request.Form ; "&Field&"," next ; &")values"('" "&For Each field In Request.Form ; "&Request.Form(Field) &"','" next ; &""')"
View Replies
View Related
I'm using the following code in my website that is not working:
Dim objRS
strSQL = "UPDATE tblasp SET view = " & session("NumberOfViewer") & " WHERE id = " & session("aspId") & " "
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open strSQL, objConn,2,2
Is there someone please could tell me what am I doing wrong?
View Replies
View Related
i was using INSERT INTO statment for insrting data to a mdb database file
eg
but now it is not working
there is an error
"Operation must use an updateable query. "
View Replies
View Related
i want to display the number of people logged on at each location... when someone logges in they get a type=1... that works great but when i try to group by the NasName thats the location name.. Code:
View Replies
View Related
I need to know how to do this IsNull update statment in ASP:
"UPDATE tblUsers SET username='" & lcUName & "', hash= IIf(IsNull([lcHash]),"",[lcNewHash]), inactive=" & llAct & ", locked=" & llLock & ", isadmin=" & llAdmin & ", attempts=" & lnAttempt & ", lastlogin=" & ldLastLogin & ", onlyreadaccess=" & llOnlyRead & " WHERE UserID = " & lnSetID
View Replies
View Related
i have a qs variable that has a & and i need to query the db, what do i replace the & with to query my data correctly?
View Replies
View Related
ContentID is primary_key ID and it is automaticlly created upon this insert, but want to also insert that content id in table Category column ContentId. Code:
View Replies
View Related
I'm getting this useful error '80040e14' when trying to run a select statement in an ASP page. The connection to SQL Server 2000 is ok. The variables in the Select statement, 'area' or 'areaid' are passed through form the previous page ok.The code is below... Any ideas? Is it something obviously dense on my part?? Code:
View Replies
View Related
i have a select case statement that checks for a couple of options e.g.
<%select case aParameters(0)
case 0 %>
.. some code
<%case 2 %>
however i would like to test for a certain condition within the select cases statment. To see if a session variable exists before implementing some code:
View Replies
View Related
I am Trying to use the SQL SELECT Statment to open records from multiple tables into one recordset.
I know the basic syntax of the Select statment but I wanted to know if its possible to recive the table name from the feild or the record that I am readinf from the recordset in any given moment.
To make things more clear, my example:
-Open a connection
SQL = "SELECT * FROM TABLE1,TABLE2 WHERE TABLE1.UserID=" & uid & " And TABLE2.UserID=" & uid
rs.open sql,conn,3,3
while not rs.EOF
-read from record
rs.movenext
wend
rs.close
conn.close
now, in the part that I read from the record, is their any way I can know if that record is from table1 or table2?
View Replies
View Related
I keep getting an error when I try to run this update statment: [CODE]
INSERT INTO MYPosts ( IEname, country, server_name, LANIPAddy, license_ver, wrkstn1, wrkstn2, wrkstn3, wrkstn4, wrkstn5, notes, status, rdse, esc, eso, parent, , timezone, ) VALUES ( '" & lcIEname & "', '" & lcCountry & "', '" & lcServerName & "', '" & lcLicenseVer & "', '" & lcwrkstn1 & "', '" & lcwrkstn2 & "', '" & lcwrkstn3 & "', '" & lcwrkstn4 & "', '" & lcwrkstn5 & "', '" & lcNotes & "', " & lcStatus & ", " & lnRDSE & ", " & lcESC & ", " & lcESO & ", " & lcParent & ", " & lcTimeZone & ")"
I get the following error:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression
View Replies
View Related
I have a Development server that is running Win2k, IIS 5.0, and ASP enabled. I am trying to gain access to an Access 2000 DB located on a file server within my domain. I'm pretty sure I have all the correct permissions set, but I am having problems when trying to access the DB.
The error is similar to:
The Microsoft Jet Database engine cannot open the file '******'. It is already opened exclusively by another user, or you need permission to view its data.
I'm looking for ways to fix this... Microsoft suggests turning off the ability for IIS to sync passwords. Unfortunately, this is not a viable solution for me.
Is it possible to create a new virtual server that is a share to my file server? Put my ASP and MDB file in there and have it work? Anyone have any other ideas?
View Replies
View Related
I'm working on a site that inserts records into an Access database and Access assigns an auto-incrementing id for the record. How can I quickly figure out what id that was just created? I seem to remember there being a function for this....
View Replies
View Related
I want to move my only window shosted client to linux. The site they have access a Microsoft Access database with the below code but i can't get it to work under Linux.
<code>Dim MM_connPang_STRING
'MM_connPang_STRING = "dsn=pangDSN"
MM_connPang_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:clientdatabasepangDB.mdb"</code>
View Replies
View Related
I'm trying to access a table in a MS Access database using ASP but the name of the table is causing me some trouble. The problem is the table name has a space in it eg, "My Table".
If i try and access it using a query "SELECT * FROM My News", it says i cant find table "My". If i remove the space from the name (to MyTable) it works fine. But the trouble is its a customers database and i cant easily rename it because its linked to other tables and db's.
How can i access a table with a space in its name? I've tried "SELECT * FROM My_News" but that doesnt work either.
View Replies
View Related
I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ".
The 'F:' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.
View Replies
View Related
I'm looking to make an online multiplayer game which will utilize Access Database... basically I require thousands of people writing and reading from the same database... I was wondering if this is possible for that... or is mdb file restricted to 1 person at a time...
If it is limited what would you suggest as the best way to control an interactive online environment? .txt files possibly?
View Replies
View Related
What is this all about? Generally I run against SQL Server but now I have to use access. The query I want to run is a simple double join
SELECT tblArtists.*,tblGenres.name AS genreName,tblPages.pageId
FROM (tblArtists
INNER JOIN tblGenres ON tblArtists.genreId = tblGenres.genreId)
LEFT JOIN tblPages ON tblArtists.artistId = tblPages.artistId
ORDER BY surName ASC, firstName ASC
Now If I run this question in access against the database it accurateley returns two posts. BUT When I paste the same query into an asp document and runs it with a fileDSN against the same database it returns nothing!? Is this some kind of joke from Microsoft?
View Replies
View Related
I have an Access DB which contains couple of link tables. All these tables are from different databases. So each one has it's own database password. Since there is no way to save the password during the DSN creation. Then you need to manually type in the password each first time when open the table.
This causes the problem in ASP code during run a query. Since the table cannot be accessed due to the password protection. Is there any statement than can open a table and meanwhile pass the password in? Does anyone experienced with the similar situation?
View Replies
View Related
