ASP :: ASP Session Issue

Session.Lcid Issue
I've recently installed a calendar that I downloaded but I'm having a bit of
a problem with the date settings. I thought setting the LCID value would
help which it does but brings another problem. The site is being hosted on a
server in Germany, and when I enter the LCID value for Germany it works but
also changes the days and months to German. Any way to change that to
English? I tried using the LCID values for US or UK but it just does not
work....probably something to do with the German format of dd.mm.yyyy

Use ASP Session Variable In DRW Issue
Right I have created a web login and set one of the results to become "pluser" session varible. What I now need to do is use this varible in DRW so that when the user goes to pages with databases it automaticly returns values for that varible. Code:

HTA External Server Session Issue.
I've have a asp application that uses several session variables
(login). I have a HTA application (on client "local") acting as the
"window" for the application.

All works fine while using the HTA file to access my local version of
the web application but when I try to access the same web application
on the server with the same HTA file, just changing the iframe source
from the client machine to the server, session variables no longer
work. What's the deal? The server is not on our network, on DMZ. Code:

ASP / XML Issue With IIS
We have an ASP file (listener.asp) that is used to process
SOAP transactions on our web server. The ASP file uses
XML Core Services to load an XML file into a DOM document
variable. We process around 50,000 transactions a day
using this process. We have been getting intermittent
errors while trying to load the XML file. We typically
receive between 3 and 20 errors a day. We have attempted
many different fixes and we recently upgraded to XML Core
Services 4.0. None of our attempts have been successful
in resolving the issue. Here is an excerpt of the code
that fails.
Set oXMLDoc = Server.CreateObject
("Msxml2.DomDocument.4.0")
oXMLDoc.async = false
oXMLDoc.Load (strSchemaLocPhys)

where strSchemaLocPhys
is "C:InetpubwwwrootcbwapiprodCBWWorkflow.xml".

Issue With ASP And Win XP
We are using Microsoft Office Web Components 11.0 in our asp page to use Pivot Table component.

It is running well on all OS except Windows XP. On Windows XP system the pivot table control is not displayed in ASP page. Am I missing something? Any workarounds?

How To Find The Session Expired Or Not Without Using Any Session Varaibles
how to find the session expired or not without using any session varaibles?

Cookies Issue
I have an application that when it loads, it checks for a cookie on the client side. If the cookie exists, it sets a variable on the specific ASP page for certain fields to be populated. Our problem is that some user sessions have data left over in cookies that
are from a previous user session....

ASP/IIS Configuration Issue
I think this error that I am receiving is a simple one to resolve.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I have downloaded and installed the latest version of MDAC but the error remains.

I am attempting to configure IIS on a different drive ( E:inetpubwwwroot, instead of c:inetputwwwroot ). Could it be that SQL, ASP and IIS just have trouble talking across multiple drives? ( I have sql installed on a third drive ).

CDO Issue With Badmail
Usually when I setup a web form with CDO I either set the "From" field
in the email to either:

1. The email address of the person filling out the form, in which case
user errors often result in the mail getting stuck in the badmail folder
and not being sent

2. An alias for the client (like Join Bytes!) to guarantee that it
gets delivered, but this is less convenient for the client as they can't
just reply-to the message, they have to manually change the address (not
a big deal, but annoying)

Is there another way to guarantee that even with a bad "from" address
scenario #1 will work every time? Or some other option I'm too dense to
have realized?

ASP And Query Issue
I have an issue trying to render a report. The report comes from a submitted ASP page that exports into Excel. My data comes from a stored procedure. That data outputs a current rank, previous rank, dealer name, current total, previous total, difference of totals, and % of totals.

For some reason though, the stored procedure has a loop hole somewhere. I am comparing Dealers sales from one year to the next. They are uniquely identified by the phone numbers. I am UNABLE to get dealers who did business in 2005 but currently have less than a $1 in sales for 2006. However, I do get dealers with sales in 2006 but no sales in 2005. Am I making any sense? Code:

Rs.GetRows Issue
Since I never user .GetRow, (because arrays drive me crazy) I thought I'd give it a shot with something I had to do, unfortunately I get several errors. Code:

AdUseClient Issue..
I do not see what I am missing from this partial code to return values from a SQL db and then eventually use paging with the recordset. It errors on the line with adUseClient. The error that is returned is...

Object doesn't support this property or method: 'adUseClient' Code:

Money Issue
i have a field which has datatype as money
when i add a value in it like 110.00

rsadd("Amount")=txtamount

it comes like $110.00 which is right
what i want to do is instead of $110.00 i want -$110.00

i tried like this
rsadd("Amount")="-" & txtamount

when it added it came like this ($110.00)

Storage Issue
I want to have a variable in wich I will store a date.
this variable should be stored in a DataBase, because I want it to be in all my website pages and I don't want it to be erased after the web host starts over (that marks out application variables).
The real problem here isn't were to store it, cause that's gotta be in a DB (I think), but how to store it.
I don't want to make a whole table with one feild in it only for one row, thats total waste of place on my host.

Validation Issue
Im dynamically generating the contents of a form with details read from a text file and the names im assigning to the controls are also dynamic.[The Labels of the Control.]
The problem now is that, i dont know how do validate these controls for the mandatory check!!

[Is there any option to iterate the entire controls present in a form??]

Connection Issue
This website is running on IIS 6, SQL Server 7 back end, asp scripting.

It has public and private areas, but uses the same connection scripting
throughout the entire site.

SET conn = server.createobject ("adodb.connection")
conn.open Session("DSN")

strUserID = request.form("txtUserID")

SET rsUserCheck = Server.CreateObject("ADODB.Recordset")
rsUserCheck.CursorLocation = 3
rsUserCheck.open "SELECT * FROM tblUSERS WHERE UserWebAuthorityLevel = 1 AND
UserID = '" & strUserID & "'",conn

From Global.asa: Session("DSN") =
"dsn=AWS_SQL;uid=IUSR_Hurricane;pwd=<>;DATABASE=AWS_SQL;APP=ASP
Script;Trusted_Connection=yes"

Although thousands of users connect successfully using the above every day,
2 users are getting the following message when going to the page, even when
using the correct UserID and password.

The connection cannot be used to perform this operation. It is either closed
or invalid in this context.

The error references the line "rsUserCheck.open "SELECT ..."

One of the users has a 3-computer home network, with 2 of the 3 computers
logging on without a problem. The same is true within another network,
where some work and others don't. Otherwise, the vast majority of users are
having no problem whatsoever.

Have you heard of this happening before? Is this an IIS issue?

Display Issue
i have a problem with a image displayed in pop up window

i have a radio button and next to it some text which says View image

when you click on view image a pop up window pops up and shows the image

with my case i cant see the image

i have the image in the folder

can someone tell me whats wrong Code:

Issue With ServerXMLHTTP
I am trying to use ServerXMLHTTP to grab the HTTP Header from a page using the following code but it doesn't work.

<%
Response.Write "Output"
Set getPage = Server.CreateObject("MSXML2.ServerXMLHTTP")
getPage.Open "HEAD", "http://www.example.com", false
getPage.SetRequestHeader "Content-type", "text/html"
getPage.Send
Response.Write(getPage.responseText)
Set getPage = Nothing
%>

I want to use HEAD instead of GET in order to save bandwidth. I don't want to retrieve the full html of a page, just the HTTP header to know that a file exists:

HTTP/1.0 200 OK
or that a file is not found
HTTP/1.0 404 Not Found

This is for a link checker that I am writing. Does anyone know what I am doing wrong or does this object not recognise the HEAD parameter?

ASP Currency Issue
i have a textbox where a user enters a number when he submits that page i want to show the number entered as currency:

say for example he entered 12

next page i want to show $12.00

i did this:

txtprice=Cast(txtprice AS MONEY)

but its throwing an error

any idea how to work this out

ASP - Excel Issue
The following is the 5th line of my ASP page and while executing the page im getting the

Set MyExcelChart = Server.CreateObject("Excel.Sheet")

the following error!!

Error Type:
Server object, ASP 0177 (0x8001010A)
The message filter indicated that the application is busy.
/tpp/Dynamic/myexcelchart.asp, line 5

What should i do to proceed further??

<Backspace> Key Issue.
I created a full asp web application. I have most of the bugs worked out of it. However, when I turned it over to the end-users for testing they found a wierd situation, as end-users will, that I hadn't come across.

When a users is filling in a form and they land on a dropdown box, if the user hits the <Backspace> key it takes them back one page.

Since this is my first asp project and Im not that experiainced with web applications, I wasn't sure if this was really an issue. Since this doesn't happen when the user lands on any other control, text, check box, option button etc... Code:

Date Value Issue
I am trying to retrieve a count of booking entries made 30 days ago, below
is the end of the query I am having problems with.

dbo.booking_form.TimeOfBooking = DATEADD(day, -30, GetDate()) GROUP BY
dbo.booking_form.TimeOfBooking")

When I use the = sign the error reads

Either BOF or EOF is True, or the current record has been deleted. Requested
operation requires a current record.

for the entry on the page

(rsCash30("CountOfTimeOfBooking"))

But I know the record exists

Date Issue
I have a field in the table which stores date and datatype is datetime name is Dept_Date
for example the values in the field are like this

5/16/2005 9:11:13 AM

now i have my code like this

d="5/16/2005'

Code:

Set rs= Server.CreateObject("adodb.RecordSet")
str ="SELECT * from Dept where Dept_Date='" & d & "'"
rs.Open str, Conn, 2, 2

Date Issue...
Would anyone know how to format the year as the last two numbers? Like this - May 5, 05

Minor Issue
I have an asp page which posts a form (made up of fields with drop down lists) to itself. The page then queries a sql server database when the form is submitted and creates a table with the results below the original form. This all works fine.
However, when a user submits the form and the page is reloaded with the results, I want the page to focus on the newly created table + results rather than the top of the page (form).I have tried using vbscript to get the page to focus on the table everytime the form is submitted but have had no success. Is there a way to make this work?

Printing Issue
I have this code on the page which displays a image.

<a href="print.asp?id=<%=ID%>"><img src="/image/imglink.gif" border="0" /></a>

When a person clicks on the image it opens up print.asp
What i want to do is when a person clicks on the image i want to print the page print.asp
i tried window.print but its not working
can someone tell me what i am doing wrong

Exporting To CSV Issue
I am using a SQL 2000 server and am trying to export results from a
query to a text file. The code is working, expect my CONTACTNAME field
has a comma, and my export is splitting that into 2 columns when I only
want it to be one. Code:

Connection Issue
i have this code on my page and whats happening is when the user fills out all the information and submits the form it times out i think i am doing something wrong with closing the connection

the data is added in the table in thr right way i am just not getting where to close the database connection here is my code:

HTTP_REFERER Issue
Just wondering if anyone has found a way to grab the referring URL if the resulting page isn't from a HREF link.

To explain further:

I am creating an ASP driven weblog and am trying to avoid using the queryString to pull out the correct posts (Primarily for better search engine results). To do this I would like the user to be able to click on or type in something like

http://host/weblog/year/month/shorttitle

Under normal circumstances this would look for the default page in a folder called "shorttitle" but instead I defer this to a custom 404 error page which would strip out the URL and do a database query depending on the year, month and shorttitle.

However - this all works a treat when you click a generated link as the HTTP_REFERER is sent through in the headers, but if this is simply typed into the address bar the HTTP_REFERER is blank upon reaching the 404 page.

ASP Database Issue
Does anyone know what this error message means?

ADODB.Recordset.1 (0x800A0BB9)The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.

I get it while trying to load my default.asp

Security Issue
I wonder whether it is safe to store the database username and password in a
ASP page. Is there any chance that a user can down load the actual file?

Server Issue
FirMy default.asp will not load. It shows the directory listing instead.

Second problem...
When I do load the default.asp page I get this error message:

The Include file '../includes/inc_config.asp' cannot contain '..' to indicate the parent directory.

/home/default.asp, line 1

This is the first line on my default.asp page:

Connection Issue
i have a access file connected to a site through asp, and the connection i made is :

dim adocon
dim rsaddcomments
dim str
Set adocon = Server.CreateObject("ADODB.Connection")
adocon.Open "cmpda_all"
Set rsaddcomments = server.CreateObject("ADODB.recordset")
str = "SELECT * FROM plaint; "

rsaddcomments.cursortype = 2
rsaddcomments.locktype = 3

but on condition on the server they must do the system DSN and calle it cmpda_all and point to the database file, but they didn't do it and i am still waiting for them,is there another way to connect to the file, because the interactive site is not working he is giving a message error of ODBC.

Datatype Issue
i am having a small problem here i use sql server 2000 and in it the fields datatype is money i am displaying some items and here is how i do Code:

Drop Down Issue
i need some help i have a drop down and when the user selects the value in drop down i want a page called display to be called and pass a value to that page here is my code

i have written the onclick event but its not working i have also tried onchange Code:

Display Issue
the problem i am having is i only want to display the transactionid and customer name and date recieved right now its showing the orderid and customerid

i know i have to change the code in this line

Response.Write "<a href=""orderdetails.asp?transid=" & objPagingRS("Transaction_Id") & "&orderid=" & objPagingRS("Order_Id") & " &customerid=" & objPagingRS("Customer_Id") & """>"& objPagingRS.Fields(I) & "</a>"

i want the orderid and customerid to be send through querystring Code:

Another Minor Issue
I wasn't sure where to post this as it is more to do with html but it arises within an asp page. Basically I have a form which collects information (search strings) from users, These strings are then used to query an sql server database and the results printed to a table. An example of what the table looks like is shown below. Code:

Internet Issue
Issue: whenever I try to get online, a window pops up on the screen
and gives a message, "the webpage you are requesting is not available offline. To connect,
click connect tab".

And later I can get online, or sometimes it never let me to connect to
internet. I'm fed up with this problem. I tried doing many steps to
block this message. Nonetheless, I always see this pop up.
Steps which I performed: 1. uninstalled the network drivers &
restarted the computer.

List Box Issue?
i have a registration page which user can register. in admin side i want 2 see month wise register people. i mean i want 2 see how many peoples are registered in a month and
and also i can see the multiple month. here is the screeshot

the database is in access. when i click show list it can show me the user which are register in january, feb, april...

Cdonts Issue
We are using CDONTS to send email through ASP.However, occassionly, a constant stream of emails is being placed in the 'inetpub/mailroot/pickup' directory with the "TO:" email address set to "none". The email is valid but the "To" address is not. These are filling our hard disk and slowing the server.

Conurrency Issue
I have a webpage,where users enter data and submit the data,after which they r edirected to thank you page(with their id generated on submit),where there is a link clicking which a new window is opened with their submitted data..what concurrency issue I will face.

CDONTS Issue (SMS)
I'm setting up an ASP page that will take a cell phone number/carrier and e-mail some info as a text message to a client's cell phone. I have the e-mail addresses for the major cell phone carriers. The problem is, it seems that certain carriers interpret the HTML BR tag differently. If I use BR, it shows up "properly" on a Cingular phone, but doesn't break at all on a Verizon phone. Is there a way I can handle this within CDONTS or is there some other method I can use? Would vbCrLf work?

Secure Issue
there is a way to post form variables in the best secure way... i don't sure how or what is the technical way to do this and that is the aim of this subject... but somehow the form write all the inputes into cookie and than the asp file read the form outputs from the cookie and not from the form itself... why? how it works?

Security Issue
Is it possible to define an account in <Identity> in web.config which dosen't exist in domain?

I was viewing somebody's application I found the following line in his web.config

<identity impersonate="true" userName="DOMAIN_NAMEASP_NET_TESTER"
password="TEST"/>

but problem is that I didn't find user ASP_NET_TESTER on the domain and application is working fine. By the way,he has enabeld annonymous access to his web application using a completely diferent account called "IUSR_DEV"

Mysmartupload Issue
I'm trying to rename the aspsmartupload filename but having issues.

Set mySmartUpload = Server.CreateObject("aspSmartUpload.SmartUpload")
mySmartUpload.Upload
set mySmartUpload.Files.Item(1).FileName = mySmartUpload.Form("year") &
mySmartUpload.Files.Item(1).FileName

this is the error I get

Microsoft VBScript runtime error '800a01a8'

Object required: 'FileName'

the filename will write to the screen with no problems, as well, I tried assigning a simple string to the filename but with no success. Can you even change mysmartupload data? I hoped you could.

Cookies Order Issue
I've created a bit of code to temporarilly store and display product info in a cookie, I then reuse it to create a list of products.

Listed items appear in a random order, and this order is again affected when I add more items.

Just to give you an example, if I add prod_1, then prod_2... ,prod_5, the list created by reading the items in the cookie shows them as prod_5, prod_3, prod_1, prod_2, prod_4.

I'm I going mad or do I just have a variable/constant missing? .....

File Copy Issue
I can log into the server, run the asp page and make the following
test code work, but if I log onto a workstation and run the same asp
page, I don't get an error, but the file copy doesn't work. I have
anonymous turned off because I record LOGON_USER as the clerk in the
site when the user processes orders. Why would this work running
directly from the server but not from a workstation? Code:

Print Option Issue
Based on the layout selected by the user in the search page, im displaying the search result!! Now, i have to give him a option for "print"!! What code should i put in, so that he will have an Printer Friendly option and that prints the search output in the diplayed format!