Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Noob help- SQL syntax
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Noob help- SQL syntax

 Post Reply Post Reply
Author
oneminuteguy View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 18 October 2002
Location: Denmark
Status: Offline
Points: 100
Post Options Post Options   Thanks (0) Thanks(0)   Quote oneminuteguy Quote  Post ReplyReply Direct Link To This Post Topic: Noob help- SQL syntax
    Posted: 29 May 2004 at 10:05am

I have a request.form. Users view their information by typing their phone number. Works fine, but I need to know how to create a user friendly error message when the phone field is empty. Here's my code:

<%
  'variables
  dim Conn, Connstring, Sql_Get, TheArray, Recordset
 
  'database connection
  Set Conn = Server.CreateObject("ADODB.Connection")
  Conn.Provider = provider
  Conn.ConnectionString = dbasepath
  Conn.Open

' Sql statement
  Sql_Get="SELECT * FROM tblFestival WHERE Phone='" & Request.Form("Phone") & "'"

Set Recordset = Conn.Execute(Sql_Get)

' get the recordset data in memory using getrows()
  TheArray = RecordSet.Getrows

' Cleanup objects
  Conn.Close
  Set Conn = Nothing
  Set RecordSet = Nothing
   %>

Any help much appreciated. Sorry if this is a noob-q, but I'm kinda stuck.

Thanks,
OMG

Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 29 May 2004 at 10:13am
Just add,
If TheArray = Nothing THEN
 'Either a javascript box or a response.write popping the message
END IF
Back to Top
oneminuteguy View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 18 October 2002
Location: Denmark
Status: Offline
Points: 100
Post Options Post Options   Thanks (0) Thanks(0)   Quote oneminuteguy Quote  Post ReplyReply Direct Link To This Post Posted: 29 May 2004 at 10:32am
Hi and thx for answering,

Exactly where should I put this?

Back to Top
Mart View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 November 2002
Status: Offline
Points: 2304
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mart Quote  Post ReplyReply Direct Link To This Post Posted: 29 May 2004 at 2:16pm
YOu could put it at the bottom
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.