Wednesday, 24 September 2008
|
| Preview file from link? Betina Andersen 11:03:44 |
| | I have a page with links to different files (doc, pdf, jpg, tiff, xls
etc.) - now I am supposed to let the user preview them by holding the mouse
over a link, somewhat like Vistas function when you hold the mouse over a
program in the taskbar it pops up - can this be done i asp and how?
Regard Betina
|
| |  7 answers | Add comment |
Tuesday, 23 September 2008
|
| Number of Views for a Link Error Please Please Please Help. iahamed via WebmasterKB.com 09:37:01 |
| | Hi all,
I Need to add a "Number of Views to a Link" to display in the grid.asp (which
the projects starts from iis) page when some one wants to edit the db, by
this way I can see how many times the Link is accessed. It gives me an error
styled,
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or
ordinal.
/views/edit.asp, line 44
I have made some error in the edit.asp code where I have added the count
value.
Line 44 edit.asp
'This is for the number of Views or Hits the link got Code
rs.Execute("UPDATE salinfo SET ClickCount = ClickCount + 1 WHERE ID=" &
rs("ID"))
In the DB I have created a feild named: ClickCount as a Number in the table
salinfo,
I am stuck with the count function method can Some one Please Help.
The counter should Display when Some one wants to Edit the Info in the
grid.asp
--------------------------------------
grid.asp code as follows:
<%
' Generates a list of uploaded files
Response.Buffer = True
' Connection String
Dim connStr
connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath
("sal.mdb")
%>
<html>
<head>
<!-- Grid.asp-->
<title>:The Opening File for Views:</title>
</meta>
<link href="style.css" rel="stylesheet" type="text/css" />
<script language="Javascript1.2">
<!--
function elimina()
{
return confirm("Are you sure you want to delete this record?");
}
-->
</script>
</head>
<body topmargin="5" leftmargin="0" marginwidth="0" link="#143347"
vlink="#2E4B5B" alink="#2E4B5B">
<table border="0" width="580" cellspacing="0" cellpadding="0"
id="table4" height="174">
<tr>
<td width="545" colspan="2" height="32">
Views</td>
</tr>
<tr>
<td width="517" height="45" valign="top">
</td>
<td width="63" height="142" valign="top" rowspan="2">
<p> </td>
</tr>
<tr>
<td width="517" height="97" valign="top">
<div align="center">
<table border="1" width="446" id="table16" height="49"
cellpadding="0" cellspacing="0" bordercolorlight="#F8F8F8"
bordercolor="#E6E6E6">
<tr><td valign="top" height="31"> </td>
<td valign="top" height="31" width="74"></td>
<td valign="top" height="31"></font></td>
<td valign="top" height="31" colspan="3">
<p align="center">
<a href="input.asp">
<img border="0" src="images/add.gif" width="88"
height="24"></a></td>
</tr>
<tr>
<td width="88" height="24">
<b><font face="Arial" size="2"
color="#838383">Name</font></b></td>
<td width="88" height="24">
<b><font face="Arial" size="2"
color="#838383">Position</font></b></td>
<td width="88" height="24">
<b><font face="Arial" size="2"
color="#838383">Salary</font></b></td>
<td width="27" height="24"><p align="center">
<b>
<font face="Arial" size="2" color="#838383">Age</font></b></td>
<td width="30" height="24"><p align="center"> </td>
<td width="116" height="24"><p align="center"> </td>
</tr>
<tr><% Dim rs
Set rs = Server.CreateObject("ADODB.Recordset")
' opening connection
rs.Open "select [ID],[DBName],[DBposition],[DBsalary],[DBage],
[ClickCount] from salinfo order by [ID] desc", connStr, 3, 4
While Not rs.EOF%><td width="88" height="24"><font color="777777"><span
style="font-size: 8.0pt; font-family: Arial"><%=rs("DBName")%
</a></span></font></td> <td width="88" height="24"><font color="777777"><span style="font-size: 8.
0pt; font-family: Arial"><%=rs("DBposition")%></span></font></td>
<td width="88" height="24"><font color="777777"><span style="font-size: 8.
0pt; font-family: Arial"><%=rs("DBsalary")%></span></font></td>
<td width="27" height="24"><font color="777777"><span style="font-size: 8.
0pt; font-family: Arial"><%=rs("DBage")%></span></font></td>
<td width="30" height="24" bgcolor="#F6F6F6">
<p align="center"><a href="erase.asp?ID=<%=rs("ID")%>"onClick="return elimina
();"><img border="0" src="images/del.gif" width="19" height="19"></a></td>
<td width="116" height="24" bgcolor="#F6F5F5"><a href="edit.asp?ID=<%=rs("ID")
%>"><span style="font-size: 8.0pt; font-family: Arial">Edit</span><img
border="0" src="images/edit.gif" width="19" height="19"><span style="font-
size: 8.0pt; font-family: Arial">(views: <%=rs("ClickCount")%>)
</a></span></td>
</tr><%
rs.movenext
'loop
wend
rs.Close
Set rs = Nothing
'connStr.Close
Set connStr = Nothing
'else
'Response.redirect "admin.asp"
'end if
%></table>
</form>
</div></td></tr>
</table>
</body>
</html>
---------------------------------
This is the Edit.asp Code:
<!-- Edit.asp-->
<html>
<head>
<title>:Views Edit:</title>
</meta>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body topmargin="5" leftmargin="0" marginwidth="0" link="#143347"
vlink="#2E4B5B" alink="#2E4B5B">
<table border="0" width="100%" cellspacing="0" cellpadding="0" id="table1"
height="49">
<tr>
<td valign="top">
<div align="center">
<table border="0" width="781" cellspacing="0" cellpadding="0" id="table2">
<tr>
<td colspan="7" height="589" valign="top">
<table border="0" width="781" id="table3" cellspacing="0"
cellpadding="0" height="450">
<tr>
<td valign="top">
<table border="0" width="580" cellspacing="0" cellpadding="0"
id="table4" height="560">
<tr>
<td width="545" colspan="2" height="32">
</td>
<td width="35" height="570" rowspan="4"
background="images/016rightbor.gif"> </td>
</tr>
<tr>
<td width="545" colspan="2" height="32">
Edit / and added Count Code</td>
</tr>
<tr>
<td width="366" height="19" valign="top">
</td>
<td width="205" height="509" valign="top" rowspan="2">
<p> </td>
</tr>
<tr>
<td width="366" height="506" valign="top">
<div align="center">
<%
Set rs = Server.CreateObject("ADODB.recordset")
strProvider="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.
MapPath ("sal.mdb")
'This is for the number of Views or Hits the link got Code
rs.Execute("UPDATE salinfo SET ClickCount = ClickCount + 1 WHERE ID=" &
rs("ID"))
strIDNum=Request("ID")
strQuery="select * FROM salinfo WHERE ID = " &strIDNum
rs.Open strQuery, strProvider
%>
<table border="0" width="331" id="table16" height="49"
cellpadding="2">
<tr>
<td valign="top" height="26">
</td>
<td height="26" width="165">
<font size="2" color="#003300">Modify Data</font></td><td
valign="top" height="26" colspan="2"><a href="grid.asp">View
Data</a></font></td>
</tr>
<tr>
<td valign="top" width="61">
<b>
<font face="Arial" size="2" color="#838383">Name</font></b></td><td
valign="top" width="256" colspan="3">
<form name=update action=ediddone.asp?id=<%=rs("id")%> method=POST>
<input class="inputdb" name="inpname" id="name6" size="48" value="<%=rs
("DBName")%>" ></td>
</tr>
<tr>
<td valign="top" width="61">
<b>
<font face="Arial" size="2" color="#838383">Position</font></b></td>
<td valign="top" width="256" colspan="3">
<input class="inputdb" name="inpposition" id="name7" size="48" value="<%
=rs("DBposition")%>" ></td>
</tr>
<tr>
<td valign="top" width="61">
<b>
<font face="Arial" size="2" color="#838383">Salary
</font></b></td>
<td valign="top" width="256" colspan="3">
<font color="777777"><span style="font-size: 8.0pt; font-family:
Arial"><%=rs("DBsalary")%></span></font></td>
</tr>
<tr>
<td valign="top" width="61">
<b>
<font face="Arial" size="2" color="#838383">Age</font></b></td>
<td valign="top" width="256" colspan="3">
<input class="inputdb" name="inpage" id="name9" size="48" value="<%=rs
("DBage")%>" ></td>
</tr>
<tr>
<td valign="top">
<p align="justify"> </td>
<td valign="top" colspan="2" width="179">
</td>
<td valign="top" width="71">
<input type="submit" value="Update" style="font-size: 10pt; font-
family: Arial; color: #FFFFFF; font-weight: bold; border: 1px solid #174A82;
background-color: #6599FE"></td>
</tr>
</table>
</div><p> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<%
rs.Close
Set rs = Nothing
'connStr.Close
Set strProvider = Nothing
%>
</div>
</td>
</tr>
</table>
</form>
</body>
</html>
Your Help in this regard will be highly appreciated.
Thank you.
--
Message posted via WebmasterKB.com
http://www.webmasterkb.com/Uwe/Forums.aspx/asp/200809/1
|
| | Add comment |
|
| Function to Return Stored Procedure Record Set SethM 00:34:39 |
| | I have a stored procedure that returns a record set. I want to
functionalize this so I can have multiple presentations of the same
record set. However, I can not get rs_event.open StoreProc to pass
through the function, so I can use rs_event("Title"), etc, etc. Is
this possible to do? If so how? Thanks.
Regards,
Seth
|
| | 6 answers | Add comment |
Monday, 22 September 2008
|
| lots of fake Compile errors SP1 C# ASP.NEt Randys 15:03:01 |
| | This just started when I updated to sp 1 working on a APS.net, Visual Studio
2008, c# Project.
When I open a project, I get tons of Errors showing in the list 300+
if I double click on them I go to the page see the errors with the red
squigles and after about 10 seconds they go away. If i do this on on all the
pages list I can get down to zero errors. I also found as soon as I hit
Publish they go away. The big pain is if I complie and get an error (a really
one) it will show the 1 0r 2 that I have and about 20 seconds later it starts
putting al the fake errors in the list.
|
| | 2 answer | Add comment |
|
| How to use .dll extension on IIS? Sm 12:31:02 |
| | I have to develop an application (woeking on IIS) witch have to accept input
string through HTTP protocol. Client sends request: "GET
/Test/Test.dll?list_of_parameters...". I can't change this string on client
side. How to tell IIS (on XP Pro SP3) to accept this data and call some other
proccess to use this. How IIS can open a *.dll page?
|
| | Add comment |
Friday, 19 September 2008
|
| Web Config IIS 7.0 Anon 23:37:02 |
| | I am not sure if this is the right forum.
Environment : Windows server 2008, IIS 7.0
I get the 'Could not load the file or assembly 'blowery.web.httpCompress' or
one of its dependencies. The system cannot fond the file specified error.
When I comment out the line in the web config file, I get the error on the
line following that.
I have all the dll files in the bin folder.
I am attaching the web config file.
Is this a permission issue ?
Thanks in advance
<?xml version="1.0"?>
<configuration>
<configSections>
<sectionGroup name="system.web.extensions"
type="System.Web.Configuration.SystemWebExtensionsSectionGroup,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral,
PublicKeyToken=31bf3856ad364e35">
<sectionGroup name="scripting"
type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions,
Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
<section name="scriptResourceHandler"
type="System.Web.Configuration.ScriptingScriptResourceHandlerSection,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral,
PublicKeyToken=31bf3856ad364e35" requirePermission="false"
allowDefinition="MachineToApplication"/>
<sectionGroup name="webServices"
type="System.Web.Configuration.ScriptingWebServicesSectionGroup,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral,
PublicKeyToken=31bf3856ad364e35">
<section name="jsonSerialization"
type="System.Web.Configuration.ScriptingJsonSerializationSection,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral,
PublicKeyToken=31bf3856ad364e35" requirePermission="false"
allowDefinition="Everywhere"/>
<section name="profileService"
type="System.Web.Configuration.ScriptingProfileServiceSection,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral,
PublicKeyToken=31bf3856ad364e35" requirePermission="false"
allowDefinition="MachineToApplication"/>
<section name="authenticationService"
type="System.Web.Configuration.ScriptingAuthenticationServiceSection,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral,
PublicKeyToken=31bf3856ad364e35" requirePermission="false"
allowDefinition="MachineToApplication"/>
</sectionGroup>
</sectionGroup>
</sectionGroup>
<sectionGroup name="blowery.web">
<section name="httpCompress"
type="blowery.Web.HttpCompress.SectionHandler, blowery.Web.HttpCompress"/>
</sectionGroup>
<sectionGroup name="applicationSettings"
type="System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089">
<section name="SMWeb05.Properties.Settings"
type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false"/>
</sectionGroup>
</configSections>
<appSettings>
<add key="Login.BruteForceDetection.TriesBeforeBlock" value="10"/>
<add key="Login.BruteForceDetection.BlockTime" value="5"/>
<add key="MailServiceAddress" value="IPC"/>
</appSettings>
<connectionStrings/>
<!-- This adds an http Compression Module to SmarterMail.
see http://www.blowery.org/code/HttpCompressionModule.html for more
info
-->
<blowery.web>
<!--
acceptable values:
<compressionModule preferredAlgorithm="deflate|gzip"
compressionLevel="high|normal|low|none"/>
gzip always uses compressionLevel="normal"
-->
<httpCompress preferredAlgorithm="deflate" compressionLevel="low">
<excludedMimeTypes>
<add type="image/gif"/>
<add type="image/jpg"/>
<add type="image/jpeg"/>
<add type="application/octet-stream"/>
<add type="application/vnd.syncml+xml"/>
</excludedMimeTypes>
<excludedPaths>
<add path="frmReadMail_Attachment.aspx"/>
<add path="WebResource.axd"/>
<add path="frmKeepAlive.aspx"/>
<add path="frmPrintPreview.aspx"/>
</excludedPaths>
</httpCompress>
</blowery.web>
<system.web>
<xhtmlConformance mode="Transitional"/>
<httpModules>
<clear/>
<add name="OutputCache" type="System.Web.Caching.OutputCacheModule"/>
<add name="Session" type="System.Web.SessionState.SessionStateModule"/>
<!-- <add name="FormsAuthentication"
type="System.Web.Security.FormsAuthenticationModule" />
<add name="RoleManager" type="System.Web.Security.RoleManagerModule" />
<add name="UrlAuthorization"
type="System.Web.Security.UrlAuthorizationModule" />
<add name="FileAuthorization"
type="System.Web.Security.FileAuthorizationModule" />
<add name="AnonymousIdentification"
type="System.Web.Security.AnonymousIdentificationModule" />
-->
<add name="ErrorHandlerModule"
type="System.Web.Mobile.ErrorHandlerModule, System.Web.Mobile,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
<add name="ScriptModule" type="System.Web.Handlers.ScriptModule,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral,
PublicKeyToken=31bf3856ad364e35"/>
<add name="CompressionModule" type="blowery.Web.HttpCompress.HttpModule,
blowery.web.HttpCompress"/>
<add name="RadUploadModule"
type="Telerik.WebControls.RadUploadHttpModule, RadUpload.Net2"/>
</httpModules>
<httpHandlers>
<add verb="*" path="EditorStyleSheetHandler.ashx"
type="SMWeb05.HelperClasses.Handler.EditorStyleSheetHandler"/>
<add verb="*" path="StyleSheet.ashx"
type="SmarterTools.Web.HttpHandlers.CommonCssHandler, SmarterTools.Web"/>
<add verb="*" path="Javascript.ashx"
type="SmarterTools.Web.HttpHandlers.CommonJSHandler, SmarterTools.Web"/>
<add verb="*" path="TempResourceHandler.ashx"
type="SmarterTools.Web.HttpHandlers.TempResourceHandler, SmarterTools.Web"/>
<remove verb="*" path="*.asmx"/>
<add verb="*" path="*.asmx" validate="false"
type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions,
Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add verb="*" path="*_AppService.axd" validate="false"
type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions,
Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add verb="*" path="Telerik.RadUploadProgressHandler.aspx"
type="Telerik.WebControls.RadUploadProgressHandler, RadUpload.Net2"></add>
<add verb="GET,HEAD" path="ScriptResource.axd"
type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions,
Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
validate="false"/>
</httpHandlers>
<pages validateRequest="false" buffer="true">
<controls>
<add tagPrefix="STWC" namespace="SmarterTools.Web.Controls"
assembly="SmarterTools.Web"/>
<add tagPrefix="SMWC" namespace="SMWeb05.UserControls"
assembly="SMWeb05"/>
<add tagPrefix="UC" namespace="SMWeb05.UserControls" assembly="SMWeb05"/>
<add tagPrefix="asp" namespace="System.Web.UI"
assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral,
PublicKeyToken=31bf3856ad364e35"/>
</controls>
</pages>
<compilation debug="false">
<assemblies>
<add assembly="System.Web.Extensions, Version=1.0.61025.0,
Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add assembly="System.Design, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=B03F5F7F11D50A3A"/>
<add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=B77A5C561934E089"/>
</assemblies>
</compilation>
<urlMappings enabled="true">
<add url="~/Main/frmMessagesX.aspx" mappedUrl="~/Main/frmMessages.aspx"/>
<add url="~/Main/frmMessagesAdv.aspx" mappedUrl="~/Main/frmMessages.aspx"/>
</urlMappings>
<authentication mode="Windows"/>
<httpRuntime maxRequestLength="10240"/>
<customErrors mode="Off" defaultRedirect="frmError.aspx"/>
</system.web>
<system.web.extensions>
<scripting>
<scriptResourceHandler enableCompression="false" enableCaching="true"/>
</scripting>
</system.web.extensions>
<!--<system.webServer>
<validation validateIntegratedModeConfiguration="false"/>
<modules>
<add name="ScriptModule" preCondition="integratedMode"
type="System.Web.Handlers.ScriptModule, System.Web.Extensions,
Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
</modules>
<handlers>
<remove name="WebServiceHandlerFactory-Integrated" />
<add name="ScriptHandlerFactory" verb="*" path="*.asmx"
preCondition="integratedMode"
type="System.Web.Script.Services.ScriptHandlerFactory,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral,
PublicKeyToken=31bf3856ad364e35"/>
<add name="ScriptHandlerFactoryAppServices" verb="*"
path="*_AppService.axd" preCondition="integratedMode"
type="System.Web.Script.Services.ScriptHandlerFactory,
System.Web.Extensions, Version=1.0.61025.0, Culture=neutral,
PublicKeyToken=31bf3856ad364e35"/>
<add name="ScriptResource" preCondition="integratedMode"
verb="GET,HEAD" path="ScriptResource.axd"
type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions,
Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
</handlers>
</system.webServer>-->
<applicationSettings>
<SMWeb05.Properties.Settings>
<setting name="SMWeb05_ProductInfo_ProductInfo" serializeAs="String">
<value>http://www.smartertools.com/billing/services/ProductInfo.asmx</value>
</setting>
</SMWeb05.Properties.Settings>
</applicationSettings>
</configuration>
|
| | 2 answer | Add comment |
|
| RE: CreateTextFile in secure FTP folder Old Pedant 09:39:01 |
| | "Jennifer" wrote:
I have write permission on the folder, but the folder is also secured for FTP. Should I somehow pass FTP permissions in this script?
It's not relevant whether _you_ have permisson on the folder. The question
is whether IIS has permissions. ASP runs under the aegis of the IIS "user",
which is named "IUSR_xxx" where "xxx" is the name of the machine where IIS is
running.
*THAT* is the user that must have full persmissions on the folder.
|
| | 2 answer | Add comment |
Thursday, 18 September 2008
|
| WCF from C++ HayBaler 22:56:01 |
| | I have a legacy C++ application running in a non .NET environment, that needs
to talk to a WCF C# web service. Is this possible, and how?
|
| | Add comment |
|
| Problems using WinHttp.WinHttpRequest.5.1 to access an https (ssl)
page on an Oracle-Application-S Brian Pitt 19:31:51 |
| | Hi
I am trying to use WinHttp.WinHttpRequest.5.1 to access an https (ssl)
page on an Oracle-Application-Server-10g and I keep getting a
-2147483638 error. I am able to use the exact same script to access
https pages on other servers and I can access http requests on oracle
application servers.
The problem is isolated to accessing https pages on oracle application
servers and I have now come up against this problem with three of my
clients who are running oracle servers so it looks like there is
something about WinHttpRequests that the oracle servers doesnt like. I
have tried setting all the headers in the WinHttpRequest to match the
headers sent when accessing the site in firefox but still no luck.
If anyone has ever come across this problem and has figured out the
cause I would be really grateful if you could enlighten me.
Many thanks
|
| | Add comment |
|
| Log in and security with classic asp Jan T. 19:22:37 |
| | I wonder if anybody know a web site that has a good tutorial on this
subject.
What I want to do, is make a log in Page, and make sure that all my
pages is validating that the user is loged in until he or she logs out.
May be someone would like to give an example in this news group too?
Thank you for any help!
BTW, I am using Access 2000 and classic ASP.
Regards
Jan
|
| | 11 answers | Add comment |
|
| ASP + Crystal Report 9 on WinServer 2003 and IIS6: Blank Screen Vincent 18:53:33 |
| | We have used Crystal Report Web Viewer on ASP pages (using ActiveX),
and it works perfectly on Windows 2000 machine with IIS 5 and SQL 2K.
Now we already migrated the applications to Windows Server 2003
running IIS6, and still SQL2K. All the application works perfectly,
except for the Crystal Report. Everytime the report in ActiveX shown
blank, only the toolbar the frame shown, which means that the ActiveX
is loaded but the report cannot be shown. I check through the Windows
Event Viewer: there're warnings said:
A process serving application pool 'DefaultAppPool' suffered a fatal
communication error with the World Wide Web Publishing Service. The
process id was '3580'. The data field contains the error number. (the
number is 0000: 8007006d).
A process serving application pool 'DefaultAppPool' terminated
unexpectedly. The process id was '4708'. The process exit code was
'0x80'.
Check through log file in C:\Windows\System32\Log Files\httperr log
file:
Date/Time IP 80 HTTP/1.1 POST URL Connection_Abandoned_By_AppPool
DefaultAppPool
I have try to create new app pool, and grant to Network Service or
even Local System, but the report still shown blank. Anyone has idea/
experience? Please help.
|
| | Add comment |
|
| Decimal value setting problem (ASP & ADODB.Recordset value & MSSQL
Server & 2003 Serv Avcitamer 18:10:54 |
| | We upgraded our system and problem below occured, pleas help me...
Windows 2003 server SP1
When I set a decimal DB field value to "123,32" (using
ADODB.recordset ) updated value was ok (123.32)
Windows 2003 server SP2
Now when I set a decimal DB field value to "123,32" (using
ADODB.recordset ) updated value is (123.32)
Thanks
Systems
Windows 2003 server Enterprise SP2
SqlServer 2000 SP4
Activex Data Object 2.8~
IIS7, Classsical ASP
|
| | 6 answers | Add comment |
|
| Windows Vista IIS7 Ultimate Dosent load my ASP pages Please help. iahamed via WebmasterKB.com 13:23:28 |
| | HTTP Error 404.3 - Not Found
The page you are requesting cannot be served because of the extension
configuration. If the page is a script, add a handler. If the file should be
downloaded, add a MIME map.
It never works. Vista dosent load my ASp pages can some one help me to get
this working. I have set permitions to the wwwroot and full permisions. Still
not working.
What do I have to do to get this work?
--
Message posted via WebmasterKB.com
http://www.webmasterkb.com/Uwe/Forums.aspx/asp/200809/1
|
| | 1 answer | Add comment |
Wednesday, 17 September 2008
|
| Return value from Stored Procedure Dooza 18:06:47 |
| | I have a stored procedure that takes a number of inputs, does a bulk
insert, and then outputs a recordset. When I run the stored procedure in
Server Management Studio I also get a return value from the stored
procedure which is an INT.
I want to access this return value on my ASP/VBScript page, but do not
know how to access it.
Here is my code so far:
<%
Dim rsImport
Dim rsImport_cmd
Dim rsImport_numRows
Set rsImport_cmd = Server.CreateObject ("ADODB.Command")
rsImport_cmd.ActiveConnection = MM_aclv4test_STRING
rsImport_cmd.CommandText = "{call dbo.PriceUpdateImport(?,?,?,?,?)}"
rsImport_cmd.Prepared = true
rsImport_cmd.Parameters.Append
rsImport_cmd.Parameters.Append rsImport_cmd.CreateParameter("param1",
200, 1, 255, rsImport__vendor)
rsImport_cmd.Parameters.Append rsImport_cmd.CreateParameter("param2",
200, 1, 255, rsImport__name)
rsImport_cmd.Parameters.Append rsImport_cmd.CreateParameter("param3",
200, 1, 255, rsImport__filename)
rsImport_cmd.Parameters.Append rsImport_cmd.CreateParameter("param4",
200, 1, 255, rsImport__validfrom)
rsImport_cmd.Parameters.Append rsImport_cmd.CreateParameter("param5",
200, 1, 255, rsImport__user)
Set rsImport = rsImport_cmd.Execute
rsImport_numRows = 0
%>
There is more code above that sets the variable for each parameter.
I have tried adding this: rsImport_cmd.CreateParameter("@RETURN_VALUE",
3, 4) but I got this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done.
My stored procedure doesn't declare an output return value, which may be
the problem, but when I execute the stored procedure in server
management studio I am given a return value.
Any ideas or pointers?
Cheers,
Steve
|
| | 16 answers | Add comment |
|
| How to configure IIS7 to allow zip file uploads using classic asp? Kal 12:08:06 |
| | I recently installed Windows 2008 Server to replace a crashed hard drive on
a web server with a variety of web pages including several classic ASP
applications. One of these makes extensive use of file uploads using a com
tool that has worked for several years.
Under IIS7 doc files and jpeg files upload as before, but zip files give a
500 error. This works the same with the firewall on and off.
|
| | 10 answers | Add comment |
Tuesday, 16 September 2008
|
| Using a href onclick in asp 3.0 page Ellie 17:43:57 |
| | I am trying to cancel a href by coding onclick="return false" in my page. I
can put in a function and have a test "alert" box come up but the "return
false" never works no matter what I try. Is there a problem with that and
asp? Thanks
|
| | 7 answers | Add comment |
|
| asp Test 07:38:28 |
| | Vendor software set password field as binary in sql server 2000
I would like to write asp to check the user name and password
how can i check and match that field?
it shows errors when match with binary field
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]The text, ntext, and image
data types cannot be compared or sorted, except when using IS NULL or LIKE
operator.
|
| | 13 answers | Add comment |
|
| Re: asp:menu Bullschmidt 07:30:18 |
| | Here's a handy little frames article that might give you some ideas:
Inline Frames
http://www.yourhtmlsource.com/frames/inlineframes.html
Best regards,
J. Paul Schmidt, Freelance Web and Database Developer
http://www.Bullschmidt.com
Access Database Sample, Web Database Sample, ASP Design Tips
*** Sent via Developersdex http://www.developersdex.com ***
|
| | Add comment |
|
| ASP Access Recordset Paging Yosi 05:07:18 |
| | Hi all,
I have access database file with 2 tables,
the tables have the same columns but with different data,
and I have 2 asp files that show the content of each table with paging
recordset,
they have the same code, but only one asp works,
when I try to open the second page i got this error:
Error Type:
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support bookmarks.
This may be a limitation of the provider or of the selected cursortype.
it doesn't make sense how one asp page with the same code working,
and the other not, any idea wht it happend ?
the code:
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.mode = 3
FilePath = "C:\Inetpub\wwwroot\database.mdb"
Conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & FilePath & ";
Set RS = Server.CreateObject("ADODB.Recordset")
RS.CursorType = adOpenStatic
RS.PageSize = 5
RS.Open "SELECT * FROM table1", Conn
RS.AbsolutePage = cp
rc = 0
While not RS.EOF and rc < RS.PageSize
response.write RS("FirstName") & "<br>"
RS.MoveNext
Wend
RS.Close
SET RS = NOTHING
Conn.close
Set Conn = NOTHING
Many thanks in advance,
Yosi.
|
| | 7 answers | Add comment |
|
| Hotizontal Records Display in ASP. iahamed via WebmasterKB.com 04:07:29 |
| | Hi all,
I need to display records Horizontally, I do not know for some reason this
code gives me an error, uses an access db.
Microsoft VBScript compilation (0x800A040E)
'loop' without 'do'
/aspcodes/DisplayROwsHorizon/index.asp, line 26
Loop
I normally use the While Not objRS.EOF and close it with a Wend. Using what
ever way here it clashes with the If Statement Logic.
index.asp
</html>
<title>Hotizontal Records Display.</title>
<!--#include file="conn.asp"-->
<body>
<%
DIM mySQL, objRS
mySQL = "SELECT * FROM tblData"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open mySQL, objConn
DIM recCount
IF Not objRS.EOF THEN
Response.Write "<table width='100%'>"
recCount = 0
Do UNTIL objRS.EOF
IF recCount Mod 3 = 0 THEN
IF recCount <> 0 THEN
Response.Write "</tr>"
Response.Write "<tr><td>"&objRS("Item")&"</td>"
ELSE
Response.Write "<td>"&objRS("Item")&"</td>"
END IF
recCount = recCount + 1
objRS.MoveNext
Loop
Response.Write"</tr></table>"
ELSE
Response.Write "Sorry, there are no records in our database."
END IF
%>
</body>
</html>
------------------------------------------------------------------------
Con.asp
'Dim objRS Name is in Index so cannot redefine
'Dim objRS
set objRS= Server.CreateObject("ADODB.Connection")
objRS.Open ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="& Server.MapPath
("/aspcodes/DisplayROwsHorizon/DisRowHorizon.mdb"))
Your Help in this regard will be Highly appreciated.
Thank you.
--
Message posted via WebmasterKB.com
http://www.webmasterkb.com/Uwe/Forums.aspx/asp-db/200808/1
|
| | 3 answer | Add comment |
|
| Please advise why the following code only giving empty string no u Mmkg 04:02:53 |
| | <%
dim Conn, mysql
Set Conn= Server.CreateObject("Adodb.Connection")
Conn.open="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=D:\MDN2008\asp\db1.mdb;Persist Security Info=False"
'mysql= "insert into UserInfo(U_Name,P_Word)values('"& Request.Form("uname")
& "', '"& Request.Form("passw") &"')"
'Conn.execute (mysql)
Set Rs =Server.CreateObject("Adodb.Recordset")
Conn.BeginTrans
mysql= "insert into UserInfo([Name],PWord)values(' " &
Request.Form("txtName") & "', '" & Request.Form("txtpass") & "' )"
response.write(mysql)
Conn.CommitTrans
conn.close
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Login</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="Styles/CssStyles.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<td class="HeadingWithBackGround"><center>
Login Maintenance
</center></td>
<tr>
<td> </td>
</tr>
<tr>
<td align="center" class="Heading">To register 'Click' create Login</td>
</tr>
</table>
<table width="30%" align="center" cellpadding="="1" cellspacing="0" >
<tr>
<td width="25%" align="center"><b>User Name</b></td>
<td width="40%"><input type="text" name="txtName" ></td>
<tr>
<td width="25%" align="center"><b>Password</b></td>
<td width="40%%"><input type="Password" name="txtpass"></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td align ="Left"><input type=Submit name=btnOk value=" Create "
class=Buttons>
<input type=Reset name=btnCancel value=" Clear " class=Buttons></td>
</tr>
</table>
</body>
</html>
|
| | 2 answer | Add comment |
|
| How to use Multiple database connection using ASP Balakrishnan Dinesh 03:38:12 |
| | Hi frndz
Im developing a web application.. Here im using oracle as my
database. In each necessary page im creating database connection and
recordset then connecting to database normally as given below.
Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Dim ConnectionString
ConnectionString = "Provider=OraOLEDB.Oracle.1;Persist Security
Info=False;Data Source=WEB;User ID=userid;Password=xxxxx"
Conn.Open ConnectionString
Set recordset = Server.CreateObject("ADODB.Recordset")
-------------------------------
My question is , How to use multiple connection to connect to the
database using ASP for different user login to my web application, or
i need to configure anything in ORACLE console to perform the multiple
connection
Rgrds
Dinesh.
|
| | 1 answer | Add comment |
Monday, 15 September 2008
|
| ASP format of received xml Aoifey1234 16:38:33 |
| | I have a client who is using an asp page to receive xml files from my company.
When the client views the xml through a browser it is formatted correctly
i.e. indented properly etc.
However, the client also uses wordpad to view the xml and when using wordpad
the xml appears on one line.
Is it possible to change the settings of the asp page so that it formats the
xml correctly?
Thanks in advance
|
| | 14 answers | Add comment |
Sunday, 14 September 2008
|
| Re: How to use memcached in classic asp Bob Barrows 23:17:01 |
| | bigqiang wrote:
Memcached is a high-performance, distributed memory object caching How to use Memcached in Classic Asp? How would we know? Speaking for myself, this is the first I ever heard of
this thing. Wouldn't it be more logical to ask the people who created that
caching system?
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
|
| | 2 answer | Add comment |
|
| No event trigger after casting session variable in OnPreInit Geossl 19:22:28 |
| | Dear All,
I try to change a master page in the OnPreInit in a asp.net page.
protected override void OnPreInit(EventArgs e){
if ((bool)session["IsNew"]){
this.MasterPageFile = "~/NewMaster.master";
}
else{
this.MasterPageFile = "~/OrigianlMaster.master";
}
base.OnPreInit(e)
}
But after this, the page does not trigger any other event. I try to trace to
the problem , and when I remove the casting of the session variable,
if ((bool)session["IsNew"]){
to
if (session["IsNew"] == null)
then, everything works fine again.
Why casting a session variable will inhibit the triggering of other events
in the page??
|
| | 1 answer | Add comment |
|
