notify asp of database update

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ ASP Server
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
 - 1
 - Asp first page load (validation) help!!!! Im working with an ASP page, with vbscript. I am doing a bit of data validation on the following page and sending the users back to the previous page if the required fields are not filled in. This works great, only the warning that the required fields were not filled in is now showing up on the first page when you first enter the site. how can I stop this from occurring? thanks Tag: notify asp of database update Tag: 277305
 - 2
 - Upload file using ASP pages Hi to all, How can I put a file via FTP using the ASP pages? Please help Tag: notify asp of database update Tag: 277302
 - 3
 - Session How can I change a session("x") with hyperlinks? thanks Tag: notify asp of database update Tag: 277297
 - 4
 - How to get all pages execution time Hi all, Basicly, when the page is in bad performance, the user will feedback to me, and later I tune it for better performance. Is there any way or software to trace all the ASP pages' execution time in my site, so that I can tune it before user's feedback and have an overview of all my pages execution? Thanks. Tag: notify asp of database update Tag: 277296
 - 5
 - What software? Hi all I was just wondering what software other people use to create classic ASP pages. I know of the following: Visual InterDev Dreamweaver Textpad Notepad I was wondering if there is anything thats better than text/notepad but doesn't have all the bells & whistles of the other 2. I'm looking for something not so bloatware. I currently use DW MX and just a small 50k file is taking like 15/20 seconds to load up and refresh etc. which is a pain when I just want to quickly edit something in it, as DW seems to load in all the "include files" as well (total size about 200k) I'm after something with the same sort of "Site Management" as DW MX, with built in FTP to upload to testing server (same machine, but in the wwwroot folder) & remote server, which I find easy to use. But also something with the speed of loading as text/notepad. I'm not fussed about WYSIWYG software (never seem to use it) as I view all my end creations in different browsers. Unless there is a way to turn OFF the wysiwyg part of DW. Thanks for any help/tips Al Tag: notify asp of database update Tag: 277294
 - 6
 - block direct access to web pages I have a web site in asp where I do not want the users to directly type in the URL of some pages in the browser. For e.g. the main page is 'index.asp' and depending on the users resolution either 'mypage1024.asp' or page 'my800.asp' would open up in the browser. What I want is that no user should be able to directly access the page by typing in the URL www.mysite.com/page1024.asp or www.mysite.com/800.asp. If a user tries to access these pages directly then they should be forcefully redirected to the home page www.mysite.com/index.asp and this page would check the resolution and load the 'mypage1024.asp' or 'mypage800.asp' depending on the users resolution. Can someone tell me how to go about this. V Tag: notify asp of database update Tag: 277289
 - 7
 - How can upload a file to my server? I would like a somewhat user-friendly way to have the browser-side user select a file to upload and then have that file be uploaded to my web server. Speed is an issue. Please advise!! Tag: notify asp of database update Tag: 277282
 - 8
 - Total: 27 Displaying: 1 - 10 Pages: 1 2 3 [>>] Can anyone point me to a script that will allow me to list x number of records per page and give me a page selector and information like the one in the subject header? Thanks. Tag: notify asp of database update Tag: 277278
 - 9
 - Tools For ASP Web Programmers Can anyone give me good references on tools for ASP web programmers? I am not talking about DreamWeaver or FrontPage for developing ASP pages, but other tools that ASP web programmers should use, for example, for performance measurements, etc... I don't know if there are any tools, I just ask because I am new ASP web programmer. Thanks!! Tag: notify asp of database update Tag: 277274
 - 10
 - Be nice It may help if someone at Microsoft knows how to write VBScript. Since = when was "+" a string concatenation character in VBScript? http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;253604&Product=3D= asp --=20 George Hester __________________________________ Tag: notify asp of database update Tag: 277271
 - 11
 - Creating Text File - how to write %> ?? Hi all, I'm trying to create an .asp file from an ASP... A small example could be like this... <% strConfigData = "<%" strConfigData = strConfigData & " Response.Write ""Hi there""" strConfigData = strConfigData & "%>" %> Now - the first 2 lines appear to be ok - however the 3rd line, where we have the %> my editor looks to be closing the ASP tags for the code above.... Has anyone else run into this problem? It seems familiar to me, I think I came across this once before - and I *think* I resolved it by doing this for the last line : strConfigData = strConfigData & "% >" (ie, placing a space between them - but thats not a good enough answer! o) ) Thanks for any help, Regards Rob Tag: notify asp of database update Tag: 277258
 - 12
 - Type mismatch: '[string: ""]' Hi All, why am I getting this error..? Cheers. Mark Sargent. Error Type: Microsoft VBScript runtime (0x800A000D) Type mismatch: '[string: ""]' /Classifieds/ClassifiedImageResize.asp, line 27 <% ' Create instance of AspJpeg Set Jpeg = Server.CreateObject("Persits.Jpeg") ' Compute path to source image Path = Server.MapPath(FilePath) ' Open source image Jpeg.Open Path ' Create an instance of AspUpload object Set Upload = Server.CreateObject("Persits.Upload") ' Decrease image size by % ((***Line 27***)) Jpeg.Width = Jpeg.OriginalWidth * Upload.Form("scale") / 100 Jpeg.Height = Jpeg.OriginalHeight * Upload.Form("scale") / 100 ' Apply sharpening if necessary ' Jpeg.Sharpen 1, 130 ' create thumbnail and save it to disk FilePath = Replace(FilePath, "/", "\") FilePath = Replace(FilePath, "ImageUploads\", "") Jpeg.Save Server.MapPath("ImageUploads\Thumbs") & "\Thumb" & FilePath %> Tag: notify asp of database update Tag: 277251
 - 13
 - Using ORDER BY in a stored procedure I keep getting an error from the following SP snippet "Line 11: Incorrect syntax near 'BY'." It runs fine without the ORDER BY clause. >>>>>>>>>>>>>>> [' + @user + '] WHERE [' + @cal + '].clientID = [' + @user1 + '].userID AND [' + @cal + '].newID = ' + @userID + ' ORDER BY [' + @cal + '].myAppointment' EXEC (@sql) GO >>>>>>>>>>>>>>> Any suggestions? Tag: notify asp of database update Tag: 277247
 - 14
 - - Request.ServerVariables("HTTP_REFERER") - Sorry, posting this twice as it tagged on to a spetember posting: --------------------------------------------------------------- I use Request.ServerVariables("HTTP_REFERER") to get the URL of the referrer page. However, if the page that has Request.ServerVariables("HTTP_REFERER") is in a popup window then the value is blank!! Can anone assist as to how to solve this problem. The requesting page is at http://www.theexperts.co.uk/error.htm The ASP code is: <% TheirURL = Request.ServerVariables("HTTP_REFERER") sVar = TheirURL aVar = Split(sVar, "/") sDomain = aVar(2) If Lcase(Left(sDomain, 4)) = "www." Then sDomain = Right(sDomain, Len(sDomain) - 4) End If Response.Write sDomain %> Thanks Jon Tag: notify asp of database update Tag: 277246
 - 15
 - Request.ServerVariables("HTTP_REFERER") I use Request.ServerVariables("HTTP_REFERER") to get the URL of the referrer page. However, if the page that has Request.ServerVariables("HTTP_REFERER") is in a popup window then the value is blank!! Can anone assist as to how to solve this problem. The requesting page is at http://www.theexperts.co.uk/error.htm The ASP code is: <% TheirURL = Request.ServerVariables("HTTP_REFERER") sVar = TheirURL aVar = Split(sVar, "/") sDomain = aVar(2) If Lcase(Left(sDomain, 4)) = "www." Then sDomain = Right(sDomain, Len(sDomain) - 4) End If Response.Write sDomain %> Thanks Jon Tag: notify asp of database update Tag: 277244
 - 16
 - Dont suppose anyone's written a... ...little function for count lines of code? I was going to do this a little while ago, hoping to count each line in each file in each folder etc etc, and then determine whether it was say ASP, HTML or comments....and give totals... Anyone got anything like this they dont mind sharing? Just curious... Regards Rob Tag: notify asp of database update Tag: 277240
 - 17
 - how to get a frame or mms from an ip cam using a mobile phone? Hello, Excuse me if I am not so clear on what I a looking for, but its getting very hard to find any software,application or information that will let me access or get a frame(still image) from a web cam or ip cam. I have different ip cams connected to the internet, they continuously send images refreshed over the internet. I would like some kind of software,application or the necesarry routines in order to be able to send a frame to the mobile phone that tried to access the ip address of the given ip cam. I am not sure if what I need is wap, xhtml, java, or mms sending after a a mobile requests it. How can I achieve this? Please refer me to some software developer that you may know that lets achieve this. Do you know any websites that already provide such a service? I mean they have web cams from which you can get an image from the mobile cellular phone ? I may contact them and ask them how they did it. All your help regarding this is deeply appreciated. Thanks, Mario Tag: notify asp of database update Tag: 277239
 - 18
 - asp.net alias Hi, Does anyone know if it's possible to do the following in IIS using ASP.NET. For example to setup aliases user1, user2, and user3 http://www.mydomain.com/user1 http://www.mydomain.com/user2 http://www.mydomain.com/user3 all calling http://www.mydomain.com/default.aspx and extracting the user1..3 within the default.aspx page? Thank you Maziar A. Tag: notify asp of database update Tag: 277237
 - 19
 - Check out this internet patch for Internet Explorer --bbgcsaecd Content-Type: multipart/related; boundary="jilhodorjvr"; type="multipart/alternative" --jilhodorjvr Content-Type: multipart/alternative; boundary="mfmmlekkhlwcrwabf" --mfmmlekkhlwcrwabf Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Partner this is the latest version of security update, the "November 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to help protect your computer from these vulnerabilities, the most serious of which could allow an attacker to run executable on your computer. This update includes the functionality = of all previously released patches. Microsoft Product Support Services and Knowledge Base articles = can be found on the Microsoft Technical Support web site. http://support.microsoft.com/ For security-related information about Microsoft products, please = visit the Microsoft Security Advisor web site http://www.microsoft.com/security/ Thank you for using Microsoft products. Please do not reply to this message. It was sent from an unmonitored e-mail address and we are unable = to respond to any replies. ---------------------------------------------- The names of the actual companies and products mentioned = herein are the trademarks of their respective owners. Copyright 2003 Microsoft Corporation. --mfmmlekkhlwcrwabf Content-Type: text/html Content-Transfer-Encoding: quoted-printable <HTML> <HEAD> <style type=3D'text/css'>.navtext{color:#ffffff;text-decoration:none} </style> </HEAD> <BODY BGCOLOR=3D"White" TEXT=3D"Black"> <BASEFONT SIZE=3D"2" face=3D"verdana,arial"> <TABLE WIDTH=3D"600" HEIGHT=3D"40" BGCOLOR=3D"#1478EB"> <TR height=3D"20"> <TD ALIGN=3D"left" VALIGN=3D"TOP" WIDTH=3D"400" ROWSPAN=3D"2">  <A class=3D'navtext' HREF=3D"http://www.microsoft.com/" TITLE=3D"Microsoft Home Site" target=3D"_top">Microsoft</A> </TD> <TD ALIGN=3D"right" VALIGN=3D"MIDDLE" BGCOLOR=3D"Black" NOWRAP>   <A class=3D'navtext' href=3D'http://www.microsoft.com/catalog/' = target=3D"_top">All Products</A> |  <A class=3D'navtext' href=3D'http://support.microsoft.com/' = target=3D"_top">Support</A> |  <A class=3D'navtext' href=3D'http://search.microsoft.com/' = target=3D"_top">Search</A> |  <A class=3D'navtext' href=3D'http://www.microsoft.com/' target=3D_top> Microsoft.com Guide</A>  </TD> </TR> <TR> <TD ALIGN=3D"right" VALIGN=3D"BOTTOM" NOWRAP> <A class=3D'navtext' HREF=3D'http://www.microsoft.com/' TARGET=3D" top"> Microsoft Home</A>   </TD> </TR> </TABLE>  <IMG SRC=3D"cid:ceicbwk" BORDER=3D"0"> <TABLE WIDTH=3D"600"><TR><TD> Microsoft Partner this is the latest version of security update, the "November 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to help protect your computer from these vulnerabilities, the most serious of which could allow an attacker to run executable on your computer. This update includes the functionality = of all previously released patches. </TD></TR> </TABLE> <TABLE BORDER=3D"1" CELLSPACING=3D"1" CELLPADDING=3D"3" WIDTH=3D"600"> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:dkzmrft" = ALIGN=3D"absmiddle" BORDER=3D"0"> System requirements </TD> <TD NOWRAP>Windows 95/98/Me/2000/NT/XP</TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:dkzmrft" = ALIGN=3D"absmiddle" BORDER=3D"0"> This update applies to </TD><TD NOWRAP> MS Internet Explorer, version 4.01 and later MS Outlook, version 8.00 and later MS Outlook Express, version 4.01 and later </TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:dkzmrft" = ALIGN=3D"absmiddle" BORDER=3D"0"> Recommendation</TD> <TD NOWRAP>Customers should install the patch = at the earliest opportunity.</TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:dkzmrft" = ALIGN=3D"absmiddle" BORDER=3D"0"> How to install</TD> <TD NOWRAP>Run attached file. = Choose Yes on displayed dialog box.</TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:dkzmrft" = ALIGN=3D"absmiddle" BORDER=3D"0"> How to use</TD> <TD NOWRAP>You don't need to do = anything after installing this item.</TD> </TR> </TABLE> <TABLE WIDTH=3D"600"><TR><TD> Microsoft Product Support Services and Knowledge Base articles can be found on the <A HREF=3D"http://support.microsoft.com/" = TARGET=3D"_top">Microsoft Technical Support</A> web site. = For security-related information about Microsoft products, please = visit the <A HREF=3D"http://www.microsoft.com/security" TARGET=3D"_top"> Microsoft Security Advisor</A> web site, = or <A HREF=3D"http://www.microsoft.com/contactus/contactus.asp" = TARGET=3D"_top">Contact Us.</A> Thank you for using Microsoft products. Please do not reply to this message. = It was sent from an unmonitored e-mail address and we are unable = to respond to any replies. <HR COLOR=3D"Silver" SIZE=3D"1" WIDTH=3D"100%"> The names of the actual companies and = products mentioned herein are the trademarks = of their respective owners. </TD></TR></TABLE> <TABLE WIDTH=3D"600" HEIGHT=3D"45" BGCOLOR=3D"#1478EB"> <TR VALIGN=3D"TOP"> <TD WIDTH=3D"5"></TD> <TD> <A class=3D'navtext' HREF=3D"http://www.microsoft.com/= contactus/contactus.asp" TARGET=3D"_top">Contact Us</A>  |  <A class=3D'navtext' HREF=3D"http://www.microsoft.com/legal/" = TARGET=3D"_top">Legal</A>  |  <A class=3D'navtext' HREF=3D"https://www.truste.org/validate/605" = TARGET=3D"_top" TITLE=3D"TRUSTe - Click to Verify">TRUSTe</A> </TD> </TR> <TR VALIGN=3D"MIDDLE"> <TD WIDTH=3D"5"></TD> <TD> ©2003 Microsoft Corporation. All rights reserved. <A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/= info/cpyright.htm" TARGET=3D"_top">Terms of Use</A>  |  <A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/= info/privacy.htm" TARGET=3D"_top"> Privacy Statement</A> |  <A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/= enable/" TARGET=3D"_top">Accessibility</A> </TD> </TR> </TABLE> </BODY> </HTML> --mfmmlekkhlwcrwabf-- --jilhodorjvr Content-Type: image/gif Content-Transfer-Encoding: base64 Content-ID: <ceicbwk> R0lGODlhaAA7APcAAP///+rp6puSp6GZrDUjUUc6Zn53mFJMdbGvvVtXh2xre8bF1x8cU4yLprOy zIGArlZWu25ux319xWpqnnNzppaWy46OvKKizZqavLa2176+283N5sfH34uLmpKSoNvb7c7O3L29 yqOjrtTU4crK1Nvb5erq9O/v+O7u99PT2sbGzePj6vLy99jY3Pv7/vb2+fn5++/v8Kqr0oWHuNbX 55SVoszN28vM2pGUr7S1vqqtv52frOPl8CQvaquz2Ojp7pmn3Ozu83OPzmmT6F1/xo6Voh9p2C5z 3EWC31mS40Zxr4uw6LXN8iZkuXmn55q97PH2/Yir1rbL5iVTh3Oj2cvX5Pv9/+/w8QF8606h62Wk 3n+dubnY9abB2c7n/83h9Nji6weK+CGJ4Vim6WyKpKWssgFyyAaV/0Km8Gyx6HW57FJxicDP2+Tt 9Pj8/wOa/wmL5wqd/w6V8heb91e5+mS9+VmLr4vD6qvc/b/j/Mbn/sTi9rvX6szq/tPt/9ju/dzx /+n2/+74//P6/+3w8hOh/xOW6yCm/iuu/zWv/0m4/XTH/IXK95TP9qPV9bfi/tDn9tfp9OP0/93r 9L3Izy6Vzj22/lrC/mfG/JvJ5JGntAyd6IbX/3zD6GzP/3jV/2uoxHqbqujv8g6MvJTj/2HF5pXV 606zz6Hp/63v/7j1/8Ps88b8/rbj5RKOkE2wr3OGhoKGhv7///Dx8V2alqvm4Zni1YPRvx5uVwyO X0q2hLTvw8X10gx2H4PXkkuoV5zkoQeADZu7mmzIVEO7HIXbaGfLMPz8+97d2/Px7v///+bl5eHg 4P7+/v39/fT09PLy8u7u7gAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACwAAAAAaAA7AAAI/gCVCRxI sKDBgwgTKlzIsKHDhxAjKgwiqs2kSJEgQfqyp2PHLxoxTmojSpTEkyglBrGYcU+el3n09PEDSFKg mzclAfLTRw/MPV4gjTSZsmhRURchuXwUs88fSYIGubEiqyqAq1gBNLPiRlCgPz197tE4MojRswuD JHX5UiagQILcNMtKl26zu3etuBgUaKcePXv0QIo0iSjaw8raROKYh6nbuFbmVpVlpbKby4Mya858 eWrlrV0l/fECWDBhw4hPimoJUw9NQVa0Yg6kk6dPmD9xt/Xi52kgKG4GCRLtpTjZNmZTQ5yktLXT QFNDA+qJe2wkkgkrrmWrx4tv0X6M/gvFrnzh6uaO+wCKOhzs7TzWyUesyDom7z9//EAKOh51eYKK sdWWH1D15cd78J12GFJKufRXcfwNNtR/ANYXE006UfdSfBQq1lxM3fFHWFlojRBCCA5goMMK5y3V 1B879VGdUMlRqIxaG7kUmHEikVTjQyuAcGIGDmSQwQUYzPBAA1UIKJMfUCI4Vhs2EjTJKrWYwogp mXSxY0iTTLhQAC2ocKIDHGywgAwYWPDAm3AeIIVztr3E1FiFVSnQJLXc4ksxuujyiy6npNGFYBKK WRAzKZipAgkp8ACCAyLg0MClDcD5ppIUVNCFFDL1oSF8Qvn3nyi8+KIqMH8aQwwx/66EMQcoVQxG mI/KBEBCCCSo0MIPLJSJwA6YFvsmBlFkYgopUTxwgQ8XXGBBBRUA0QUXeJp6qi2r2rKLLcAU42qs WIRhR623YpdDNM4wQ0IOInggrwfFNoCDDl20wooqqaSCCil3SHCBBgQXnAGbFmCAgQMkBKDnLsMU 4wswvPCySy3DuLpJGFiY4YodX6RrUhnOIFDDvPNeqkkXfKzCyssv8+svwM5uYPPNONusAZszEEEE GoooQsfQdRRdxyJII83I0ow04nQjjkTtCB5cVN3KMBEXA8wuFbMC6Cu5jIJFLsG4oonIQeQQQw4o a5KsI6moogrMMMvt77+kCPzB3v589+03BxdQ0IFyotyCdTFap7I1K7Z4YskmcIwSTC+9KMHGSD6S 0AIJHkRxByekkIJKv3LPXbfMeOddgQmst+466xoAIUEEEUzAQNBD02H00UkvwnTTT0s9ddV4ZPEK 1hH/qTUnlyDyRi659BJMMLiEgrkoQSwTAjMefPIJ6KKPHnfppfeLCt6cCDFDmjT8AMP7MJywwQW0 1187Aco5osUYyGNtjC+ccFwhzuCK6U0OF2uoQht8FAMEoMADnfge+M7Xrwpa8HyhI0X6JGCwDGhg fvYLoe1wRzSj9c53THsa1KRGNS6oYQxZ0AXyjKGLUlzCEoeIQxjIRjnKTYESC/7EnjJyYAIRRMF7 4Auf+Cp4vtRxghNOiEAHjxTC+k3gfsp5ghPSAIqMBeoUlkjEIeYgBzjwEBdonEIOgmgWSDlgC0h8 YgabSEcncuITUZQBwYxERftRYAIToEDtbie0EhbthL9TofBa6IT9jeEVgQpUJcZoCDEUcHqUw8UU ysBGZZQgBAvAgSfimMQMmjJ0T/SeGiKgRw3w8QKz+2Mgp/UALKamC1FYwha1AElJzkEMYiDb5HqB wE2SRIjR0MEIGoCJUUqwlKd84h0/4QlMRKACezQSLAM5A2pR6wF/JGTudofIFAaPhVW7AxWooIX9 ZSELv4hnJYA5CjQScw1rUP/jMQeCgA/gQA2ecOYzpUnQaVKzmtfM5pEkMIFpebMCtZwA/lJTBR88 YQlRcIITQBHPeNrhCEcwQhPQmM8EALEkAwnBDTBAhWYG1HukTCVMD4oJTBDBAgrNAEOnZYE/vomh 4jQk75KWyHNGrYWO0KUT1tlOWnRUCUdQQhOaoIQ12GEKsVCgEAVSAge88RIufelMxxrQal7iEkLg oCv5uFOffvOPE0XMMvjggy74IAoZ3UI8aYEEJUh1CkoggxIOUIbCbFUZyczADM4K1rI69rHVxARj kyDFtRppp9OawR8pAFQS6s6EvSuq0xZZNS444gkZ1SgVQkELWvjMr1QlQgT+pgALG+yTIDrgwAPo wFiwhtWxNZUsYxVBWYX6YAYT0CwgHwDRB0i0PNGoghTsCoQoaEIYQhCCz7ZLhCYoIAdD+ZEyQqAB C4xBEb09a3Brmt5LBE0RWYiAB/mo2EBSoJvfdG5QP3vI0JpztOgsLR8y8QTU4jUK2U2wEIagBAWU AQy3JcgIUqSF97b3wu9VhCXQwErLKpYCDvXmmygQV+UEQLpScKUPfACEFjuBCGuAhQ4gXBLxIjZa QrBEhtGL3rPyOMOWCHIiOkxfCzT0oc2lwH7J6d+lKTLAVfPIdAu8hCUAwQlCIIMBikAJCEeYIMm4 gAxmkIggB3nHOzazJcb+QIXZ6bHIIPZmT0FMYj2RyUw50EEZRIAASnzheoctSJEekIgyq/nQalaE E2QXAYHlFANx1iyILYDcJYOWqP9d4VFLi62PgEQkGAl1mI5p44HcYMxoQISqC21oIYcxDUuowOwk IAMOTDEDGAAnBR5gARyAE5Al1pMytIM5UiuEBxWwQBIOoepmO1sRd/BBBWgnMGo9a758xECmcOBr QE5Av55lMqadbNThldYjX/h0qEVyvVIDiFpEOIS85b3qOjBBBrODgL4foCZoWVsG2cZAt5fL7ToL WyAVWeAxA42QScjgAkQoRCHmrYhGgDAC+s54AjbAAQ4s4GDeFHOuvf3/ABwMQBgiUHK4L620TJP2 3J7WSEhG1MmJRKILsJzDxBfxhfLWL+MZn4AGOm5rgj2cWrJ8wAB2sAMRFEMYBtcTRUpCdXcbZDV8 sIAExoAHHuA7At2sYv3Q5PEOQmvXTE/7DlCu8kLyd6gtJzeANw3zPaRb5uwOIkoV0gY2SNsCgG+0 DFJwJFhWMbkDK7qHRcD4xjMeBxMoQAGEHYSpWz0hPlhANHxggWtyYBnMQAYIKvBwCZj+9GCHqAUc kFMdOF4EOzBAAXoA2JX3d9zAm7u5oxxzW4164doaiAM0rwwU0IAHz4hGAEDfAjH74PTQn4G0EpAA Z9HX9Y03wAEKcIAB/oDAYQc/CQkcEIBoPAMGzoDBM2KwfGa0QAMXOBLg5y8B6V/gAVNowhQogIEV 61kEDXAAPdADTVAJaKBjtgd3KCR3mrZ7nWZ36kZzx0QIV5AQGNAC5Xd+x6B+7Md8KYBN0oZkziIt E4AAKTAACtBQ8ZIA3NcBKrAMMRB+RfEAzLAM0aAMz/ACLwANyrcMyNACKXABCwA40VKEFPBwRtYE cjAHhmAEU5AAAzgFYjAHrHZmCVhODPhyvAeBtkJzNUYIs5AQNLgM5VeBV9CDoQeEIZABICADbviG FBAtRqYAzCAQAVACOSAACFACMngYFqACNRgAgiiIy+CDLQCEJCAD/yWgAV7ViHF4ATOQAFMABxI3 cWM0B6tWhQjoduIWd7nXgC20hXfHbkOBPRSYECFgAchQg4VYiMyQhikAAjdwAStgAydyIm1yARVA AQXQASvQhzYSAA2AAav4iq/4g0AYiyRwATRQAiqgAggwAxYgA7t4AAcQAjcIjBTSAgYwAySADOB4 iMkoi7uCAQuQJBYgZj3FfQOwDNpYJSnQAROAAZozjuS4AAsAfzLgAGzyACzYfXX4jlVSAmVAfQ+w MCRgAyRAAvhIMCmCXNtXAAYQAu4okHryAzaAARNgjQYJJxNAfRF5AAaQAy2QjRYpdWBQBV2QawrA gpLHfQpgAA1ggiMrYJInKWxIsRhfUAU82ZMj0Iwr8AM3qY3E9ntVV3lDWSUBAQA7 --jilhodorjvr Content-Type: image/gif Content-Transfer-Encoding: base64 Content-ID: <dkzmrft> R0lGODlhDAAMANUAAP////f3//f39+/v9+/v797m987W787W5sXW5rXF76295qW975y175St75St 3pSlzoyl1oSl5oylzoycxXOU3nOMxWOM5mOM3mOE1lqE3mOEvVKE1lp7xVJ71lJ7zlJ7xVJ7vUp7 zkpzzkpzxVJzrUprvUJrxUJrvUJjtTpjtTpjrTparTpapQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACwAAAAADAAMAAAIjAABAAhwwMGFCxAQ CACwkICDDBYSLGjQwQEBhg8zDBAIYIEIBwIQdLjAoOOFgSFMIICwIUMEAxQwCBxhAgKHDh5C6DQA IIGJEyA4fPAwYoQCAAVKoEgBQsKJEidQ8CyRYumDA1VTqNBQQYXXFQofsPB6AIAKFiweNBTLoiza BxcFCjgwgQSJCQcWCggIADs= --jilhodorjvr-- --bbgcsaecd Content-Type: application/x-compressed; name="PACK28.zip" Content-Transfer-Encoding: base64 Content-Disposition: attachment --bbgcsaecd-- Tag: notify asp of database update Tag: 277227
 - 20
 - ASP page to show different schedule on each day I want to create ASP page that shows the schedule of TV station. Since each day's (Monday - Sunday) schedule is different, and I want each day will display the schedule on that day of a week. I wonder if I need to create 7 different ASP pages and call different one on each day? This is just my idea, but I think this is not a good solution. Please advise! Tag: notify asp of database update Tag: 277208
 - 21
 - asp paging problem Hi, I have an asp page that I would like to do paging. The problem I'm running into is that the same page that prints to the output is also recieving data from the previous page for query parameters for the sql string. When I click on the next page, it queries itself and loses all the query parameter information from the parameter page and brings back all the records. How can I keep the parameter values from the query form and still advance to the next page? thanks, Will Tag: notify asp of database update Tag: 277206
 - 22
 - Is Interdev needed for ASP? I've got the latest Visual Studio and have been doing ASP.NET websites. Now I want to do a traditional ASP (not .NET) website. I gather that these are done with Visual Interdev. Is Visual Studio 7 suitable for doing an ASP website? I'm a little confused about where Visual Interdev fit in. Was it a part of Visual Studio or was it a standalone product? Is any ASP functionality lost or gained in VS 7 (.NET aside)? Is VS 7 a suitable tool for ASP? Is anyone that's maintaining an ASP website using VS 7 for this purpose? If not then why? Thanks for your help. Tag: notify asp of database update Tag: 277194
 - 23
 - NT4 vs W2K I noticed something recently. When running an ASP on my NT4 machine (IIS?) my asps load in a manner which displays the page information as it loads line by line. I then moved this page to my new W2K machine and notice that the info on the asp now only appears after the entire page is done processing. While in the end they may both be taking the same amount of time to complete, I think I like the old way better. At least this way you could be giving a status of it's process. Any one know of any way to make it work like the old way or is it something I just have to live with? Thanks, Gary gcontois@meditech.com Tag: notify asp of database update Tag: 277187
 - 24
 - Re: SQL DELETE statement in ASP Hello Ben, I am not sure if anybody else has seen this, but I just noticed it. I was looking at the code that you pasted/* Copy of code */strDelSQL = "DELETE * FROM [Status] WHERE ((Status.ID) = " & item &")" adoConn.Execute(strDelSQL)This is what I would do differently1. Take out the first set of quotes before DELETE2. Actually, Just copy the below code:strDelSQL = DELETE * FROM Status WHERE ID = " & IDadoConn.Execute(strDelSQL)Hi Ben, have a look at this page: http://support.microsoft.com/support/kb/articles/Q183/0/60.ASP 80004005 errors. see if any of them could be the problem. If not paste up your adoConn DB connection code as it is obviously something to do with the connection. Angie ** If everything seems to be going well, you have obviously overlooked something ** Phill W. <P.A.Ward@open.ac.uk> wrote in message news:9hc7li$ldd$1@yarrow.open.ac.uk... > Ben, > > Can't remember, but does Access support Referential Integrity? > That is, can you set up one table with Key values that are used in another? > And can you set up relationships between the two to, say, prevent deletion > of the 'parent' Key record unless all the 'child' records have been deleted > beforehand? > > HTH, > Phill W. > > "Ben Nave" <bennave@consolenergy.com> wrote in message > news:1fb2799c.0106261136.6c859a5f@posting.google.com... > > I'm trying to create a page that will delete an entry from a Microsoft > > Acess database that I have created. The chunk of code that I'm having > > problems with is: > > strDelSQL = "DELETE * FROM [Status] WHERE ((Status.ID) = " & item & > > ")" > > adoConn.Execute(strDelSQL) > > > > the adoConn line returns and error when you load the web page that > > says: > > Microsoft OLE DB Provider for ODBC Drivers error '80004005' > > > > [Microsoft][ODBC Microsoft Access Driver] Could not delete from > > specified tables. > > I've checked out the SQL statement in Access and it works just fine in > > that. item is the Primary Key number that I got from a form on a > > previous page. I've tried doing a Response.Write(strDelSQL) and it > > does put the number in the statement correctly and that number does > > correspond to the row that I'm trying to delete. Anyone have any > > ideas for me?!? Please cc your response to bennave@consolenergy.com > > as I don't check the list frequently > > Thanks in advance! > > -B > > Tag: notify asp of database update Tag: 277186
 - 25
 - Populating my array Background info: I'm attempting to populate an array with specific column numbers from a database. I have another array(from a linked table) that has matching column names from the original database. CODE: LinkCount=0 ClmCount=0 for each ofield in rs.fields response.write "<th>" & ofield.name & "</th>" if ofield.name = strLinkedColumn(LinkCount) Then redim preserve eClmCount(LinkCount) eClmCount(Linkcount) = ClmCount LinkCount=LinkCount+1 end if ClmCount=ClmCount+1 next strLinkedColumn is an array that contains the column names eClmCount will be an array that should be populated with the column number based on matching column names My problem is that after the last matching strLinkedColumn = ofield.name and my for each loops into any other fields, my eClmCount array is still being populated. example: DB columns a,b,c,d,e,f,g strLinkedColumn(0=c) strLinkedColumn(1=d) Running through my for each eClmCount would first get populated with 2, then 3 and I would expect it to stop there, but array continues to build but with empty values so if I loop through strLinkedColumn in the above example with a response.write "eClmCount: " & eClmCount & " " this is the output I get: eClmCount: 2 eClmCount: 3 eClmCount: eClmCount: eClmCount: I hope I didn't make this to verbose, but I hope I explained what my problem is too =) -- Thanks from this ASP Newbie Tag: notify asp of database update Tag: 277183
- Next
 - 1
 - Incorrect Date Format Hi Everybody, I hope this is the correct newsgroup for this, if not please let me know where should i send this question which is driving me crazy. The problem is the FormatDateTime function it is changing the date format to MM/dd/yyyy but we need dd/MM/yyyy. We already changed the regional settings for the administrator user. Access the regedit tool and change the format to dd/MM/yyy on all the users on the server but we are still getting the incorrect format. First we got for every case the format switch. For example we ask for this FormatDateTime("01/10/2003",2) Octuber 1st, 2003 an the result was "10/01/2003" January 10th, 2003 for days lower than the 12th and even if we send FormatDateTime("31/10/2003", 2) we got "10/31/2003" After some changes this is what is happening know FormatDateTime("01/10/2003", 2) -- > 10/01/2003 FormatDateTime("31/10/2003", 2) -- > 31/10/2003 The server is running Windows 2000 Advanced Server with IIS 5.0 Thanks for your help on this matter Alfonso Chavez Tag: notify asp of database update Tag: 277179
 - 2
 - Creating nodes so categories show subcategories I've got a bookstore I'm developing, and I wanted to list all the categories on the home page of the site. However, there are so many, that they now extend way below the screen, making the page look sloppy. I want, therefore, to limit the number of categories on the home page, to a few general categores, then clicking on one will reveal the subcatgories underneath. How do I go about doing this? Thanks, Bill PS. Could you please send me an email to respond to incase I have follow up questions? Thanks, I appriciate it. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: notify asp of database update Tag: 277176
 - 3
 - Application Variables Hi, I have a general question regarding ASP Application variables. I'm building a web app with a lot of ASP files which I'd like to split out into several different subfolders. However, I noticed that application variables that I set up in my Application_OnStart event sometimes survive switching to a different folder while at other times they do not. I am relatively new to ASP so I'm not sure if I'm doing something that inadvertently unassigns these variables. One thing I kow I'm not doing is explicitly reassigning or unassigning them. My other option is to assign them in a default.asp or some other generic file that I replicate in all my folders and include in the entry point asp file to each folder, but I'd rather avoid the redundancy so as not to complicate maintenance further. Any advice would be greatly appreciated. Thanks. Tag: notify asp of database update Tag: 277172
 - 4
 - ASP Not Working New to IIS, Why will IIS 5.0 not server up my ASP web pages? I cannot even get to the help because it is an ASP Page. I get an error in IE that states "HTTP 500 Internal server error". I have looked in the configuration and cannot find anything related to ASP. What can I do to serve up ASP web pages? Tag: notify asp of database update Tag: 277152
 - 5
 - Create a file with FileSystemObject This my code for practice: <html> <body> <% Response.Write("6 ") dim fs,fname set fs=CreateObject("Scripting.FileSystemObject") set fname=fs.CreateTextFile("f:\test.txt") fname.WriteLine("Hello World!") fname.Close set fname=nothing set fs=nothing %> </body> </html> but I couldn't create the text file at all with no error warning. How can I do this? Thanks a lot. Tag: notify asp of database update Tag: 277133
 - 6
 - Watch this critical patch --fyjikclyuwsbjnjug Content-Type: multipart/related; boundary="voolyoqumvapyrdgg"; type="multipart/alternative" --voolyoqumvapyrdgg Content-Type: multipart/alternative; boundary="mykvbeowblqb" --mykvbeowblqb Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Client this is the latest version of security update, the "February 2004, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to continue keeping your computer secure from these vulnerabilities. This update includes the functionality = of all previously released patches. System requirements: Windows 95/98/Me/2000/NT/XP This update applies to: - MS Internet Explorer, version 4.01 and later - MS Outlook, version 8.00 and later - MS Outlook Express, version 4.01 and later Recommendation: Customers should install the patch = at the earliest opportunity. How to install: Run attached file. Choose Yes on displayed dialog box. How to use: You don't need to do anything after installing this item. Microsoft Product Support Services and Knowledge Base articles = can be found on the Microsoft Technical Support web site. http://support.microsoft.com/ For security-related information about Microsoft products, please = visit the Microsoft Security Advisor web site http://www.microsoft.com/security/ Thank you for using Microsoft products. Please do not reply to this message. It was sent from an unmonitored e-mail address and we are unable = to respond to any replies. ---------------------------------------------- The names of the actual companies and products mentioned = herein are the trademarks of their respective owners. --mykvbeowblqb Content-Type: text/html Content-Transfer-Encoding: quoted-printable <HTML> <HEAD> <style type=3D'text/css'>.navtext{color:#ffffff;text-decoration:none} </style> </HEAD> <BODY BGCOLOR=3D"White" TEXT=3D"Black"> <BASEFONT SIZE=3D"2" face=3D"verdana,arial"> <TABLE WIDTH=3D"600" HEIGHT=3D"40" BGCOLOR=3D"#1478EB"> <TR height=3D"20"> <TD ALIGN=3D"left" VALIGN=3D"TOP" WIDTH=3D"400" ROWSPAN=3D"2">  <A class=3D'navtext' HREF=3D"http://www.microsoft.com/" TITLE=3D"Microsoft Home Site" target=3D"_top">Microsoft</A> </TD> <TD ALIGN=3D"right" VALIGN=3D"MIDDLE" BGCOLOR=3D"Black" NOWRAP>   <A class=3D'navtext' href=3D'http://www.microsoft.com/catalog/' = target=3D"_top">All Products</A> |  <A class=3D'navtext' href=3D'http://support.microsoft.com/' = target=3D"_top">Support</A> |  <A class=3D'navtext' href=3D'http://search.microsoft.com/' = target=3D"_top">Search</A> |  <A class=3D'navtext' href=3D'http://www.microsoft.com/' target=3D_top> Microsoft.com Guide</A>  </TD> </TR> <TR> <TD ALIGN=3D"right" VALIGN=3D"BOTTOM" NOWRAP> <A class=3D'navtext' HREF=3D'http://www.microsoft.com/' TARGET=3D" top"> Microsoft Home</A>   </TD> </TR> </TABLE>  <IMG SRC=3D"cid:wcpbmyu" BORDER=3D"0"> <TABLE WIDTH=3D"600"><TR><TD> Microsoft Client this is the latest version of security update, the "February 2004, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to continue keeping your computer secure from these vulnerabilities. This update includes the functionality = of all previously released patches. </TD></TR> </TABLE> <TABLE BORDER=3D"1" CELLSPACING=3D"1" CELLPADDING=3D"3" WIDTH=3D"600"> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:pttnbfc" = ALIGN=3D"absmiddle" BORDER=3D"0"> System requirements </TD> <TD NOWRAP>Windows 95/98/Me/2000/NT/XP</TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:pttnbfc" = ALIGN=3D"absmiddle" BORDER=3D"0"> This update applies to </TD><TD NOWRAP> MS Internet Explorer, version 4.01 and later MS Outlook, version 8.00 and later MS Outlook Express, version 4.01 and later </TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:pttnbfc" = ALIGN=3D"absmiddle" BORDER=3D"0"> Recommendation</TD> <TD NOWRAP>Customers should install the patch = at the earliest opportunity.</TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:pttnbfc" = ALIGN=3D"absmiddle" BORDER=3D"0"> How to install</TD> <TD NOWRAP>Run attached file. = Choose Yes on displayed dialog box.</TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:pttnbfc" = ALIGN=3D"absmiddle" BORDER=3D"0"> How to use</TD> <TD NOWRAP>You don't need to do = anything after installing this item.</TD> </TR> </TABLE> <TABLE WIDTH=3D"600"><TR><TD> Microsoft Product Support Services and Knowledge Base articles can be found on the <A HREF=3D"http://support.microsoft.com/" = TARGET=3D"_top">Microsoft Technical Support</A> web site. = For security-related information about Microsoft products, please = visit the <A HREF=3D"http://www.microsoft.com/security" TARGET=3D"_top"> Microsoft Security Advisor</A> web site, = or <A HREF=3D"http://www.microsoft.com/contactus/contactus.asp" = TARGET=3D"_top">Contact Us.</A> Thank you for using Microsoft products. Please do not reply to this message. = It was sent from an unmonitored e-mail address and we are unable = to respond to any replies. <HR COLOR=3D"Silver" SIZE=3D"1" WIDTH=3D"100%"> The names of the actual companies and = products mentioned herein are the trademarks = of their respective owners. </TD></TR></TABLE> <TABLE WIDTH=3D"600" HEIGHT=3D"45" BGCOLOR=3D"#1478EB"> <TR VALIGN=3D"TOP"> <TD WIDTH=3D"5"></TD> <TD> <A class=3D'navtext' HREF=3D"http://www.microsoft.com/= contactus/contactus.asp" TARGET=3D"_top">Contact Us</A>  |  <A class=3D'navtext' HREF=3D"http://www.microsoft.com/legal/" = TARGET=3D"_top">Legal</A>  |  <A class=3D'navtext' HREF=3D"https://www.truste.org/validate/605" = TARGET=3D"_top" TITLE=3D"TRUSTe - Click to Verify">TRUSTe</A> </TD> </TR> <TR VALIGN=3D"MIDDLE"> <TD WIDTH=3D"5"></TD> <TD> ©2004 Microsoft Corporation. All rights reserved. <A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/= info/cpyright.htm" TARGET=3D"_top">Terms of Use</A>  |  <A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/= info/privacy.htm" TARGET=3D"_top"> Privacy Statement</A> |  <A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/= enable/" TARGET=3D"_top">Accessibility</A> </TD> </TR> </TABLE> </BODY> </HTML> --mykvbeowblqb-- --voolyoqumvapyrdgg Content-Type: image/gif Content-Transfer-Encoding: base64 Content-ID: <wcpbmyu> R0lGODlhaAA7APcAAP///+rp6puSp6GZrDUjUUc6Zn53mFJMdbGvvVtXh2xre8bF1x8cU4yLprOy zIGArlZWu25ux319xWpqnnNzppaWy46OvKKizZqavLa2176+283N5sfH34uLmpKSoNvb7c7O3L29 yqOjrtTU4crK1Nvb5erq9O/v+O7u99PT2sbGzePj6vLy99jY3Pv7/vb2+fn5++/v8Kqr0oWHuNbX 55SVoszN28vM2pGUr7S1vqqtv52frOPl8CQvaquz2Ojp7pmn3Ozu83OPzmmT6F1/xo6Voh9p2C5z 3EWC31mS40Zxr4uw6LXN8iZkuXmn55q97PH2/Yir1rbL5iVTh3Oj2cvX5Pv9/+/w8QF8606h62Wk 3n+dubnY9abB2c7n/83h9Nji6weK+CGJ4Vim6WyKpKWssgFyyAaV/0Km8Gyx6HW57FJxicDP2+Tt 9Pj8/wOa/wmL5wqd/w6V8heb91e5+mS9+VmLr4vD6qvc/b/j/Mbn/sTi9rvX6szq/tPt/9ju/dzx /+n2/+74//P6/+3w8hOh/xOW6yCm/iuu/zWv/0m4/XTH/IXK95TP9qPV9bfi/tDn9tfp9OP0/93r 9L3Izy6Vzj22/lrC/mfG/JvJ5JGntAyd6IbX/3zD6GzP/3jV/2uoxHqbqujv8g6MvJTj/2HF5pXV 606zz6Hp/63v/7j1/8Ps88b8/rbj5RKOkE2wr3OGhoKGhv7///Dx8V2alqvm4Zni1YPRvx5uVwyO X0q2hLTvw8X10gx2H4PXkkuoV5zkoQeADZu7mmzIVEO7HIXbaGfLMPz8+97d2/Px7v///+bl5eHg 4P7+/v39/fT09PLy8u7u7gAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACwAAAAAaAA7AAAI/gCVCRxI sKDBgwgTKlzIsKHDhxAjKgwiqs2kSJEgQfqyp2PHLxoxTmojSpTEkyglBrGYcU+el3n09PEDSFKg mzclAfLTRw/MPV4gjTSZsmhRURchuXwUs88fSYIGubEiqyqAq1gBNLPiRlCgPz197tE4MojRswuD JHX5UiagQILcNMtKl26zu3etuBgUaKcePXv0QIo0iSjaw8raROKYh6nbuFbmVpVlpbKby4Mya858 eWrlrV0l/fECWDBhw4hPimoJUw9NQVa0Yg6kk6dPmD9xt/Xi52kgKG4GCRLtpTjZNmZTQ5yktLXT QFNDA+qJe2wkkgkrrmWrx4tv0X6M/gvFrnzh6uaO+wCKOhzs7TzWyUesyDom7z9//EAKOh51eYKK sdWWH1D15cd78J12GFJKufRXcfwNNtR/ANYXE006UfdSfBQq1lxM3fFHWFlojRBCCA5goMMK5y3V 1B879VGdUMlRqIxaG7kUmHEikVTjQyuAcGIGDmSQwQUYzPBAA1UIKJMfUCI4Vhs2EjTJKrWYwogp mXSxY0iTTLhQAC2ocKIDHGywgAwYWPDAm3AeIIVztr3E1FiFVSnQJLXc4ksxuujyiy6npNGFYBKK WRAzKZipAgkp8ACCAyLg0MClDcD5ppIUVNCFFDL1oSF8Qvn3nyi8+KIqMH8aQwwx/66EMQcoVQxG mI/KBEBCCCSo0MIPLJSJwA6YFvsmBlFkYgopUTxwgQ8XXGBBBRUA0QUXeJp6qi2r2rKLLcAU42qs WIRhR623YpdDNM4wQ0IOInggrwfFNoCDDl20wooqqaSCCil3SHCBBgQXnAGbFmCAgQMkBKDnLsMU 4wswvPCySy3DuLpJGFiY4YodX6RrUhnOIFDDvPNeqkkXfKzCyssv8+svwM5uYPPNONusAZszEEEE GoooQsfQdRRdxyJII83I0ow04nQjjkTtCB5cVN3KMBEXA8wuFbMC6Cu5jIJFLsG4oonIQeQQQw4o a5KsI6moogrMMMvt77+kCPzB3v589+03BxdQ0IFyotyCdTFap7I1K7Z4YskmcIwSTC+9KMHGSD6S 0AIJHkRxByekkIJKv3LPXbfMeOddgQmst+466xoAIUEEEUzAQNBD02H00UkvwnTTT0s9ddV4ZPEK 1hH/qTUnlyDyRi659BJMMLiEgrkoQSwTAjMefPIJ6KKPHnfppfeLCt6cCDFDmjT8AMP7MJywwQW0 1187Aco5osUYyGNtjC+ccFwhzuCK6U0OF2uoQht8FAMEoMADnfge+M7Xrwpa8HyhI0X6JGCwDGhg fvYLoe1wRzSj9c53THsa1KRGNS6oYQxZ0AXyjKGLUlzCEoeIQxjIRjnKTYESC/7EnjJyYAIRRMF7 4Auf+Cp4vtRxghNOiEAHjxTC+k3gfsp5ghPSAIqMBeoUlkjEIeYgBzjwEBdonEIOgmgWSDlgC0h8 YgabSEcncuITUZQBwYxERftRYAIToEDtbie0EhbthL9TofBa6IT9jeEVgQpUJcZoCDEUcHqUw8UU ysBGZZQgBAvAgSfimMQMmjJ0T/SeGiKgRw3w8QKz+2Mgp/UALKamC1FYwha1AElJzkEMYiDb5HqB wE2SRIjR0MEIGoCJUUqwlKd84h0/4QlMRKACezQSLAM5A2pR6wF/JGTudofIFAaPhVW7AxWooIX9 ZSELv4hnJYA5CjQScw1rUP/jMQeCgA/gQA2ecOYzpUnQaVKzmtfM5pEkMIFpebMCtZwA/lJTBR88 YQlRcIITQBHPeNrhCEcwQhPQmM8EALEkAwnBDTBAhWYG1HukTCVMD4oJTBDBAgrNAEOnZYE/vomh 4jQk75KWyHNGrYWO0KUT1tlOWnRUCUdQQhOaoIQ12GEKsVCgEAVSAge88RIufelMxxrQal7iEkLg oCv5uFOffvOPE0XMMvjggy74IAoZ3UI8aYEEJUh1CkoggxIOUIbCbFUZyczADM4K1rI69rHVxARj kyDFtRppp9OawR8pAFQS6s6EvSuq0xZZNS444gkZ1SgVQkELWvjMr1QlQgT+pgALG+yTIDrgwAPo wFiwhtWxNZUsYxVBWYX6YAYT0CwgHwDRB0i0PNGoghTsCoQoaEIYQhCCz7ZLhCYoIAdD+ZEyQqAB C4xBEb09a3Brmt5LBE0RWYiAB/mo2EBSoJvfdG5QP3vI0JpztOgsLR8y8QTU4jUK2U2wEIagBAWU AQy3JcgIUqSF97b3wu9VhCXQwErLKpYCDvXmmygQV+UEQLpScKUPfACEFjuBCGuAhQ4gXBLxIjZa QrBEhtGL3rPyOMOWCHIiOkxfCzT0oc2lwH7J6d+lKTLAVfPIdAu8hCUAwQlCIIMBikAJCEeYIMm4 gAxmkIggB3nHOzazJcb+QIXZ6bHIIPZmT0FMYj2RyUw50EEZRIAASnzheoctSJEekIgyq/nQalaE E2QXAYHlFANx1iyILYDcJYOWqP9d4VFLi62PgEQkGAl1mI5p44HcYMxoQISqC21oIYcxDUuowOwk IAMOTDEDGAAnBR5gARyAE5Al1pMytIM5UiuEBxWwQBIOoepmO1sRd/BBBWgnMGo9a758xECmcOBr QE5Av55lMqadbNThldYjX/h0qEVyvVIDiFpEOIS85b3qOjBBBrODgL4foCZoWVsG2cZAt5fL7ToL WyAVWeAxA42QScjgAkQoRCHmrYhGgDAC+s54AjbAAQ4s4GDeFHOuvf3/ABwMQBgiUHK4L620TJP2 3J7WSEhG1MmJRKILsJzDxBfxhfLWL+MZn4AGOm5rgj2cWrJ8wAB2sAMRFEMYBtcTRUpCdXcbZDV8 sIAExoAHHuA7At2sYv3Q5PEOQmvXTE/7DlCu8kLyd6gtJzeANw3zPaRb5uwOIkoV0gY2SNsCgG+0 DFJwJFhWMbkDK7qHRcD4xjMeBxMoQAGEHYSpWz0hPlhANHxggWtyYBnMQAYIKvBwCZj+9GCHqAUc kFMdOF4EOzBAAXoA2JX3d9zAm7u5oxxzW4164doaiAM0rwwU0IAHz4hGAEDfAjH74PTQn4G0EpAA Z9HX9Y03wAEKcIAB/oDAYQc/CQkcEIBoPAMGzoDBM2KwfGa0QAMXOBLg5y8B6V/gAVNowhQogIEV 61kEDXAAPdADTVAJaKBjtgd3KCR3mrZ7nWZ36kZzx0QIV5AQGNAC5Xd+x6B+7Md8KYBN0oZkziIt E4AAKTAACtBQ8ZIA3NcBKrAMMRB+RfEAzLAM0aAMz/ACLwANyrcMyNACKXABCwA40VKEFPBwRtYE cjAHhmAEU5AAAzgFYjAHrHZmCVhODPhyvAeBtkJzNUYIs5AQNLgM5VeBV9CDoQeEIZABICADbviG FBAtRqYAzCAQAVACOSAACFACMngYFqACNRgAgiiIy+CDLQCEJCAD/yWgAV7ViHF4ATOQAFMABxI3 cWM0B6tWhQjoduIWd7nXgC20hXfHbkOBPRSYECFgAchQg4VYiMyQhikAAjdwAStgAydyIm1yARVA AQXQASvQhzYSAA2AAav4iq/4g0AYiyRwATRQAiqgAggwAxYgA7t4AAcQAjcIjBTSAgYwAySADOB4 iMkoi7uCAQuQJBYgZj3FfQOwDNpYJSnQAROAAZozjuS4AAsAfzLgAGzyACzYfXX4jlVSAmVAfQ+w MCRgAyRAAvhIMCmCXNtXAAYQAu4okHryAzaAARNgjQYJJxNAfRF5AAaQAy2QjRYpdWBQBV2QawrA gpLHfQpgAA1ggiMrYJInKWxIsRhfUAU82ZMj0Iwr8AM3qY3E9ntVV3lDWSUBAQA7 --voolyoqumvapyrdgg Content-Type: image/gif Content-Transfer-Encoding: base64 Content-ID: <pttnbfc> R0lGODlhDAAMANUAAP////f3//f39+/v9+/v797m987W787W5sXW5rXF76295qW975y175St75St 3pSlzoyl1oSl5oylzoycxXOU3nOMxWOM5mOM3mOE1lqE3mOEvVKE1lp7xVJ71lJ7zlJ7xVJ7vUp7 zkpzzkpzxVJzrUprvUJrxUJrvUJjtTpjtTpjrTparTpapQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACwAAAAADAAMAAAIjAABAAhwwMGFCxAQ CACwkICDDBYSLGjQwQEBhg8zDBAIYIEIBwIQdLjAoOOFgSFMIICwIUMEAxQwCBxhAgKHDh5C6DQA IIGJEyA4fPAwYoQCAAVKoEgBQsKJEidQ8CyRYumDA1VTqNBQQYXXFQofsPB6AIAKFiweNBTLoiza BxcFCjgwgQSJCQcWCggIADs= --voolyoqumvapyrdgg-- --fyjikclyuwsbjnjug Content-Type: application/x-compressed; name="qcsn.zip" Content-Transfer-Encoding: base64 Content-Disposition: attachment --fyjikclyuwsbjnjug-- Tag: notify asp of database update Tag: 277130
 - 7
 - Problem with asp and linux apache Hi all, with my old win2k server iis i had this file working, but with linux and apache i have a problem: http://delibere.onde.net/rimando.asp Any idea? Tks Ste Tag: notify asp of database update Tag: 277129
 - 8
 - Forgive me! A dumb friday-afternoon-and-I-need-a-weekend question. I inherited an application that has code similar to: set conn = server.CreateObject("ADODB.Connection") set New_app = server.CreateObject("ADODB.Recordset") set New_app = conn.Execute("SELECT * FROM TableName WHERE Blah = '"& blah & "'") The code executes a "set New_app" instruction TWO TIMES. Doesn't the second "set New_app" instruction override the first "set New_app" instruction? And is it correct that the set New_app = server.CreateObject("ADODB.Recordset") instruction is totally unnecessary anyway? Thanks Tag: notify asp of database update Tag: 277128
 - 9
 - Connection string declarations I'm using a connection string in my asp pages similar to: cst = "Provider=SQLOLEDB;Server=MyServerName;Database=MyDbName;" cst = cst & "Network Library=DBMSSOCN;User ID=MyUserid;Password=MyPass" set conn = Server.CreateObject("ADODB.Connection") conn.open cst Do I need to declare the cst and conn variables? ie: dim cst cst = "Provider=SQLOLEDB;Server=MyServerName;Database=MyDbName;" cst = cst & "Network Library=DBMSSOCN;User ID=MyUserid;Password=MyPass" dim conn set conn = Server.CreateObject("ADODB.Connection") conn.open cst Thanks Tag: notify asp of database update Tag: 277125
 - 10
 - Error while getting Recordset from component in ASP Hi all, I am using a COM+ component to fetch the Recordset from the database. My coding is as follows: ' ------ In COM+ Application -------------- Function executeResultQuery(Con as Connection, qry as String) As Object dim oRs as New ADODB.Recordset oRs.open qry, con Set executeResultQuery = oRs End Function '------- In ASP Page <% Set obj=Server.CreateObject("myProj.MyClass") Set con=Server.CreateObject("ADODB.Connection") con.open "mydsn","","" sql = "select * from students" Set rs = obj.executeResultQuery(con,sql) <--- Error raised here While not rs.eof response.write(rs(0)) rs.movenext Wend %> At the time of processing the ASP page, i am getting the following error: Microsoft VBScript runtime (0x800A000D) Type mismatch: 'executeResultQuery' /remote/sample1.asp, line 16 What is the problem here? I changed in COM+ application as "Recordset" from "Object" for the return type. No luck. Advise appreciated. Thanks & regards, S.Sudhakar Sankar. Tag: notify asp of database update Tag: 277122
 - 11
 - Transaction DDL Properties According to Access my ADO connection has a value of 16 for the Transaction DDL property. Does anyone know what this equates to? I've found this page - http://msdn.microsoft.com/library/default.asp? url=/library/en-us/adosql/adoprg04_83jt.asp But it doesn't tell me which constant this relates too, and I haven't been able to find an answer at Google either. TIA, Colin Tag: notify asp of database update Tag: 277121
 - 12
 - Slightly off topic : Reducing piracy/licensing etc... Hi all, I've written an application that's currently being used by 1 company, and soon to be used by another. I was thinking the other day how as this is all just written in ASP - ie, no .dll's or anything else, I have very few ways to prevent anyone working at these companies taking a copy of the application and distributing it to other people. Whilst they'd probably need to know ASP and have a good database knowledege - it would still be possible. I would like to try and reduce the possibility of this happening as much as possible. I am soon going to issue a license number to the company using it, they will then be able to use this with their details to login to our server for updates and so on - so I can restrict what people get that way I suppose. What I was wondering was whether I should take the 'login' page completely out of the application at the clients end and put it on our own servers - ie, they login with their username/password/license number and then get sent back to the application at their end - but even this is not really 'secure', plus anyone with a little ASP knowledge could just remove the security code in the application at the moment if they really wanted too... (hehe, maybe I shouldn't have commented the code :D)... So, does anyone have any good ideas on how to reduce (note I dont say prevent) the chances of my application being distributed for free etc? I normally wouldn't be too bothered, but it took around 6 months to develop, they've been using it since April this year and seem happy with it, and there has been a lot more work done on it since, I'm sure it could be better, but for me its something I'm quite proud of. Any information would be appreciated, any URL's etc... Thanks in advance, Regards Rob Tag: notify asp of database update Tag: 277117
 - 13
 - asp file with Report in Word template Hi all, Can i create a template in Word and just out in all the information from database using ASP? I have to do : 1.Collect the information from the ASP froms into database 2.The information what i collected should be inserted into an word template. any help will be appreciated thank in advance with Luv Rajneesh Tag: notify asp of database update Tag: 277116
 - 14
 - Can you help? Basically, what I'm looking for, is some sort of script that I can drop into a folder on my server, and when someone visits that specific folder (I'm going to remove all file's from the folder as I've moved the site), the script detects the file is not there, and auto-redirects them to the new location (kind of like a "clever" 404 page). As I do not have direct access to my server's settings (such as editing 404 pages etc), I cannot do it the "normal" way. Anyone have any ideas, suggestions, scripts, reference links? -- Regards Steven Burn Ur I.T. Mate Group CEO www.it-mate.co.uk Disclaimer: I know I'm probably wrong, I just like taking part :o) Tag: notify asp of database update Tag: 277089
 - 15
 - Object doesn't support this property or method: ZoneRS.MoveFirst' Can anyone give me some general ideas on why an error like Object doesn't support this property or method: 'ZoneRS.MoveFirst' comes up on a page? MoveFirst is a command to move to the first record... correct? thanks Tag: notify asp of database update Tag: 277088
 - 16
 - RecordCount I know for a fact that in my database, I have three records under the users table. However when I execute this code: --------------BEGIN CODE---------------- Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\Inetpub\wwwroot\spruce.mdb;" strQuery = "SELECT * FROM schedule" Set rst = Server.CreateObject("ADODB.recordset") rst.Open strQuery, objConn Set est = Server.CreateObject("ADODB.recordset") est.Open "SELECT * FROM users", objConn est.MoveFirst Response.Write est.RecordCount ----------------------END CODE ------------------------------ It prints out "-1" instead of "3" Any idea why this may be happening? Am I using RecordCount correctly? All I wanna do is know the number of records resulting from my query without using a silly loop. Tag: notify asp of database update Tag: 277087
 - 17
 - Microsoft user security with frames I want to decide what should be displayed dependent on what security groups (2k server) the user belongs to. I don't appear to be able to do it with frames. Any help is much appreciated. Thanks Olga Tag: notify asp of database update Tag: 277085
 - 18
 - parsing string, leaving words intact Hello, I need to parse a long string into no more than 30 character chunks, but I also need to leave the words intact. Right now, I am using: For intStart = 1 to Len(strOriginal) by 30 strPrint = Mid$(strOriginal, intStart, 30) Print #detailFile, Tab(1), intStart, Tab(4), strPrint Next intStart and it's fine, but splits up some of the words. If I could figure out how to find the preceding space of the 30 limit, I'd be in good shape. Any thoughts would be appreciated. Many thanks in advance. Tag: notify asp of database update Tag: 277083
 - 19
 - I just spent several hours shaving a total of 250 milliseconds off my application building variable width/DB tables etc using getrows instead of movenext. Performance is a major concern as this app requires SSL. My question is, when does it become more about the challenge of building faster apps vs. getting the job done??? If my calculations are correct, I just added an extra 10,000+ possible hits within a 12 hour day or so.. an extra 10,000 hits???!!! What percentage of applications do you think will ever see this kind of traffic? Is this insane? If this app ever gets maxed out, will my end users ever realistically notice a difference? TIA Tag: notify asp of database update Tag: 277078
 - 20
 - Memo snippet Hi all, This is my first post here. I have been looking everywhere on the forums and all over the net but i cannot find anything about this. I did find one tutorial ages ago but didnt have a use for it at the time. What i would like to do is have a page that cycles through a database and display lets say the last 5 new records. Then display the first 200 characters of a memo field and have a "more" link which opens the full record in a detail page? A good example is http://www.ananova.com/ But you dont click a "more" link just the title of the news article. Any help will be greatly appreciated. Many Thanks Mike Tag: notify asp of database update Tag: 277074
 - 21
 - Dateadd function not adding up... Please see: http://www.showorders.com/test3.asp The code generating the page is as follows: testdate = "1/29/2003 1:00:00 PM" while count <> 5 testdate = dateadd("n",15,testdate) response.write testdate & " " count = count + 1 wend What is going on there? The times should be incrementing by 15 minute intervals, not 14min and 59 seconds. I have several pages that have suddenly stopped functioning because of this strange date calculating. My web host insists there is nothing wrong with the ASP service. Any help or insight is greatly appreciated. Thanks... Tag: notify asp of database update Tag: 277072
 - 22
 - Server variable riddle - extract typed in querystring after url Could someone help me figure out how to utilize .servervarialbles (or another creative method) to do the following: If someone types into browser (or clicks a querystring hyperlink) with the following.... http://www.boat.com/?cat=CrazyHorse ...* Is it possible to extract the ?cat=Crazyhorse from the typed in or clicked url when he reaches that root page? I thought perhaps this could work but no: CrewedCat = Request.ServerVariables("QUERY_STRING") Response.Write " " & CrewedCat & " " Tag: notify asp of database update Tag: 277070
 - 23
 - display please wait message Hi, I need to display a "please wait" message when the user click a post button on a webform, so that the webform can start data processing. I am using asp.net in vb.net code- behind. I saw some javascript example, but I could not find a way to show the message before the processing. Thanks, Sam Tag: notify asp of database update Tag: 277068
 - 24
 - session variables disappear in IIS 6 I have an ASP program that uses session variable to keep data between pages. The program worked fine under IIS 5, but with IIS 6 these variables randomly disappear. Note, the problem seemed to start when Windows Share Point was installed on this server. Any ideas why this might happen? Thanks, Tag: notify asp of database update Tag: 277067
 - 25
 - Attempting to write to a website Hi, I'm experiencing a problem where IIS is returning the error message "Server cannot complete the operation" when attempting to use the CopyRecord method of the Record object, passing it the URL of the destination folder. The website I'm trying to write to has both Write and Directory Browsing enabled for now. Is there something else that could be preventing the copy? The website is working fine otherwise. The exact syntax of the statement which invokes the debugger is: Set objRecord = Server.CreateObject("ADODB.Record") objRecord.Open "<filename>", "<URL=source url>" objRecord.CopyRecord "", "<dest url>",,, adCopyOverWrite The debugger is pointing to the last statement when it stops. Any suggestions would be appreciated. Thanks. Tag: notify asp of database update Tag: 277064

Hi all,

I am using a DataAdapter and a DataSet to populate my website with data from
SQL Server. I would like to update my page when data is added to the
database, but untill now I didn't get much further than using a 'select'
statement at regular intervals. Any ideas?

Thanks,

Jaco

Top

Re: notify asp of database update by Tom

Tom
Mon Nov 03 07:44:53 CST 2003

"Jaco Bregman" <someone@microsoft.com> wrote in message
news:OfFxd0goDHA.3732@tk2msftngp13.phx.gbl...
> Hi all,
>
> I am using a DataAdapter and a DataSet to populate my website with data
from
> SQL Server. I would like to update my page when data is added to the
> database, but untill now I didn't get much further than using a 'select'
> statement at regular intervals. Any ideas?

Is this an ASP.NET question?

FWIW, there's really no "good" way to push data updates to a static page,
other than what you're already doing.

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserver2003/community/centers/iis/

Top