Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Microsoft VBScript compilation  error
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum LockedMicrosoft VBScript compilation error

 Post Reply Post Reply Page  <123
Author
patience View Drop Down
Newbie
Newbie
Avatar

Joined: 18 January 2010
Location: uk
Status: Offline
Points: 3
Direct Link To This Post Posted: 20 January 2010 at 1:31pm
Hello

  Most of the time, the line of code in error is the SQL statement since SELECT statements can be very large. You can use one of the following to work around this problem:
  • If the SELECT goes against a single table, remove the "table." prefix in front of each column.
  • Create a variable to hold the SELECT statement, and concatenate the SQL over several lines as follows:
  • MySQL = "SELECT table.col1, table.col2 "
    MySQL = MySQL & "FROM table "
    MySQL = MySQL & "Where x = 3"
  • If the number of columns are relatively small, but the SELECT statement selects from multiple tables, create a view. Select against the view, omitting the "table." prefix in front of the columns.
  • For non-SQL lines of code that are too large.
have a good day.
Back to Top
charchilp View Drop Down
Newbie
Newbie


Joined: 07 April 2010
Status: Offline
Points: 2
Direct Link To This Post Posted: 07 April 2010 at 6:58pm
what is it..???



Back to Top
lidwish View Drop Down
Newbie
Newbie
Avatar

Joined: 06 March 2011
Location: Hawaii
Status: Offline
Points: 2
Direct Link To This Post Posted: 06 March 2011 at 9:01am
What do I have to do to get rid of captcha - my pages don't load anymore, (a business site) because of this error

Microsoft VBScript compilation error '800a0411'

Name redefined

/2009NewTest/CAPTCHA/CAPTCHA_configuration.asp, line 48

Dim blnCAPTCHAabout

everytime I try to edit the header.htm this keeps reposting and reposting about six different times.

any straight up help?

Back to Top
123Simples View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
Direct Link To This Post Posted: 06 March 2011 at 10:07am
I've found your site. As a temporary suggestion, you could try editing the CATCHA_configuration.asp line 48, and put a remark in front of that line like so:

'Initialise variables
'Dim blnCAPTCHAabout

The ' remark line will in theory prevent the line from causing the issue, until you can see what is actually wrong. Alternatively for assistance then PM me and I'll see if I can help you remotely this end
Back to Top
 Post Reply Post Reply Page  <123

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.