Howdy Y'all
I hate to do this but I need to ask a question and review a painfully
simple subject. I will admit that I'm having trouble because I
haven't done any programming in a few years. I could go on and on
about why but that's neither "here nor there." But
nonetheless, the
weaknesses that I had before are once again rising to the surface so
I'm embarrassed to say that "I need some help."
What I'm trying to do is simple. I'm once again reviewing and
implementing SQL functions into my code so that I can manipulate data
in an Access Database. Of course having some experience, I know the
best thing to do is to approach this conceptually so I'm just
trying
to derive the simplest of samples or examples (since my old ones are
destroyed) so that I can just adapt them and then develop them into as
large of a statement as I want later on. So, what I have done is made
a table in my /DB directory in my web server and then named it
TestDB.mdb. Then I have made three tables because I'm working
with
three functions (SELECT, UPDATE, INSERT).
Working with the select statement didn't cause a problem but I
have
had all types of difficulty with UPDATE and I've found it
frustrating
because I've written statements like that before. So, if none of
you
mind, I would like to review some of the rules when using SQL UPDATE
statements.
First, here is my code (I'm doing a DNS-Less connect with an
execute):
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "E:\e1\ScratchPad\DB\TestDB.mdb"
set rs=Server.CreateObject("ADODB.Recordset")
SQL = "UPDATE TBL2 Set TblBody='Update Test' WHERE ID='1'"
Set RS = Conn.Execute(SQL)
rs.Close
conn.close
%>
So, here is what I remember in review. The syntax is:
UPDATE table SET FIELD_TOBE_CHANGED='Text' WERE
FIELD_REFERENCED='Idendifyer'
So here is what I remember of the rules:
1. SQL commands are not case sensitive:
Select vs SELECT
2. As long as there isn't a new line, SQL isn't white space
sensitive:
Field='text' vs Field = `Text'
3. Variables that are given must be enclosed in single quotes `'
4. Changing more then one field requires separation by a comma
5. Fields cannot be a keyword (boy I would kill for a list of
these!!!!)
6. Conditions can be set on the identifier (and, or and not).
7. I know about using double quotes and ampersand signs for variables
and form object
..but I don't want to do that much typing
right now.
Now all that aside, the simple example that I have been giving above
has been "puked like a two year old brownie" every
time
.is there
something that I'm forgetting? Basically most of the time
I'm getting
a syntax error or Data type mismatch and frankly I don't get it.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
