Why is Request.QuerySting being treated as a number?
Hi:
I have the following:
NRYear = Request.QueryString("nryear")
which I assumed would result in NRYear containing a string.
However, when I concatenate it with "1/1/", I get "1/1/+2003" as if
the NRYear is a number.
Ultimately, this will go in a SQL string such as
SQL = "Select * from newsreleases where nrdate between 1/1/2003 and
12/31/2003;"
and I want the year to come from the Request.QueryString as the user's
selection.
Help!!! Running out of ideas,
Jules Tag: Manage table names, flds, queries via reporting structure Tag: 274544
OT:Thawte
Can anyone tell me if thawte have a uk site or do certificates have to be
bought from the .com site and in US dollars? I've tried www.thawte.co.uk and
www.thawte.com/uk with no joy.
BTW, are they the best/cheapest?
TIA
chopper Tag: Manage table names, flds, queries via reporting structure Tag: 274530
Find Links in a html file
Hello,
Can anyone help me with the following problem
I want to make an ASP page look at my index.html file, and give me a list of
all the hyperlinks that are in this page.
Is this possible, can anyone point me in the right direction?
Thank in advance for any help.
Gram. Tag: Manage table names, flds, queries via reporting structure Tag: 274526
Off-Topic: Public Access NNTP servers
Apologies for the OT post, but as you will see my options were limited:
In addition to all these wonderful NG's, I also need access to the
comp.infosystems.www.* NG's. The open nntp server I had found and was using
seems to have disappeared into the void, so now I am looking for an
alternative.
Obviously Google have their Groups service, but apart from having a terrible
UI, it takes 3-9 hours to get my posts updated, rather than the 5-15mins
with an nntp server.
I would have liked to use my home ISP's server but it requires I be
connected via their dial-up service to access it.
Does anyone know of any open nntp servers I can use? Or a more responsive
web-based system?
I'm afraid my luddite bosses are not in the mood to throw *any* money at
this, so budget is zero!
HELP!
Thanks
Chris Tag: Manage table names, flds, queries via reporting structure Tag: 274520
setting the input inside a asp page.
Hello!
Was thinking of having an array inside a asp page. I'm rather new to this.
How do I begin. my asp page should work as follows:
1. One html page include mail adresses. We receive a lot of junk mail and I
was thinking of how to avoid this. Was thinking of creating a asp page with
an inout string inside the asp page. The input number should refer to the
users mail adress.
We are only four people in our office, so that should be simple to manage.
The html code should be like "redirect.asp?1" for the first mail adress. and
redirect.asp?2
What's the syntax inside the asp page?
How!??!
--
- Lars Tag: Manage table names, flds, queries via reporting structure Tag: 274519
treeview in ASP
i want to use treeview in ASP page
but i m unable to populate it
plz help me
how to impliment treeview in asp Tag: Manage table names, flds, queries via reporting structure Tag: 274515
Merging Powerpoint slides?
I was hoping to get some opinions on how best to approach a problem:
A customer will browse our web site selecting .ppt presentations
he/she wishes to download. In the background, these presentations are
merged into ONE presentation, which is then downloaded by the
customer.
My employer is concerned with performance (the site could receive
quite a bit of traffic) and security.
I have few ideas in mind:
1. Write a script to run on the web server that executes powerpnt.exe
-i <file1> <file2> <finalfile>.
2. Have the task performed by a separate machine with the same script
- which is executed by the web server. (Can wsh scripts be executed
remotely from another machine?)
3. Write a program to run as a service on a separate machine. It
would listen for file requests (generated by the web server) on a
given port, then perform the file merges and send the end result to
the customer.
- any suggestions which language to use here? Is VBscript capable of
this, or am I looking at using something like Java or C? Tag: Manage table names, flds, queries via reporting structure Tag: 274505
Display Problem
Hi.
I have a few sets of unicode strings I am trying to display. I can display
session variables with unicode strings from a XML file, but I can't display
a unicode string coming from a DLL.
If I save the failing unicode string in a unicode file, I can view it fine,
and the browser selects the encoding. The encoding it selects is unicode
and not unicode (UTF-8).
Does anyone have any clue?
Thanks.
J Tag: Manage table names, flds, queries via reporting structure Tag: 274503
format date
i have a date stored in my db in this format: 2005-03-15 00:00:00.000
however, i want to display this date on my .asp page in this format: 03/05
is there a quick function to do this?
tmia
jt Tag: Manage table names, flds, queries via reporting structure Tag: 274487
Compare strings
Hi,
I'm trying to see if a certain string matches a predefined string so I've
tried:
--------------
If txtCondition3 = "NO THEFT COVER unless client claim free and occupied
prems for 3 yrs" Then
response.write "1st condition"
Else
response.write "2nd condition"
End If
--------------
But I'm getting neither response!!!
Any ideas why that would be?
Thanks, Jon Tag: Manage table names, flds, queries via reporting structure Tag: 274480
select for a text file
Hi,
I tried to make select query to a text file using the code below,
<%
sconnection="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="D:\myforlder\;Extended Properties=""text;HDR=No;FMT=Delimited"""
set conn2=server.CreateObject("ADODB.Connection")
conn2.open(sconnection)
set dRs=conn2.execute("select * from test.txt")
%>
But it complaints that:
Microsoft JET Database Engine error '80040e14'
Syntax error in FROM clause.
/thisfile.asp, line 7 (set dRs=conn2.execute("select * from test.txt"))
Any errors have I made? But if the file is test.csv, it works fine.
But the way, where can I find more samples of query string of all kinds of
database connection?
Thanks
Atse Tag: Manage table names, flds, queries via reporting structure Tag: 274478
reading ADSI-content
hi ng!
in our intranet i try to get the users full name from ADSI.
so i connect to a ad-provider with an enforced admin-logon
(see ms knowledge-base 'LoginAdmin.dll') like that:
Set objLogon = Server.CreateObject _
("LoginAdmin.ImpersonateUser")
objLogon.Logon "usernameAdmin", "pwd", "ourDomain"
Set objLDAP = GetObject("WinNT:")
now i connect to a user-object again with the same
authentication as in the connection to the provider:
Set objUser = objLDAP.OpenDSObject _
("WinNT://equsec/" & sUser, _
"usernameAdmin", "pwd", _
ADS_SECURE_AUTHENTICATION)
now i want to read the property 'FullName' from the
objUser with
response.write objUser.FullName
and THAT produces an error: general access denied
(80070005).
well, i connected to the provider AND the user-object with
the very SAME admin-a/c... why can't i read the property
of the object, then??
how can i get there? the admin-a/c has all rights.
i'm totally at sea :-(
grateful for any help or hint!
thanks.
thilo
p.s.: please excuse my not providing any e-mail-address,
but due to increasing numbers of spam- and virus-mails in
my inbox i ask for your kind understanding.
thank you! Tag: Manage table names, flds, queries via reporting structure Tag: 274470
how disable submitbutton with asp
This is a multi-part message in MIME format.
------=_NextPart_000_0046_01C38BED.0BF4D2D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi guys,
I need HELP
I am trying to disable submit button after user submits the form.
thanks in advance
--=20
Jamal
Mpcparts.com / Milwaukeepc
414-3320874-143
414-332-1368=20
3900 N. Sherburn PL.
Shorewood,WI,53211
------=_NextPart_000_0046_01C38BED.0BF4D2D0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY style=3D"COLOR: #000000; FONT-FAMILY: Arial" bgColor=3D#ffffff>
<DIV id=3D0></DIV>
<DIV><BR><FONT size=3D2>Hi guys,</FONT></DIV>
<DIV><FONT size=3D2>I need HELP</FONT></DIV>
<DIV><FONT size=3D2>I am trying to disable submit button after user =
submits=20
the form.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>thanks in advance</FONT></DIV>
<DIV><BR></DIV><SPAN id=3Dhbblock><LABEL id=3DHbSession=20
SessionId=3D"3987776199"></LABEL>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><BR>-- <BR>Jamal<BR>Mpcparts.com /=20
Milwaukeepc<BR>414-3320874-143<BR>414-332-1368 <BR>3900 N. Sherburn=20
PL.<BR>Shorewood,WI,53211</FONT></DIV></SPAN>
<P></P></BODY></HTML>
------=_NextPart_000_0046_01C38BED.0BF4D2D0-- Tag: Manage table names, flds, queries via reporting structure Tag: 274453
Populating three list boxes from the database
Can anybody help?
I need to have three list boxes automatically populating each other, (ie
when region is selected from the first listbox, it will populate
automatically the second one which is the TOWNS and when the town is
selected is should populate the third one AREA) all data is in the database
in one table.
Any idea???
Many thanks in adavance.
Lamine Tag: Manage table names, flds, queries via reporting structure Tag: 274451
cookie problems
i am trying to set a cookie to the user of the site and then pull the data
back to view the cookie data.
this works fine locally on iis, however it does not work using a different
pc. (cookies allowed)
any suggestions?
thanks in advance
j
below are extracts from the 2 pages
----------------------------------------------------
num=1
Response.Cookies (""&vsession&"").Expires=Date() + 90
Response.Cookies (""&vsession&"")("date")=Date()
rs.MoveFirst
Do while NOT rs.EOF
Response.Cookies (""&vsession&"")("item,"&num)=rs("prodId")
Response.Cookies (""&vsession&"")("qty," &num)= rs("Qty")
num=num+1
rs.MoveNext
Loop
----------------------------------------------------------------------------
--
i=1
for each x in Request.Cookies
response.write "quote-"&i&"-"&x&"<br>"
i=i+1
if Request.Cookies(x).HasKeys then
for each y in Request.Cookies(x)
response.write( y & "=" & Request.Cookies(x)(y))
response.write("<br />")
next
else
Response.Write(Request.Cookies(x) & "<br />")
end if
response.write "<br>"
next Tag: Manage table names, flds, queries via reporting structure Tag: 274450
Loop
Hi,
Total newb here so my apologies if I break any scripting standards. I
have some code that pulls reservation times from a database. It is
supposed to print green cells in a table until the time of the
reservation and then print red cells until the reserved period has
ended and then continue printing green cells. Example: reservation
period is 11:00 AM to 2:00 PM. Print green cells until representing
every half hour until 11. Print red cells until 2 then print green
cells until end of day(7 PM). I ran into a problem and statically
assigned values to take the DB out of the loop. Below is the code. Can
anyone tell me why is it that if the reservation start time is before
9:30 AM that the loop breaks and doesn't print red cells. Sorry for
being lengthy,...
Brian
<%
vtime = TimeValue(#7:00#)
btime = TimeValue(#9:30#)
Response.Write "<table border=1>"
For i = 1 to 30
If vtime > btime AND vtime < TimeValue(#12:31#) Then
Response.Write "<td bgcolor='#F0E68C'>" & Left(vtime, 5) & "</td>"
vtime = DateAdd("n", 30, vtime)
Else
Response.Write "<td bgcolor='#F0E68C'>" & Left(vtime, 4) & "</td>"
vtime = DateAdd("n", 30, vtime)
End If
Next
Response.Write "</tr>"
vtime = TimeValue(#7:00#)
stime = TimeValue(#8:00#)
btime = TimeValue(#9:30#)
etime = TimeValue(#11:00#)
Response.Write "<tr height=20>"
Do while Left(vtime, 4) <> Left(stime, 4)
Response.Write "<td bgcolor='#3CB371'></td>"
vtime = DateAdd("n", 30, vtime)
Loop
Do while Left(vtime, 4) <= Left(etime, 5)
Response.Write "<td bgcolor='#F08080'></td>"
vtime = DateAdd("n", 30, vtime)
Loop
Response.Write "</table>"
%> Tag: Manage table names, flds, queries via reporting structure Tag: 274444
JET on a webhotel
Hi
In ASPFAQ I've found an article (2195) about the shortcomings of Access.
Who can disagree with the expert but maybee I'm a little more
optimistic. Evereyone visiting your page does not use the database at
the same time. But what suddenly struck me was that for this to work out
there has to be a separate instance of JET for each separate homepage.
Can anyone clarify this for me?
Mats
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! Tag: Manage table names, flds, queries via reporting structure Tag: 274439
ASP Intranet and Internet
HI
I'm dowing a web site on my intranet in a ASP page I have
to made save option, on the intranet everything is
working fine, but when I upload my website in the
internet I have this message:
The page cannot be displayed
There is a problem with the page you are trying to reach
and it cannot be displayed.
What is the probleme my page is in ASP and on intranet
it's working fine
Thanks Tag: Manage table names, flds, queries via reporting structure Tag: 274436
Viewing COMDLG32 from an ASP page issues
We have an ASP page that generates a report. We have
included a button on the page that allows the user to
save the report as a .csv file. The button makes use of
the Microsoft Common Dialog Control to display a "Save
As." dialog. This works perfectly. However once I send
the code to the client it seems to only work on some of
their machines and not others. Within the object
definition on the ASP page I've added the codebase
attribute and if the control is not present on the client
machine the user is prompted and the control is
downloaded from Microsoft. The ActiveX control however
does not appear to run. I've tried to replicate this
problem on my machine by changing the IE security
settings and I receive a message that informs me that my
setting don't allow ActiveX controls to run etc. On the
client site there is no message and all the ActiveX
security settings are set to "allow". I've tried removing
and re-registering the control but it seems to make no
difference. The control is definitely being downloaded
and registered by the codebase attribute but that seems
to be where it stops.
Thanks Tag: Manage table names, flds, queries via reporting structure Tag: 274432
Quick query question
Hi
How do I force the order of a SQL query?
My table has a field called ModelName which could contain 1 of 5 vehicle
models. I want to force the query to order these in a particular order (not
alphabetical, but an order that I have determined ('Range Rover',
'Discovery', Land Rover', 'Jeep', 'Others')
Let's say my current query is:
"SELECT DISTINCT ModelName FROM tblVehicles"
What do I need to tag on the end to order the result as stated?
Thanks for help!
-- Tag: Manage table names, flds, queries via reporting structure Tag: 274430
Permission denied on ASP Page
Hi,
last week I moved the folder of my Intranet application to
another disk of the same server.
After this change all the ASP page return this error:
Microsoft VBScript runtime error '800a0046'
Permission denied: 'CreateObject'
/DocxTecnici/infotec.asp, line 22
For all the page, the row 22 is:
Set Fso = CreateObject("Scripting.FileSystemObject")
In the old location (C:) the application worked properly.
To move the application to disk D: I've followed this step:
1. Stop the IIS services
2. Move the Folder to disk D:
3. Change the path of Home Directory
The permission on the folder are the same of the old
location
The version of IIS is 6.0
Can you help me?
Thanks Tag: Manage table names, flds, queries via reporting structure Tag: 274424
how to get the size of a jpeg image ?
How can I get the height and width of a jpeg image ?
Thank you for help me.
Emmanuel Tag: Manage table names, flds, queries via reporting structure Tag: 274422
number of columns
Hi,
How can I know the number of columns of the .csv files? I want to import
them to the database.
Thanks.
Atse Tag: Manage table names, flds, queries via reporting structure Tag: 274412
download path
Hi,
While my wwwroot is under C:\inetput, how can I make URL pointing to the
downloadable files on D:\download\myfile?
Do I have to use download COM? If yes, which one is recommended for free?
Thanks for any idea? Tag: Manage table names, flds, queries via reporting structure Tag: 274411
page remembering old values ...?
Hello people,
once again I am here to ask you for your help. This time I am working on
an online shop for a hospice, I am trying to set up a page which gathers an
order from a shopping cart, (this bit works) then asks the user to fill out
a form supplying their name and address etc for delivery of the items they
have bought. It works fine if you enter a surname never before entered, but
if you enter a surname that has been used before, rather than passing across
the data that you type in to the form, it just pulls up the old values???
I have come across this once before and remember that there is a line you
can type in the top of the ASP page which clears the old data and make the
page only use the new values, I think it is :
<%
Session.Abandon
%>
but if I use this I am worried that I will also lose the shopping cart
values, so where should I place this line, on the very first page that the
visitor will load, or somewhere else, can anyone please help??
Thanks again. Tag: Manage table names, flds, queries via reporting structure Tag: 274395
auto execute form
Hi,
is there some code i can use to automatically execute some HTML form code
when a page is loaded ?
Thanks,
Brian Tag: Manage table names, flds, queries via reporting structure Tag: 274389
OLE DB Connection Problems
Hi Guys
One of you kindly confirmed what the true OLE DB syntax is for an ASP > ADO
> Access DB with password, but I'm struggling to parse this in my ASP page.
FYR, I have it as follows:
strDSN="""Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("mydb.mdb") & ";Jet OLEDB:Database
Password=kitkat"",""admin"","""""
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Mode = 3
oConn.Connectionstring = strDSN
oConn.Open
But when I execute the above I get:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name too long
The path name for the DB is spot on, as it works with the ODBC variant, but
I think it has something to do with my 200 quote marks!
Can u help??
Rgds
Laphan Tag: Manage table names, flds, queries via reporting structure Tag: 274387
Need help using asp
All,
Current Im develop a program that using web page to connect to Oracle.
My difficulties was:
1) How to retrieve the information in tnsnames.ora and put into all
connection string into a option list to let user choose accordingly ?
2) After using had choosen the connection then a username and passowrd
page will appear to let user key in the username and password, if verify
is ok then proceed to do other stuffs else put back to login page to let
user retry.
I had tried and tried but still cannot, can someone please help me.
Thanks in advance
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! Tag: Manage table names, flds, queries via reporting structure Tag: 274385
Ever tried to set cookie expiry date using JavaScript?
Hi all.
I'm trying to set a cookie expiry date but my script is JS (JavaScript). I've
tried
Response.Cookies("Test").Expires = Date();
Response.Cookies("Test").Expires = Date().toLocaleString();
Response.Cookies("Test").Expires = Date().toString();
Response.Cookies("Test").Expires = Date().toUTCString();
none works. I've seen what bothers IIS is the day name when assigning the expiry
date: "7 février 2004 11:57:57" is ok while "samedi 7 février 2004 11:57:57"
produces an error "Invalid type".
Ok, I could switch to VB Script (which I think I'll do because of the ease of
doing it in that language). But I'd like to know if there are well-known tricks
on using IIS/ASP and cookies expiry date in JavaScript. It seems IIS object
model is unable to recognize (or handle) JavaScript dates...
Might sound a stupid question but I'd like my script to be as platform
independent as possible. Why? I'm running a French version of Windows 2000/IIS5.
I might have to host my web on an English version. Or whatsoever. I wouldn't
like to triturate the date string for it depends on the current locale. If
JavaScript cannot be used without modifying the string I'll switch to VB script.
Thanks for any hint or suggestion.
Vince C. Tag: Manage table names, flds, queries via reporting structure Tag: 274384
manipulate forms collection
Hi
Is there a way to manipulate (ie change) the items in the forms
collection. I simply want to get rid of the infamous apostrophe in input
from a form, replace ' with ''. I had hoped to be able just to make the
change and then put it back into the Form.item. Is there a way to do
this?
If not, would the best way to save the result be to build an array,
which is then used instead of the forms collection?
My programming is not making progress at the moment due to lack of time,
so I want to find out the simplest solution
Mats
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! Tag: Manage table names, flds, queries via reporting structure Tag: 274383
confused about access / sql database / sql server / php !! .. help please
i am running a website on Windows 2000 server with ASP 3 webpages and
Access 2000 database. (with a hosting company)
traffic is slow at this time but expect to grow. lately i have been
reading about sql database and sql server, specially this article:
http://www.aspfaq.com/show.asp?id=2195
will someone help me understand:
1. with *SQL Server*, do i keep my current Access 2000 database and
ASP pages?
if not, then -
a. what sort of DB i will need? (we r a non profit, so need
inexpensive things)
b. will ASP pages need be redesigned? how big/difficult is that
transition?
2. if i start using *SQL database*, then which SQL database?
3. Where does *mySQL* fit in this scene?
4. What do i do with my current ASP webpages?
5. i guess, i will need an SQL server if i have to use SQL database?
any recommendations for a cheaper hosting company? Tag: Manage table names, flds, queries via reporting structure Tag: 274378