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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers 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: Off-Topic: Public Access NNTP servers Tag: 274378
random word generator
Hello folks...
this is my first post in here. I'm new to ASP having done all my previous
work in Flash and bog standard HTML. Only been learning for a couple of
weeks.
anyway...I have been building a guestbook type page, but as with quite a lot
of guestbooks and stuff some of the comments that get placed are not exactly
suitable, and tracking people down is a little difficult.
maybe you all can think of much better ways but remember I'm a newbie and am
working my way through..
so...
I have a form where people sign up to become a member..they select their
name and password etc and can log in, but this is completely anonymous....
so..I got an email script set up and working (took me a long time to figure
that one out!!!) and connected to a dbase, The user gives me his email addy
and name and a random number is generated, stored as his password and the
password is mailed to him,...thus if he doesn't give me a corect email addy
he doesn't get his password and therefore can't sign in or post nasty
comments..
But a number password isn't really all that and I would prefer to have a
random word generated.
is this possible??
again, being a newbie and not very up on what I can/can't do...I thought of
the following...
1) Store a bunch of words in a text file with a space between each one
2) Read in this file and store it as a variable
3) Trim off a random number of characters from the start of the text
4) Then search for the next space (which would be the beginning of the next
complete word)
5) The next space after that would then mark the end of the word
6) count the characters between the two spaces to give me the word length
7) and then select that number of characters and then I have a randomly
selected word!!!
I can't see why it wouldn't work as it seems logical to me, but maybe
someone (Ray seems to be the god of ASP (I've been reading here for a couple
of weeks and he seems to know everything!!!!)... can tell me otherwise?
many thanks Tag: Off-Topic: Public Access NNTP servers Tag: 274373
add parameter
Hello.
I am trying to pass three parameters using this code in an asp page to an
xsl page.
I keep getting the following error:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/account.asp, line 114
Any ideas what I am missing?
Chuck
Dim oXmlsrc, oXml, oNode, oXslsrc, oXsl, newXML, re, oXslTmpl, oXslProc
Set oXmlsrc=CreateObject("MSXML2.DOMDocument.4.0")
Call oXmlsrc.setProperty("ServerHTTPRequest", True)
oXmlsrc.async=False
Set oXslsrc=CreateObject("MSXML2.FreeThreadedDOMDocument.4.0")
Call oXslsrc.setProperty("ServerHTTPRequest", True)
oXslsrc.async=False
Set oXslTmpl = Server.CreateObject("MSXML2.XSLTemplate.4.0")
'On Error Resume Next 'debugging code
'If Request.Form("name") = "" Then
Call oXmlsrc.load(sVerifyUrl)
'Response.Write "<!-- " & oXmlSrc.xml & " -->" 'debugging code
newXML=oXmlsrc.xml
Set re=new regexp
re.pattern=" xmlns.+?>"
newXML=re.replace(newXML,">")
Call oXmlsrc.loadxml(newXML)
Call oXslsrc.load("https://www.abc.com/account.xsl")
'End If
Set oXslTmp1.stylesheet = oXslsrc
Line 114 <<<<<<<<<<
Set oXslProc = oXslTmpl.createProcessor()
oXslProc.input = oXmlsrc
Call oXslProc.addParameter("accountnumber", ud_CSN)
Call oXslProc.addParameter("customername", ud_CustomerName)
Call oXslProc.addParameter("username", ud_UserName)
oXslProc.Transform()
sOutput oXslProc.output
'oXslsrc.selectSinglenode("//@select").text= "'" & ud_CustomerName & "'"
Response.Write oXmlsrc.transformNode(oXslsrc)
Response.Write sOutput
Set oXslProc = Nothing
Set oXslTmpl = Nothing
Set oXslsrc = Nothing
Set oXmlsrc = Nothing Tag: Off-Topic: Public Access NNTP servers Tag: 274372
replace words with bold words
Hello
I was wondering if you guys could help me solve this using reg exp,
i have a searchpage and a variable keywords that holds a number of words.
e.g
keywords = "test car goose"
.....
<%
do until rs.eof
%>
<%=rs("text")%>
and i was wondering if you guys know how to make the words test, car and
goose bold if exists in rs("text")?
/Lasse Tag: Off-Topic: Public Access NNTP servers Tag: 274370
cant get #include to work in .asp file.
I'm new to html and web coding, this is a simple one -
appreciate your help!
I'm attempting to get my browser bar links to reside in a
single .asp file to avoid multiple additions to pages
when I add a page to the site. I've done a lot of
reading and surfing, believe I know how to do it, but
can't get it to work.
I've installed IIS on my machine running XP pro, and have
created two .asp files, one called default.asp, the other
navigation.asp
both pages browse OK separately, but the navigation page
text does not appear within the default page at all (like
it's not getting "called" - here's the cut down code.
<html>
<head>
<title></title>
</head>
<body>
<% %>
<p>
This is the default page (filename default.asp)
<p>
<!- #include file="navigation.asp"->
</body>
</html>
-----------------
<html>
<head>
<title></title>
</head>
<body>
<% %>
This is the browser page (filename navigation.asp)
</body>
</html>
------------------
Thanks for your assistance
Regards
Greg Tag: Off-Topic: Public Access NNTP servers Tag: 274363
MS, YOU ARE A DISEASE
Whether those trojans or virues appear in this group,
hidden on my machine, in your disks, in your downloads,
in your Software, in your Patches, in your shrink wrap,
in your Financial Report, on your ballot, or whereever.
=======
There was reason to put you in the section of
new or other species.
======
Gues that was premature.
--------------
Why don't you just get lost. Tag: Off-Topic: Public Access NNTP servers Tag: 274346