The reason why I am not checking if the value exists
because the value really exists. The error happens
intermittently... wierd. :-(
--- Mark E <[EMAIL PROTECTED]> wrote:
> Erwin,
>
> What code are you using to check the value in the
> querystring?
>
> If it's a numeric value, try:
>
> If IsNumeric(Request.Querystring("YourID")) Then
> 'ID is good. Proceed.
> Else
> 'ID missing! Alert the user with a message.
> End If
>
> Just be sure to trap or catch a numeric value that
> does not exist. I could still mess with the
> querystring by changing it to a number that does not
> yet exist in your database.
>
> Mark
>
> Erwin Rommel Felix 2000A
> <[EMAIL PROTECTED]> wrote:
> User: hanamichi.songoku Date/Time: 4/4/2005 3:58:51
> AM
> Application: myApplication Server:
> myApplication.audacious.com HTTPS: on Browser:
> Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;
> .NET CLR 1.0.37005; .NET CLR 1.1.4312122) Category:
> TrackingID=6454A21C6876E30221 2540.SD_ICBAM
> V1.0.90.CDatabaseSvc.ExecuteQueryEx.0> Error Number:
> -2147217900 Description: Line 1: Incorrect syntax
> near
> '='. (170) Line 1: Incorrect syntax near '='.
> vsSQLStatement=SELECT name, source_link FROM
> my_Application_tbl WHERE source_ID = File:
> /UnlimitedSources.asp Line: 72
>
> I'm receiving the above error mysteriously. By the
> looks of it, it seems that the value next to the
> equal
> sign is blank. In my ASP, there should be a value
> being passed from the query string.
>
> Dim strSourceID
> strSourceID=Request.QueryString("sourceID")
>
> I think the error above occurs because there is no
> value retrieved from the query string. But I checked
> the query string to be just fine. Is this possible?
> I
> really think its weird. Is QueryString really safe
> in
> such a manner that it will return a value no matter
> what? Or there are times that it returns no values.
> What are such instances?
>
> Erwin Rommel Y. Felix
> Tel. 8410111 loc. 11430
> Mobile 09185980706
>
> "Never outshine the Master Chicker"
>
>
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Make Yahoo! your home page
> http://www.yahoo.com/r/hs
>
>
> ---------------------------------
> 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 the
> Yahoo! Terms of Service.
>
>
>
> [Non-text portions of this message have been
> removed]
>
>
Erwin Rommel Y. Felix
Tel. 8410111 loc. 11430
Mobile 09185980706
"Never outshine the Master Chicker"
__________________________________
Yahoo! Messenger
Show us what our next emoticon should look like. Join the fun.
http://www.advision.webevents.yahoo.com/emoticontest
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/
