Update Statment

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


ADVERTISEMENT

UPDATE Statment

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

IsNull Update Statment

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

Update Statment & Error :: Microsoft JET Database Engine Error '80040e14'

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

IF Then Statment

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

Sql In Statment

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

Asp Sql End Of Statment

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

SQL Statment Variables

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

Problem Regarding Asp /sql LIKE Statment

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

Reuse Of A SQL Statment

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

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 View Related

Database Statment

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

Insert Statment

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

What Is Wrong With My If Statment

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

If Statment For A Field

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

Error With SQL Statment

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

Order By Statment

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

Dynamic Sql Statment?

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

Insert SQL Statment

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

Group By Statment Problem

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

Find And Replace & For Sql Statment

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

Insert Statment For Two Tables

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

Execute SQL Select Statment Error

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

Embed A SELECT CASE Statement In An IF Statment

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

Selecting Multiple Tables Using SELECT Statment Problem

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

How To Tie RegID To Form To Update (batch Update)

Okay there is an unique EventRegID for every registration. When people first register they get pre-registered. Then an admin comes in and confirms or wait list them (based on whatever requirements). My question is how can I tie the EventRegID to a form with multipule ID's so they can batch confirm or wait list the PreReg list? Code:

View Replies View Related

Getting Rid Of $ For An Update

I have this page that displays a dollor amount code:

<td class="tableValue" width="122">Expiring Premium:</td>
<td width="400" align="left">
<input name="Expiring_Premium" type="text" value="<%=formatcurrency(Expiring_Premium,2)%>" class="tableValue" size="27"></td>

it would display $100.00 when i go to insert that value into the database the value i get is $100.00 and i get an error, i need to get rid of the $ sign but not sure how to do it because the number range can be from 1 to a billion dollars.

I have this code for asp that if the value is null it insert a null instead of a blank, else i get an error message in access.

'Expiring_Premium = request.form("Expiring_Premium")
if (request.form("Expiring_Premium")) ="" then Expiring_Premium = "Null" else _
Expiring_Premium = request.form("Expiring_Premium")

Any ideas on how i can strip off the $

View Replies View Related

SQL Update

I'm looking to update a column in a datebase that has null values with N/A and I'm using this:

UPDATE tbl_members
SET branch_no = 'N/A'
WHERE branch_no = NULL

The only reason I'm trying to do this, is because I can't seem to do if statement on a null value.

View Replies View Related

Update Box

This is hard to explain, but I have wanted to know how to do this. Say you have a website, and you have a news box(where you can report all of your news), made of a picture(s), you know like something that says "news" at the top of the 'box', and the sides of the 'box' are a picture. I have wanted to know how to make one of these 'boxes' without having to use the <div> tag, and type as much text in there as i want, and it wouldnt mess up a table or anything, or realign it, because the <div> automatically wraps around the text, fitting perfectly to it. I was wondering if you can 'wrap' around the text without a <div>, but with pictures. Here is an example, this picture called ex.gif.
I know it is a link menu, but what if you wanted to add a couple more links. How would you get the 'box' to automatically resize so that it does not messup the table. I am not even sure if this is capable in ASP, but I am sure somebody knows what I am talking about.

View Replies View Related

Cannot Update

I have a guestbook form that inserts the fields into an
Access Database. The database is residing in the "fpdb"
folder that was created by FrontPage. The ASP page that
writes the data into the databse uses the
"recordset.addnew" method. The code was working fine a
couple of weeks ago, and now all of a sudden the error
message "Cannot update.Database or object is read-only"
pops up. The ASP code or the database was not changed or
modified in any way, neither were the permissions for the
account.

View Replies View Related

Asp Update

I have quite strange problem and hope you guys can help me out or provide me with some tips.
when using a update script:
UPDATE categorys SET main_cat_default= '0', banner= '', b_link= '', external_text= 'Nākotnes parks', name = 'Arzemju muzika' WHERE (id = 115)

Then it messes up field EXTERNAL_TEXT. Instead of Nākotnes parks it saves it as Nakotnes parks.
But! when I open Enterprise manager and type in Nākotnes parks manually then it saves it correctly. So I believe there is something with update command or smthing like that.I changed collation also to Latvian and this did not work.

View Replies View Related

Update My Own App

For laptop users who have an ASP application running on their laptops
- is there a way I can have it check when connected to the network
(via the FSO lastmodifieddate) which files need to be updated
(enhancements, etc.), then shoot the ASP pages that have changed down
to the client?

View Replies View Related

Update Db

I'm using the following code:

rs.addnew
rs("application")=body
rs.update


body is containing a lot of text with vbcrlf in it.This is basically a form that is emailed and I want to save it to a db just in case the emails don't go through.
For some reason the field in the db (access) is only containg the first line until the first vbcrlf

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved