Re: if statement comparing variable
From: Mike Haas (mhaas_at_mail.lr.k12.nj.us)
Date: 02/29/04
- Next message: Mary I.: "Database Starting Point"
- Previous message: aa: "Re: upload an executable file disguised as gif or jpg"
- In reply to: Bob Barrows: "Re: if statement comparing variable"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 29 Feb 2004 08:38:38 -0800
> if rsArticles("tbl_articles.section_id") = "1" then
>This line is not giving you an error?? Do you have On Error Resume Next
in
>your code? Comment it out. You will see an error generated by this
line. You
>cannot refer to a recordset field using the table name like this.
no errors, i was just missing CInt to make the if work for me. all of
the sql
code is called from a sql.asp file, uses alot of joins. In a few areas
the code
uses the table name. I put this if statement in the results of the
original
designers code so that i could restrict which section to show.
Sorry for the confusion I caused you with my inefficient code (passing
the
section I wanted to view from a form and then restricting the display on
that
page to just the desired results). Yes, i could have rewrote the stored
sql
statement to select my desired section or created a new stored sql to do
so.
But since I already ne the very little amount of data contained in the
table and
how often this page would actually be used, I just wanted a quick fix.
I think the person who posted the fix to my delima figured out I was
trying to
put a work around in place to make something work, that's why you posted
a
one line fix to my problem.
--------------------------------------
Michael Haas
WAN & Telecom Tech
Lenape Regional High School District
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
- Next message: Mary I.: "Database Starting Point"
- Previous message: aa: "Re: upload an executable file disguised as gif or jpg"
- In reply to: Bob Barrows: "Re: if statement comparing variable"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
