Proper Syntax

is this the proper syntax for an update statement in Access 2000:

Update [table] set table.column1=1, table.column2=2
where ((ID)=1)

View Replies


ADVERTISEMENT

Proper Usage

What is the proper way of using html in asp

Response .write "<td>"& variable & "</td>"

or

<td><% Response.write (variable)%></td>

What difference does it make?I am building a table whose number of rows keep changing
When i use the second method the space above my table keeps increasing.I just want to know which method is better..I had posted a similiar question....I'm still trying to figure out.

View Replies View Related

Proper Way To Logout?

I am currently using a script to logout which contains this code only...

<%
Session.Abandon ()
Response.Redirect ("main.asp")
%>

Please could you tell me if there is a way to actually delete the session from the users browser history? The above code works ok, as long as the browser is closed first, deleting the cookie info.

View Replies View Related

Proper FTP Manager Required

I've created a web site system that a number of users use on their sites,
but I manage each individual site/system on my ISP's server.

Creating updates to this system was fine when I only had a few users, but
now its starting to become hard work uploading the required files to each
site (I use CuteFTP) so I wondered if you knew of an FTP app that would
allow me to automate the process.

I basically want to put a file or files in a local folder and then instruct
the app to auto-upload these files to the same places, but on each site. If
required, I can create the folder structure locally so that the app goes
through a set of folders locally and uploads them to the same places on the
sites.

Do you know of an app that can automate the process of uploading the same
files to certain directories across multiple FTP sites?

View Replies View Related

Proper Case Function

I saw the Proper Case function a long time ago and I can't seem to find it by search. Does anyone have the code?

View Replies View Related

How To Convert Days To Proper Format

i use to get the difference between two dates i.e user's signup date and todays date in order to check that user has atleast logged into his/her account within 45 days otherwise i ll delete the account.

i calculate the difference by using datediff function for days upon current date and account created date. it displays the results in no of days say 32 days or 134 days

but i want to have it properly formatted in format like:

in case of 32 days
1 month and 2 days
that i can do by myself

but how to handle following situations:

if there are 30 days in month
if there are 31 days in month
if there are 28 days in month
if there are 29 days in month

how to handle these situations.

View Replies View Related

Formatting Data Results...proper Case

I have a asp page pulling results from an Access DB. I have no control of
the data input to the db. All the information is entered in Upper case. It
contains fields like address, city, etc..

DB data:
AddressColumn: 123 BILL AVENUE format to 123 Bill Avenue

Is there a way to format the data on the webpage in proper case with a
fucntion or routine? I am not a programmer by trade but can follow logic.

View Replies View Related

Need Info On Using Proper Data Type For Words With Apostrophe

What is the correct data type to use if the phrase I'm saving to my table contains an apostrophe such as in the phrase "yesterda's news". I've tried "text" data type, I've tried "varchar" and "char". They all give me bugs when I save to the database and if I remove the apostrophe from the phrase, then it saves correctly with any data type.

View Replies View Related

Where NOT IN ( ) Syntax

Can I use this syntax

Where NOT IN (".....)

in a situation I don't want to select items in the list.

If not what other ways can do that.

View Replies View Related

Syntax Help

I'm just trying to display a user's FIRST name and the FIRST INITIAL of the last name on my asp web page.
This works to displays their "firstName" and "lastName":


Code:
<%=oUsers("firstName")%>&nbsp;<%=oUsers("lastName")%>
But I get a variety of vbscript or asp syntax errors when I try to trim the "lastName" using something like


Code:
<%=oUsers("firstName")%>&nbsp;<%=oUsers(replace(left("lastName",1))%>
How do get this simple task done?

(If it makes any difference, the whole thing is inside html <td></td> tags as part of a table)

View Replies View Related

SQL Syntax

I can't see to find where the syntax is wrong because I can do the query just fine in access but my asp page gets this error

Microsoft JET Database Engine error '80040e14'

Syntax error in INSERT INTO statement.

Here is what the insert looks like when I print it out in the page

INSERT INTO tblusers (username,password,[Timestamp],email) VALUES('testuser', 'c4ca4238a0b923820dcc509a6f75849b', '10/16/2004', 'me@home.com')

Here is the code:

View Replies View Related

SQL Syntax

I am trying to query a database for 2 conditions but I can't get the query to work.
Can anybody see a problem with this line of code?Code:

strQuery="SELECT Count(*) AS intTotal FROM tbl_artists WHERE fld_artist_name = '" & strReqname & "'" "AND fld_user_id ='"& strUsername & "'",objConn,,,adCMDText

objRS.Open strQuery,objConn,,,adCMDText

numRecords = objRS("intTotal")

View Replies View Related

SQL Syntax

I have a textarea and have named it category_One.

I have sent the data in this form on using the POST method

contents_category_One = Request.Form("category_One")

I have then used the following sql statement

sql = "INSERT INTO tableName(Category_One) VALUES ('"& contents_category_One &"');"

If someone inserts ' in the text box, this value is causing a syntax error in the sql statement.

View Replies View Related

SQL Syntax

The WHERE part of my select needs to pull out where the date column is empty. If there isn't a date, it shows NULL in the database (SQL7)."WHERE eligibility_dt <> NULL" doesn't work. what am i forgetting?

View Replies View Related

ASP Syntax

I need help with ASP. when i post data to the database, do the records in my form need to be in the same amount as the database records?

View Replies View Related

Sql Syntax

Would anyone have some syntax for a query (SQL2000) that would return results for records that are over 24 hours old (date field is smallDateTime)?

View Replies View Related

Syntax,JS

I believed that there is a wrong syntax on the window.open line...Can anyone spot it ?
Code:
strLocation = "Sch_As_FollowAct.asp?drvid=" & request("drv") & "&u=" & uday(0)

response.write "<script>" & vbCrLf
response.write "window.open('" & strLocation & "' & ",menubar=1,resizable=1,width=350,height=250");" & vbCrLf
response.write "</script>"

View Replies View Related

If Then Syntax

i am having some trouble rembering the correct syntax for a If Then Statement here is my code.

<% If Request.QueryString("access") = "false" Then %>
<tr>
<td colspan="2" bgcolor="#FFFFFF" class="mediumRed">The User
ID and Password combination has failed.<br> <br>
Please try again.</td>
</tr>
<% Else If rsGettblCouples.Fields.Item("StopDate") = "1/1/1900" Then %>
<tr>
<td colspan="2" bgcolor="FFFFFF" class="mediumRed"> The User has already<br>
completed the online scoring.<br>Please Contact your facilitator.</td>
</tr>
<% End If %>
<% End If %>

View Replies View Related

Syntax 101

Can someone direct me a set of rules for building strings in ASP? I'm always getting stuck on when to use a quote (") or apostrophe{'} or both. This simple string is giving me fits...

Response.Redirect("test3.asp?orderno='" &
(rsProducts.Fields.Item("OrderNo").Value) & "')"

I can't seem to get the right combination.

View Replies View Related

Dsn Less Syntax

What's wrong with the syntax in this connection string? It's a DSN less connection to an Access DB.

<%
Set Conn = Server.CreateObject("ADODB.Connection")
MM_GenKAccess_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
Server.MapPath("authors.mdb") & ";" & _
Jet OLEDB:Database Password=48912; & _
Jet OLEDB:System database=" & Server.MapPath("system.mdw") & ";" & _
conn.open MM_GenKAccess_STRING
%>

View Replies View Related

Do While Not - Syntax

I want to update multiple rows in an SQL table. Presently, it's populating all rows with the same data based on the first row. It's not looping through all records one at a time.
Is this the correct syntax.

<%
rsOD 'recordset up here
%>

<%
Dim DataConn1
Set DataConn1 = Server.CreateObject("ADODB.Connection")
DataConn1.Open MMSTRING
Do While Not rsOD.EOF
'SQL UPDATE statement here
DataConn1.Execute(SQL)
rsOD.MoveNext
Loop
%>

View Replies View Related

Syntax Of URL

Can any one tell me why this snippet is not showing the a href correctly. Sorry, not sure of ASP syntax as yet...

Response.Write Highlight(myTextwo, "", "", "<a href=""url.com=" & CInt(rsrch("tablcolumn")) & """ target=""_blank"">" & rsrch("othercolumn")) & "</a>"

View Replies View Related

Syntax ASP

Another slight problem with syntax of asp, basically I'm pulling an image file name from my database (image1.jpg) and using the images directory on my web server to display my picture, make sense? Code:

View Replies View Related

Syntax Err,JS

I believed that there is a wrong syntax on the window.open line. Can anyone spot it?

strLocation = "Sch_As_FollowAct.asp?drvid=" & request("drv") & "&u=" & uday(0)

response.write "<script>" & vbCrLf
response.write "window.open('" & strLocation & "' & ",menubar=1,resizable=1,width=350,height=250");" & vbCrLf
response.write "</script>"

View Replies View Related

SQL Syntax

If you haven't noticed I am novice and have just started getting back into the world of ASP. First question can I have two And statements, and second the syntax is wrong with my And statements where can i find a reference to see the proper syntax. Code:

mySQL= "SELECT tbl_Sch.Schedule_id, tbl_Sch.TeamId, tbl_Sch.GameDate, tbl_Sch.GameDescription, tbl_Sch.GameTime, tbl_Sch.GameStatus, tbl_Sch.Season, tbl_team.TeamID, tbl_team.Team_Name, tbl_team.Enabled" _
& " FROM tbl_team, tbl_Sch " _
& " where tbl_team.TeamID = tbl_Sch.TeamId" _
& " And tbl_team.Enabled = '"-1"' " _
& " And tbl_Sch.Season = '"2005-FAL"' ;"

View Replies View Related

Update Syntax

I am trying to update my database with hidden fields that are being requested from a previous page such as:

hfSectionOneScore
hfSectionTwoScore
hfSectionThreeScore

I'm not familiar how to write an UPDATE statement, and would like some help. I'm thinking that it is something like this:

UPDATE Director_Appraisals SET

Section1Score = request("hfSectionOneScore"),
Section2Score = request("hfSectionTwoScore"),
Section3Score = request("hfSectionThreeScore"),

WHERE UserID = request("hfUserID");

Of course there are more columns, but am I on the right track? Does the syntax look correct?

View Replies View Related

SQL Syntax Near The = Sign

I am concatenating the firstname and lastname in the SQL query in the ASP page. I get the error:

Syntax error near =

This query works in Access.

<input type=hidden value="<%=strNetworkID%>" name=""networkid">

"SELECT" EmpID, FirstName + ' ' + LastName as Employee_Name, NetworkID FROM Employee WHERE networkID = " & Request.form("networkid")

View Replies View Related

Query Syntax In My Sql

I just decided to leave Mssql and start using Mysql. I am having some problems with my queries; is there anyone here who has a knowledge of query syntax in Mysql?

View Replies View Related

Incorrect Syntax Near ')'.

StrSql = "SELECT * FROM [" & Screen & "] WHERE (CPN="&(COORDID)&") AND (CNUM="&(CNUMQS)&")

View Replies View Related

Syntax Error

I'm using an Access database file for this. I can issue SELECT statements on the database, but for some reason it says I have a syntax error with my UPDATE statement.
Code:

openAccessRS("UPDATE students SET password='test' WHERE sid='123456789' AND email='google@yahoo.com'")

Don't worry about the openAccessRS function. It just takes the query and issues the ADO.RecordSet.Open function. I have the students table filled with the correct information. I do have an entry where the student id (sid) is 123456789 and email = google@yahoo.com.This query worked fine in a MySQL DB.

View Replies View Related

Syntax Error

Microsoft JET Database Engineerror '80040e07'Syntax error in date in query expression 'fldUserName= 'muratsa' AND fldTimeIn=#01.09.2003 16:52:20# AND fldOffline=0'. /Vestelweb/logout.asp, line 7

I am using the Now() function to get the date
in db the format is general date and in regional settings of the server the seperator is "."

View Replies View Related

Correct Syntax

My asp syntax is very lacking, it seems the double quotes that have been
done by me are not what asp is looking for. Anyone that could correct my
faulty thinking would be thanked.

View Replies View Related

SQL Syntax Error

Could anyone tell me what is wrong with this SQL statement:

sqlInsertShow = "INSERT INTO tblShowings (date) VALUES (#12/12/2004#)"

Im trying to inder this into an MS Access database, and the field name DATE, is set to date/time value.The error message I get is:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/fyp/backend/add_show_03.asp, line 41

Ive been scratching my head over this for AGES now! It just will not work.

View Replies View Related







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