all groups > inetserver asp general > march 2004
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
date problem
Posted by dave at 3/31/2004 10:50:26 PM
Hi
I have one date/time type of field..
I' m trying to store only date in mm/dd/yyyy format using
INSERT Statement and
CONVERT(DATETIME,getdate(),101)
But still it stores both date & time in the database
field..How can I store only date in mm/dd/yyyy ???
Any help would be appreciated.... more >>
Excel connection
Posted by Andrew at 3/31/2004 8:46:18 PM
Hi,
How can I make a connection to an Excel file, and I can select the specific
fields? For example in sheet1:
A B C
1 20 change good
2 short return 50
3 order shipped 3
How can I get the value of "C2" in ASP? I want to the the c... more >>
Add C# web project to VB Web project
Posted by Brad at 3/31/2004 7:23:51 PM
I'm somewhat of a "newbie" when it comes to programming, so please bear with
me <grin>
Does this work well for combining dissimilar language web projects?
Using the "File" - "Add Project..." - "Add Existing Project..." menu items
in VS.NET?
Or is there a better way to add a "one-page data ... more >>
Site Server Catalog Search Replacement??
Posted by Kevin at 3/31/2004 5:02:54 PM
We are looking replace site server's catalog search application. We need to
crawl a public website and allow uses to search indexed pages. We need a
product to index our site and index custom meta tags we put in our pages.
What website crawling products are available in the marketplace?
Th... more >>
Disable Lazy Content Propagation
Posted by cliff at 3/31/2004 3:48:25 PM
My asp pages will not update rigth away on my Win2k3 server with IIS 6. I
have found disabling lazy content propagation but it has not worked? Has
anyone else had this problem?
... more >>
pointing hyperlink to a shortcut
Posted by aa at 3/31/2004 2:01:23 PM
Thought this question might be out of this NG's scope, there are always =
knowledgable people who might hava an answer.
A hyperlink to a shortcut to a file returnes an empty screen, and the =
source code behind this empty screen is
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">... more >>
Developersdex?
Posted by David Berry at 3/31/2004 12:40:51 PM
Hi All. I've made a few posts in the public.inetserver.asp groups and I =
keep getting these annoying emails from Developersdex telling me there =
are replys. What's up with this?
Dave... more >>
ASP Looping Question
Posted by JP SIngh at 3/31/2004 12:16:58 PM
Hi All
Please can someone help me solve this issue.
I have a database table the structure of which are given below.
Profile Table
EmployeeNumber
FirstName
LastName
ManagerNumber
The table stores the employee profile and also stores the employeenumber of
thier manager.
I want to... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Toolbar - less browser
Posted by rikesh at 3/31/2004 10:27:49 AM
Hi
I'm designing a small web application which is a table displaying live data
which updates every minute or so. This app is very small and will stay open
on a client PC's pretty much all day. So I was wondering if it is possible
to display it in a browser , without the IE toolbars, just lik... more >>
updating an excel sheet
Posted by Luc Dal at 3/31/2004 10:17:29 AM
Hello,
Is it possible for a client to update an excel worksheet sheet online ?
Thanks for your reply
Luc
... more >>
ERROR - There are too many people accessing the Web site at this time
Posted by PW at 3/31/2004 7:42:22 AM
Hi,
I'm using WinXP-Pro, ASP classic, IIS 5.0.
I regularly get this error, but I know I am the only user accessing the
website at the time of the error.
I looked it up on the MS support webiste. Their recommendation is this ...
------------------
on Microsoft Windows XP Professional... more >>
Browser caching and Back Button
Posted by jim gigurtsis at 3/31/2004 7:33:11 AM
I am trying to get the BACK button to re-post the request
to the server for IE 5+.
I have used,
Response.ExpiresAbsolute = #1/1/1980#
Response.AddHeader "cache-control", "no_store, must-
revalidate, private"
Response.AddHeader "Pragma", "no-cache"
But it brings up a page saying that t... more >>
regular expressions
Posted by jim_briers_us NO[at]SPAM yahoo.co.uk at 3/31/2004 5:41:50 AM
Hope someone can help.
I've got a page of text which I am assigning to a string. Within this
page there are special tags e.g. lots of text....<ti>dogs</ti>..lots
more text....<ti>this is a cat</ti> etc.. So I've got a long string
interspersed with these tags. Now what I need to do is get a ... more >>
Radio Button and Combo Box Dynamic Data Retrieval
Posted by davidku NO[at]SPAM rocketmail.com at 3/31/2004 4:31:14 AM
Hi,
May I know how to create data dynamically in a combo box after
clicking on a radio button ? Data are retrieved using a store
procedure from a SQL Server.
For example :
Click Radio Button 1, the combo box should contains "A", "B", "C"
Click Radio Button 2, the combo box should contains ... more >>
Use of FSObject
Posted by roberto.franchi NO[at]SPAM trainingteam.com at 3/31/2004 4:16:35 AM
Thanks a lot for every suggestion.
I'm a roockies in asp page.
I'm trying to improve a internal counter. I'he found the code to
manage it (very simple) but have problems with autorization.
I give "IUSR_name" the autorization (read, write, change, ALL) on
specific directory (phisical c:\inetp... more >>
Timeout Error Question
Posted by David Berry at 3/30/2004 11:41:00 PM
Hi All. I have a SQL Statement on an ASP page that only returns 4 =
records. When I run it in SQL Server or Query Analyzer it runs in less =
than a second. When I run it from my ASP page I get:
Microsoft OLE DB Provider for SQL Server error '80040e31'=20
Timeout expired=20
the error li... more >>
session.timeout in global.asa file
Posted by Rudi Ahlers at 3/30/2004 10:56:39 PM
Can I put a session.timeout = "45" in the global.asa file?
and if yes, under what section?
--
Kind Regards
Rudi Ahlers
+27 (82) 926 1689
Greater love has no one than this, that he lay down his life for his friends
(John 15:13).
... more >>
ASP: Building a "page grabber" to saveout text AND images?
Posted by Ken Fine at 3/30/2004 7:03:19 PM
My well-heeled clients would like a tool that I could build into a web
application that would suck down the entire contents a remote webpage and
store it on a local filesystem.
I know how to scrape textual content from places on the web using MSXML and
assorted scracping widget. That doesn't h... more >>
ASP using Access Tables with Lookup function.
Posted by Pete Casey at 3/30/2004 5:25:46 PM
Hi,
Can anyone give me a pointer here. I have a site that is working well after
first build. All the tables in the Access database are standalone, if you
like, but I wanted to try and incorporate lookup columns within the database
to try and reduce possible input mistakes. The only problem now i... more >>
Problem submitting a form from modal web-dialog
Posted by Vince C. at 3/30/2004 5:16:58 PM
Hi.
I would have liked to submit a form from a modal web dialog, i.e. a window
opened using showModalDialog() in which there is a form to submit. I thought the
dialog content would be replaced with the submitted page results but I saw a new
instance of MSIE instead.
Is this behaviour normal... more >>
FSO with Database
Posted by F NO[at]SPAM yy NO[at]SPAM Z at 3/30/2004 5:06:00 PM
Hi all
I have some difficulty to manage FSO with Database.
Actually I am building a tree view of user files and folders.
I have saved record of each file and folder with its parent id in a table
for example
Table
------------------
Name --ID--ParentID
-------------------
Root--1--0
... more >>
Looping A Form Post?
Posted by newsposter NO[at]SPAM orion-forever.com at 3/30/2004 5:01:37 PM
I'm sure this is a simple one, but I'm struggling with this idea.
Basically, I have a dataset I need to send to a vendors site. They
have a page that will accept from form posts. What I'm trying to
figure out is how to loop through and submit form data when I do not
have control of the end si... more >>
tricky SQl
Posted by Mikael at 3/30/2004 1:42:40 PM
Hi all, i have some problem to solve a sql-query. (Out off topics? I don't
know.)
I have a site (a community) with a lot of members. A member
who are logged in om my site can search for other members. A logged in
member can block any other member out.
I have these table. As u can see in bloc... more >>
ASP form problem
Posted by JP SIngh at 3/30/2004 9:50:54 AM
Hello all
I know this is a javascript questions but as most of us use javascript
within the asp I thought someone might know a quick answer to this.
What I am trying do it to set the value of my second textbox to the value in
first text box whenever the value in the first textbox changes. Bu... more >>
Getting info from a date
Posted by Fawke101 at 3/30/2004 8:13:55 AM
Hi there,
I have a field in my SQL database - dtePurchased - and the values look like
this - 24/03/2004, 35/03/2004 (UK format)
I wish to display this field in a table on my ASP page by using the
recordset object etc,,,
The problem is, i only want to display the Month from each date.
IE
... more >>
response.write
Posted by lew NO[at]SPAM saltbeefsandwich.co.uk at 3/30/2004 6:16:55 AM
I'm trying to use a value passed from a previous page, and placed in
to the variable 'pname' in to a response.write function:
<option selected> <% =rscars("" & "'" & pname & "'") %> </option>
where 'rscars' is the recordset.
Any idea how I could do this??... more >>
Event log?
Posted by DaveF at 3/30/2004 6:15:52 AM
Is there a way to enter an error in the windows event application log. An
example would be great
--
David
... more >>
What is the best way to Print?
Posted by michaaal at 3/30/2004 12:42:34 AM
I am developing an Intranet application for a business. I would like to be
able to print out certain bits of information just as regular applications
do. I realize that this is a little more difficult, and after doing
research it seems that the best way to print is to use JavaScript's
"window.... more >>
"£" displaying as "?"
Posted by Jase at 3/29/2004 10:28:19 PM
For some reason all of a sudden "£" signs are displaying as "?" when the
field is displayed.
The display code is:
<%=rs.Fields("WagesText")%>
This was working fine before, so I have no idea why it has suddenly changed.
The code hasn't altered as far as I'm aware but it is a possibility. ... more >>
ASM and XMLHTTP problem
Posted by sancee77 at 3/29/2004 7:25:24 PM
Hi
Do we need to install any package on the IIS server to work on th
Microsoft.XMLHTTP object
I have pasted a piece of code from my ASP file
-------------------------------------------------------------------
Set objHTTP = Server.CreateObject("Microsoft.XMLHTTP")
strUR
="https://secu... more >>
Using NTFS security to protect files served via asp/iis
Posted by travelling_nerd NO[at]SPAM yahoo.com at 3/29/2004 7:22:01 PM
Folks:
I have some zip files I'd like to serve to authenticated users on my
site, but would like to prevent unauthorized users from using an
absolute path to get to these zip files. For example
http://blah.com/file.zip should not be accessible directly without
authenticating. However, my curr... more >>
Script Engine Exception?
Posted by Dean J. Garrett at 3/29/2004 6:17:39 PM
Hello,
The periodic error below keeps coming up and causing our server to crash.
Once it happens, the only way to recover is to issue an IISRESET or reboot.
We've updating the scripting engine, and database engine. The ASP code is
connecting to an Access database. Is there anything that can be... more >>
OnMouseOver "Click here" Hyperlink
Posted by Fawke101 at 3/29/2004 5:13:54 PM
Hi there,
This is probably the wrong group to post this in, so apologies for that. I
figured it was such an easy question (possibly??) for you guys that i would
post it anyhow, as i could find a HTML group relevant, although im sure
there is one.
I want to have a hyperlink that when hoverin... more >>
session check
Posted by F NO[at]SPAM yy NO[at]SPAM Z at 3/29/2004 4:34:16 PM
Hi every one
How to check if client machine is allowed to create session variables or not
..
As I am facing proplem that some visitors cannot view few pages and I figure
out that if they decrease browser security then they can view.
I hope experts can understand the problem and will reply... more >>
Response.Write font size & face
Posted by PorkyJr at 3/29/2004 2:28:04 PM
Running an asp page that has the following code:
<%
response.Write MonthName(Month(date))
%>
<%
response.Write Day(date)
%>
,
<%
response.Write Year(date)
%>
I would like to modify the font size & face to be something other than
the "default" of Times New Roman. How can ... more >>
Passing variables
Posted by Kim Lots at 3/29/2004 2:02:00 PM
Hi all
I'm trying to pass two variables, but what is wrong with my code?
--------
<form name="uno"
action="validate.asp?Num=<%=Request.Querystring("Num") %>"
method="post">
<textarea name="komm" cols="90" rows="4" id="komm"></textarea>
--------
When it click the below "image" everyth... more >>
submitting data from page to page
Posted by cliff at 3/29/2004 12:20:04 PM
I am in the process of developing an application and would like to hide the
query strings in the URLs. I want to POST data to a page then validate the
data. If there is an error I have to send data back via a long query string.
Is there anyway to POST data between pages programmatically?
... more >>
Invert an array
Posted by Me Padre at 3/29/2004 12:03:55 PM
Hoping someone can help with this. I know I can do this
programatically using a loop but I thought there might be
some easier or more effective way.
I am trying to invert an array.
i.e.
array1 = 1,2,3,4,5
but I want to get
array2 = 5,4,3,2,1
Is there something like array2 = in... more >>
ClientCertificate
Posted by Reena at 3/29/2004 11:57:02 AM
Hi,
Working with ASP, Windows 2000, IIS 5.0.
I have CA certificate installed on my machine which is installed fine.
Under IIS, Web Site - Properties - Directory Security, I can view
certificate. Secure communication is set to "Accept Client certificate"
However when I run following code... more >>
Dates
Posted by Mike Hill at 3/29/2004 11:24:15 AM
I am writing an app that uses ..Now()...
How do I allow for time zone differences?
If I understand, Now() pulls the server time.
... more >>
How can I retrieve the current value of a combobox in ASP?
Posted by gshawn3 NO[at]SPAM hotmail.com at 3/29/2004 10:52:24 AM
Hi,
I am having a very difficult time retrieving the value of the selected
item in the combo box using ASP. I have the following code, that
refreshes the page location when the combo box selection is changed.
<SELECT NAME="optionvalue"
onChange="document.location='/input.asp?optionvalue=<% ... more >>
Include File or Include Virtual
Posted by Bryan Harrington at 3/29/2004 10:38:55 AM
Hello all.. I'm working on an application that I'd like to use some shared
files.
Right now my directory structure is:
/ (root)
.../Shared/
.../Reports/
.../Tools/
I would like to have CSS, shared functions etc.. in the shared folder and
use them in the root, reports... more >>
Problems2
Posted by Murphy at 3/29/2004 8:27:24 AM
My code does not run...
I have saved the file with an aspx extension and when I view it the page
displays the HTML content but the code does not run ?
I'm guessing my server is not configured correctly. Once again the code is
very basic:
<%@ Page Language="VB" %>
<html>
<head>
<... more >>
Learning asp.net
Posted by Murphy at 3/29/2004 8:13:37 AM
I am trying the following code from the ASP.NET tutorial at:
http://www.dotnetjunkies.com/quickstart/aspplus/doc/webformsintro.aspx
The code is simple and is as follows:
<html>
<head>
<link rel="stylesheet" href="intro.css">
</head>
<body>
<center>
<form actio... more >>
Dynamic Table Issue
Posted by HenryW at 3/29/2004 6:56:06 AM
I am writing a table out to display data from a recordset and my problem is that even though as you can see the table should not exceed that screen size, it does. My users will have to scroll a mile to the right to see the right most column...
Any ideas? I have already tried using width specifier... more >>
garbage collection in .net
Posted by jzink at 3/29/2004 6:01:08 AM
what is the best performance monitor for me to add to check for the memory being used by my asp.net app
----- Jeremy wrote: ----
>> If I keep an eye on the memory being utilitized by the worker processe
(via taskmgr) I see it start at around 30K and will grow to around 140... more >>
date range
Posted by Andrew at 3/29/2004 5:03:15 AM
Hi,
I select from an Access table " where date >= '3/1/2004' and date
<='3/31/2004' ", but no record. Can you tell me how to make this
comparission?
Thanks
--
Andrew
... more >>
ansi encoding
Posted by duzos duzos at 3/29/2004 2:38:17 AM
i need to connect to a dbf database with ansi/oem encoding
the connection is ok
but i have problem with page encoding
the characters don't display as they should!
does anyone have any suggestions??
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET..... more >>
I am sure there is a better way, looking for some guidence!
Posted by Jeff Uchtman at 3/28/2004 11:37:27 PM
Query in ASP against a MS SQL DB.
<%
Dim Sql
Dim Conn
Dim totalCount
Dim rsCount
Dim rsACount
Dim PetACount
Dim rsBCount
Dim PetBCount
Dim rsCCount
Dim PetCCount
Dim rsDCount
Dim PetDCount
Set rsCount = Server.CreateObject("ADODB.Recordset")
Sql = "SELECT ID from Ver... more >>
wrong cursor type??
Posted by (chelleybabyger NO[at]SPAM hotmail.com) at 3/28/2004 9:48:52 PM
i wish to show 5 datas on every page. but i cant seem to do so. below is my codes. the error msg i keep getting is "Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype."
What cursortype should i use then? pls advise.
' Retrieve... more >>
|