Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by MrGreed
-
Updating recordset with line numbers
and make this change: 'update records ignoring last update db.execute("update job set line_no=" & iCount & " where jobid=1 and line_no>" iCount-1 ) get rid of <> and that's it for me today.. to many brain farts. MrGreed "did you just say Minkey?, yes that's what I said.- MrGreed
- Post #10
- Forum: Microsoft: ASP (Active Server Pages)
-
Updating recordset with line numbers
ok, totally retarded ignore my last post of if iCount=lastcount+1 then MrGreed "did you just say Minkey?, yes that's what I said.- MrGreed
- Post #9
- Forum: Microsoft: ASP (Active Server Pages)
-
Updating recordset with line numbers
One change: if iCount=lastcount+1 then MrGreed "did you just say Minkey?, yes that's what I said.- MrGreed
- Post #8
- Forum: Microsoft: ASP (Active Server Pages)
-
Updating recordset with line numbers
rs.open "select count(*) totcount from job where jobid = '1'" lastcount = rs("totcount") do until iCount=lastcount iCount=iCount+1 if iCount=1 then db.execute("update job set line_no=" & iCount & " where jobid=1") else 'update records ignoring last update...- MrGreed
- Post #7
- Forum: Microsoft: ASP (Active Server Pages)
-
Updating recordset with line numbers
You would have to know somehow what your total count is, or how many records you need to update. If your going to use a loop you need to know when to stop it. MrGreed "did you just say Minkey?, yes that's what I said.- MrGreed
- Post #5
- Forum: Microsoft: ASP (Active Server Pages)
-
What loads in the status bar?
I saw the load of something like 60-70 some images, what I saw was mostly spacer.gif, and from reading your question that is also what I had thought before going to the link. MrGreed "did you just say Minkey?, yes that's what I said.- MrGreed
- Post #3
- Forum: -Web site designers
-
Updating recordset with line numbers
try: iCount=0 'default it do until iCount=10 'you can replace with your own evaluation iCount=iCount+1 db.execute("update job set line_no=" & iCount & " where jobid=1") loop Is this what you mean? MrGreed "did you just say Minkey?, yes that's what I said."- MrGreed
- Post #2
- Forum: Microsoft: ASP (Active Server Pages)
-
UGH! trying to make a rollover submit button w/o images...
No Problem just a small change: OnMouseOver="this.style.background-color='red'" onMouseOut="this.style.background-color='white'"> TO OnMouseOver="this.style.backgroundColor='red'" onMouseOut="this.style.backgroundColor='white'"> MrGreed http://www.pastame.com "did you just say...- MrGreed
- Post #2
- Forum: HTML, XHTML & CSS
-
ASP Email Type Mismatch
Mail.AddAddress sub_email Is the only one that doesn't use the equal sign. try; Mail.AddAddress=sub_email MrGreed http://www.pastame.com "did you just say Minkey?, yes that's what I said."- MrGreed
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
ASP SQL 'IS NULL'
AndyApp, ASP, is the scripting lanuage for the server and really has nothing to do with SQL. SQL is processed by your database and if there is something wrong with your query it is most likly not executing correctly or you are throwing some kind of exception. What are you using with ASP to...- MrGreed
- Post #5
- Forum: Microsoft: ASP (Active Server Pages)
-
Can IMG SRC tag be 'simplified'?
Try this: <html> <head> <script language="javascript"> var gsPath="http://this.is.my.server.name/branch/tree/etc/"; //replace with your thumb names, add additional ones as you need var garrImageNames = new...- MrGreed
- Post #3
- Forum: HTML, XHTML & CSS
-
CDO problem
I found a MS help article: http://support.microsoft.com/default.aspx?scid=%2Fservicedesks%2Fbin%2Fkbsearch.asp%3FArticle%3D321807 Sometimes "component can't create object" is thrown because you don't have the right security permissions setup. MrGreed http://www.pastame.com... -
Batch execute Recordset
Just use a begintrans on the connection object objConn.begintrans Do While Not Products.EOF 'For each sub-categories the child products are displayed for that site added Dim Product_Mask Product_Mask = SubCat_Mask_Dif +...- MrGreed
- Post #2
- Forum: Microsoft: ASP (Active Server Pages)
-
Stored Procedure error
change: connection.Execute "up_Update_SBounce " & varEAddr to: connection.Execute "up_Update_SBounce '" & varEAddr & "'" Add the single quotes so your procedure types it as a string. MrGreed http://www.pastame.com "did you just say Minkey?, yes...- MrGreed
- Post #6
- Forum: Microsoft: ASP (Active Server Pages)
-
Can I create a class?
Class Statement Declares the name of a class, as well as a definition of the variables, properties, and methods that comprise the class. Class name statements End Class Arguments name Required. Name of the Class; follows standard variable naming conventions. statements Required. One or...
