Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Displaying image using database
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Displaying image using database

 Post Reply Post Reply Page  <12
Author
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 27 May 2005 at 5:32pm
whats on line 32?

also after loop add this below

RSUser.close
Conn.close
SET RSUser = Nothing
SET Conn = Nothing


really need to know whats on line 32, if its Conn.open then the above code i said add might fix it
Back to Top
pjb007 View Drop Down
Groupie
Groupie


Joined: 03 September 2004
Location: United Kingdom
Status: Offline
Points: 185
Post Options Post Options   Thanks (0) Thanks(0)   Quote pjb007 Quote  Post ReplyReply Direct Link To This Post Posted: 27 May 2005 at 6:28pm
Added those lines, still get the error
 
The line with the error is the one that starts
Conn.Open
 
It loads but when I erfresh it does not work and I get the error in the above post.
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 27 May 2005 at 6:52pm
ok its toi do with the connection to the database compact and repair it, and re upload, it maybe slightly corrupt,

shouldn't happen really s you are closing all conections and SETS.

only thing i can think is that its holding the connection or something.
Back to Top
ub3rl337ch3ch View Drop Down
Senior Member
Senior Member
Avatar

Joined: 16 February 2005
Location: Australia
Status: Offline
Points: 341
Post Options Post Options   Thanks (0) Thanks(0)   Quote ub3rl337ch3ch Quote  Post ReplyReply Direct Link To This Post Posted: 29 May 2005 at 8:54pm
add the conn.close but not the set conn = nothing, as it stops the script from thinking of the conn variable as a connection object. either that or close the set then re-set conn as a connection object...
Back to Top
 Post Reply Post Reply Page  <12

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.