| Virtual Path and physical root |
|
 |
Index ‹ asp
|
- Previous
- 1
- to few parameters. Expect 2 - errorHi
Can anyone help me out of this:
id2 = request.form("f_email_n")
sSQL = "DELETE * FROM newsletter WHERE e-mail='" & id2 & "'"
Set oRS = oConn.Execute(sSQL)
Gives me error: to few parameters. Expect 2....
Thank you
Flokke
- 1
- number of columnsHi,
How can I know the number of columns of the .csv files? I want to import
them to the database.
Thanks.
Atse
- 2
- web application definitionCan we say a web application means an application with web user interface?
Do u think this is a good definition? Since web services doesn't have web
user interface, it should be distingushed from web application.
- 2
- ASP.Net VB Web Parts - Connections work fine, until I close, then reopen a web part.I'm just starting out with ASP.net, making a web parts intranet.
I'm triyng to get some basic web parts (ascx files) working on a page,
I want them to share a variable, 'StaffID' which one part generates by
looking up the windows login name of the person viewing the page, and
then queries the database to find out the StaffID associated with that
name.
That part then shares it with all the other parts, using a class
called "IMessage", I have set up static connections for each
individual part,
The main part, Jobs_Main.ascx has this code:
Public ReadOnly Property Message() As String _
Implements IMessage.Message
Get
Return StaffID
End Get
End Property
<ConnectionProvider("Message", AllowsMultipleConnections:=True)> _
Public Function GetMessage() As IMessage
Return Me
End Function
to assign the StaffID (which is generated on Page_Load - I also tried
Page_Init and this made no difference)
and then the other parts use
Public _message As IMessage
<ConnectionConsumer("Message")> _
Sub SetMessage(ByVal message As IMessage)
Me._message = message
End Sub
in the scripts and then:
If (Not (_message) Is Nothing) Then
StaffID = "" & _message.Message & ""
Else
StaffID = 1
End If
That all works beautifully. If I change the staffID manually on
Jobs_main(in the code) all the others update next refresh. However I
have put in a catalog, and when I close a web part (the part I was
trying was FavouriteLinks.ascx) then add it again, it defaults to the
StaffID of 1...
So I assume it is not getting the _message value, or it thinks the
_message value is 0 for some reason? Does anyone know why this would
be? Could it be that it is loading before the jobs_main web part? If
so how do I make it load afterwards?
- 5
- CDO in header?I have multiple asp files which used CDONTS. As we are switching over to
CDOSYS these files need to be updated. Is there a way that the cdo commands
can be called from one general area, rather then have to modify each file?
Thanks
- 5
- ad hoc reporting component for websiteHello,
I am building a web application that will let users build ad hoc
queries against the sql server database. I am looking to purchase a
component that will provide an interface for regular users to select
table(s) to query, and put multiple WHERE conditions on them. Is there
any components on the market that will do this?
- 6
- post form data to a modal dialog windowI reposted this question because I really want to accomplish this task.
Please advise!!
I want to post the form data (http://server/page1.asp) to a modal dialog
window (http://server/modaldialog.asp) with a desired height 200px by width
200px.
Here's my attempts and problems:
Attempt #1) In http://server/page1.asp, it has code <form
action="http://server/modaldialog.asp" method="post" target="_blank">
In http://server/modaldialog.asp, it has code <body onBlur = "self.focus()">
It can produce modal dialog window modaldialog.asp, but I want to set the
width and height of modaldialog.asp.
Attempt #2) var sReturn = window.showModalDialog("modaldialog.asp", params,
"dialogHeight:200px; dialogWidth:200px;");
This is the effect I want. But this is not posting the form data to
modaldialog.asp.
Any workarounds to my problems??
Thanks!!
- 7
- Non Greedy Regular Expression in Scripting Engine 5.1Hi. I really need help with a regular expression in ASP. I need a regex
pattern that will grab a select or textarea tag in an HTML file. If I run
the pattern I should get
<select name="whatever">
<option value="a" selected>A</option>
<option value="b">B</option>
<option value="c">C</option>
</select>
Or
<textarea name="whatever">Here is some text area text</textarea>
I know the following pattern works:
<(select|textarea).*(.|\n)*?</(select|textarea)>
But the problem is my web hosting company is using ASP scripting engine 5.1
which does not support the non greedy delimiter (?). I doubt they are going
to upgrade to 5.5 anytime soon. I'll appreciate it if anyone can give me a
pattern that does the same job but does not use the ? delimiter. Is there a
way I can tweak the pattern above so that it works in ASP scripting engine
5.1? Thanks in advance.
- 7
- System COlors in ASPHi. I need to get in classical ASP page color of < Button Face > object of
MS Windows. Is there any standard function in vbscript?
Please help.
Thanks
- 7
- OT: Another reason to NOT use .NETRead this article, it's great. Seeing a number of these across the
internet I have been very hesitant in moving my design platform. Any
opions?
http://books.slashdot.org/article.pl?sid=03/05/20/1640225&mode=nested
-Andrew
* * * Sent via DevBuilder http://www.devbuilder.org * * *
Developer Resources for High End Developers.
- 10
- 11
- Getting fragment from URLI have a series of pages I want to put a link on that will allow them
to go back to the page they entered from (the referring URL). The
problem is that to return to the previous page correctly I need the
fragment (page.asp#fragment) along with the referring url. Problem is
that ASP does not seem to provide that. Any advice on how to get the
fragment along with the URL?
For those who might suggest doing a javascript back()... this will not
work since the area people are going into can be a group of pages and
they may click around a few times before wanting to return, so I was
going to save the referring URL when the enter.
Thanks
- 14
- Classes and recordsetsHi,
Assuming I create an object as below
<%
Dim objMainItem
Set objMainItem = New ItemContent
objMainItem.item_id = 1
objMainItem.Open()
%
and the class ItemContent creates a recordset based on the item_id
passed in.
Each item record contains the fields (header,label,content). I would
like to reference the fields in the following format
<%= objMainItem.header %
Is this possible?
Many thanks,
s/.
- 14
- Activating sub routine from hyperlinkOk, I am still playing with ASP and was wondering how to do this (it seemed
simple). What I want is to have a hyperlink that when it's clicked on, will
run a sub routine, instead of opening a web page... Right now I have;
Sub CreateLinks()
Response.Write "<br><br>"
Response.Write "<a href='OpenAllOrders()'>1. All Orders</a><br>"
Response.Write "<a href='OpenCustOrders()'>2. Customer Orders</a><br>"
Response.Write "<a href='OpenInvoices.asp'>3. Open Invoices</a><br>"
End Sub
Sub OpenAllOrders()
Response.Redirect "OpenOrders.asp?Customer=0"
End Sub
Sub OpenCustOrders()
Response.Redirect "OpenOrders.asp?Customer=1"
End Sub
The issue, is that clicking on the link, tries to open a web page file of
'openallorders()', instead of running the sub routine. Obviously I am
missing something simple... Can anyone point me in the correct direction
(think it has something to do with href... maybe it should be hsub or
something).
- 16
- How do I import a CSV data into an Access DB?For a kick off sorry if this is the wrong forum, Ill go on the Access
one if Im not on the right board!
Anyways, Ive got a problem and am not sure if its going to be solved
programatically using ASP or not.
Here's the overview:
Im building an eCommerce web site using ASP. It has an Access DB at
the back end. Im receiving the Product info from a series of CSV
files. Ive created a Table in Access called 'Products' and the two
fields which concern me are called 'ProductID' and 'Price'. The
product prices change regularly, sometimes quaterly. The updated
prices will be received in the CSV file.
Here's the problem:
I want to somehow get the 'Prices' field in the datbase to be updated
automatically whenver a new CSV file comes in, I dont want to manually
type all the updated prices.
How would I get this done? Can it be done in Access or would I have to
get some sort of ASP program code to do it? Im not a programmer so
would appreciate an 'idiots guide' if poss!
Cheers....John
|
| Author |
Message |
jason
|
 Posted: 2004-8-3 0:11:00 |
Top |
asp, Virtual Path and physical root
Is it possible to include my remote web server path eg: m:/html/root/site1
| m:/html/root/site2 etc
...in virtual includes....
Thus eliminating the need to create duplicate INC files in each sub-domain
on my remote web server host domain IP. eg: http://72.3.5.6.0
(www.site1.com; www.site2.com)
I would like to be able to use a UNIVERSAL INC file in the root of my web IP
for the benefit of all my sub domains...
Appreciate guidance!
- Jason
|
| |
|
| |
|
Aaron [SQL Server MVP]
|
| Posted: 2004-8-3 0:22:00 |
Top |
asp >> Virtual Path and physical root
Did you try:
<!--#include file=m:\html\root\include.asp-->
--
http://www.aspfaq.com/
(Reverse address to reply.)
<email***@***.com> wrote in message
news:email***@***.com...
> Is it possible to include my remote web server path eg: m:/html/root/site1
> | m:/html/root/site2 etc
>
> ...in virtual includes....
>
> Thus eliminating the need to create duplicate INC files in each sub-domain
> on my remote web server host domain IP. eg: http://72.3.5.6.0
> (www.site1.com; www.site2.com)
>
> I would like to be able to use a UNIVERSAL INC file in the root of my web
IP
> for the benefit of all my sub domains...
>
> Appreciate guidance!
>
> - Jason
>
>
|
| |
|
| |
|
jason
|
| Posted: 2004-8-3 0:28:00 |
Top |
asp >> Virtual Path and physical root
I tried it locally eg ="c\inetpub..." but got "page not found"......I am
just trying to confirm whether one can actually use a phycial path in a
virtual include..
- Jason
"Aaron [SQL Server MVP]" <email***@***.com> wrote in message
news:u5%email***@***.com...
> Did you try:
>
> <!--#include file=m:\html\root\include.asp-->
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>
>
> <email***@***.com> wrote in message
> news:email***@***.com...
> > Is it possible to include my remote web server path eg:
m:/html/root/site1
> > | m:/html/root/site2 etc
> >
> > ...in virtual includes....
> >
> > Thus eliminating the need to create duplicate INC files in each
sub-domain
> > on my remote web server host domain IP. eg: http://72.3.5.6.0
> > (www.site1.com; www.site2.com)
> >
> > I would like to be able to use a UNIVERSAL INC file in the root of my
web
> IP
> > for the benefit of all my sub domains...
> >
> > Appreciate guidance!
> >
> > - Jason
> >
> >
>
>
|
| |
|
| |
|
Aaron [SQL Server MVP]
|
| Posted: 2004-8-3 0:50:00 |
Top |
asp >> Virtual Path and physical root
I've never used a local file path in a virtual include call. An #include
file is usually local, an #include virtual usually means relative (e.g. to
the root), which kind of precludes sticking a drive letter in front of it.
--
http://www.aspfaq.com/
(Reverse address to reply.)
<email***@***.com> wrote in message
news:email***@***.com...
> I tried it locally eg ="c\inetpub..." but got "page not found"......I am
> just trying to confirm whether one can actually use a phycial path in a
> virtual include..
>
> - Jason
> "Aaron [SQL Server MVP]" <email***@***.com> wrote in message
> news:u5%email***@***.com...
> > Did you try:
> >
> > <!--#include file=m:\html\root\include.asp-->
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
> >
> >
> > <email***@***.com> wrote in message
> > news:email***@***.com...
> > > Is it possible to include my remote web server path eg:
> m:/html/root/site1
> > > | m:/html/root/site2 etc
> > >
> > > ...in virtual includes....
> > >
> > > Thus eliminating the need to create duplicate INC files in each
> sub-domain
> > > on my remote web server host domain IP. eg: http://72.3.5.6.0
> > > (www.site1.com; www.site2.com)
> > >
> > > I would like to be able to use a UNIVERSAL INC file in the root of my
> web
> > IP
> > > for the benefit of all my sub domains...
> > >
> > > Appreciate guidance!
> > >
> > > - Jason
> > >
> > >
> >
> >
>
>
|
| |
|
| |
|
jason
|
| Posted: 2004-8-3 4:32:00 |
Top |
asp >> Virtual Path and physical root
Right.
Aaron, could you offer advice on a login system that is a pinch point for
all my sub-domains on a remote IP (remote web host:)
IP: HTTP://69.9.3
Sub-domain 1: www.site1.com
Sub-domain 2: www.site2.com
I wish to create a login system that sits in the root of the IP and enables
all my sub-webs to feed off it and its underlying database:
Logon: IP: HTTP://69.9.3/Logon.asp
Register: HTTP://69.9.3/Register.asp
My confusion is related in how to 'share' the common elements:
1. Database path:
2. Common inlcudes
3. Capture User Page selections:
a. TargetURL
B.FromURL
...when he logs onto the secure page.
I could use IP, but Curt has pointed out that providers like AOL use dynamic
DHCL which means all their users have the same address.
I could use session variables but then I only get his User Page Requestes
for the first secure page he logs onto
Do you have any advice on a logon system that allows me to secure basic .ASP
pages and capture their Target and From Urls?
Much appreciated
Jason
"Aaron [SQL Server MVP]" <email***@***.com> wrote in message
news:unL$email***@***.com...
> I've never used a local file path in a virtual include call. An #include
> file is usually local, an #include virtual usually means relative (e.g. to
> the root), which kind of precludes sticking a drive letter in front of it.
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>
>
> <email***@***.com> wrote in message
> news:email***@***.com...
> > I tried it locally eg ="c\inetpub..." but got "page not found"......I am
> > just trying to confirm whether one can actually use a phycial path in a
> > virtual include..
> >
> > - Jason
> > "Aaron [SQL Server MVP]" <email***@***.com> wrote in message
> > news:u5%email***@***.com...
> > > Did you try:
> > >
> > > <!--#include file=m:\html\root\include.asp-->
> > >
> > > --
> > > http://www.aspfaq.com/
> > > (Reverse address to reply.)
> > >
> > >
> > >
> > >
> > > <email***@***.com> wrote in message
> > > news:email***@***.com...
> > > > Is it possible to include my remote web server path eg:
> > m:/html/root/site1
> > > > | m:/html/root/site2 etc
> > > >
> > > > ...in virtual includes....
> > > >
> > > > Thus eliminating the need to create duplicate INC files in each
> > sub-domain
> > > > on my remote web server host domain IP. eg: http://72.3.5.6.0
> > > > (www.site1.com; www.site2.com)
> > > >
> > > > I would like to be able to use a UNIVERSAL INC file in the root of
my
> > web
> > > IP
> > > > for the benefit of all my sub domains...
> > > >
> > > > Appreciate guidance!
> > > >
> > > > - Jason
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
| |
|
| |
|
| |
|
Index ‹ asp |
- Next
- 1
- Creating Architecture Documents from Existing ApplicationHi,
we want to create some documentation of the architecture in an existing
ASP application. Can anyone suggest some document types to use to make
it easy to understand the application?
This could be UML type documents or otherwise.
- 2
- Asp In Head or BodyDear all,
I want to know the difference and effect of placing ASP
Code in the begining of .asp File and placing code inside <Head> </
Head> Tag and Placing code inside <body></body> tag. Just as
follows:
1. Placing code in the Begining of asp file
<% Response.write "Hello" %>
<head>....</head>
<body>....</Body>
2. Placing code in the Head
<head> <% Response.write "Hello" %> </head>
<body>....</Body>
3. Placing code in Body
<head>.....</head>
<body> <% Response.write "Hello" %> </body>
- 3
- adCurrency problem in ASPI'm using ADO from an ASP 3.0 page written in JScript to query a database
table in SQL Server 2000. One of the columns in a currency field.
Instead of retrieving a value of 1095.60 like I expect, I'm getting
1095.6000000000001 instead.
If I use other tools like Query Analyzer to run my select the value comes
out as I expect.
The type of the ADO field in my recordset is adCurrency as I expect.
Here's a short example of code that demonstrates the problem:
var strSQL = "select ItemPrice from dbo.item where ItemID = 5";
var oConn = Server.CreateObject("ADODB.Connection");
oConn.Open(getDBConnectionString());
var rs = oConn.Execute(strSQL);
while (!rs.EOF)
{
Response.Write(rs("ItemPrice").Value + "<br>");
rs.MoveNext();
}
rs.close();
oConn.close();
Am I doing something wrong here?
My DSN shows
Microsoft SQL Server ODBC Driver Version 03.85.1025
Is there a driver problem?
- 4
- Test if file exists before displaying with XMLHTTPI have a left menu that is accessed and displayed via XMLHTTP (it resides on
the same server). Some sections of the web site don't have a "menu.asp", so
a "Page Not Found" page is returned, which doesn't look great in the menu
column.. Is there a way to know if a page exists before using
xml.responseText to pull it?
(apart from checking the actual text of the returned page to see if it
contains error-like words)
Thanks
Giles
(PS using xmlhttp instead of server.execute as the menu-page needs
processing before displaying)
- 5
- mail body get truncated while using CDO in ASPHi
my scenario is
i ve upgraded my asp application to windows 2003 +IIS 6.0 + virtual
SMTP server enabled environment from win 2000.
so i need to update the mail procedure too.(becox i used CDONTs
previously which is not supported in win 2003 by default).i have coded
my mail sending script using CDO. The problem i am now facing is the
mail message which is generated by my application is get truncated at
the receiving end..
Also i want to mention the way i coded my mailing module.
i have a vbscript function to send email that uses CDO now
and mailsending script is being called by a javascript block where i am
concatenating the mail body.
Also i dont receive mails at some personal domains. at the same time
mail reaches free domains like yahoo,hotmail gmail.
can anyone help me in this regard.?
Thanx in advance.
- 6
- Search two tables and display resultsHi All
A tricky issue wonder if someone can help
I have two tables like this
TapeRecords
TapeID - Integer Primary key
Title - Text
TapeDetails
RecordId (Primary Key)
TapeId (related to the taperecords table)
ProgramDetails (Text)
The tape details table has a record of the programs that are stored on each
tape and each tape we have about 20 programs.
What i want my users it to allow them to search by programdetails and
display the list of tapes that match that search. I am not able to built a
query to search and display at the same time. Can someone help?
I am okay with ASP programming so if anyone has any suggestions or sample
code i will be pleased to hear from you.
- 7
- receive xml from https post in classic ASPHi all,
I am writing an ASP page which is listening and waiting to receive a xml
from third party vendor. I have googled for a while. It seems to me in ASP
page, if the vendor stores xml data in a field, say, XmltoTis, then I can do
the following.(please check for me if my understanding is right :=)
InputXMLValue=Request("XmltoTis")
Set objXMLDoc=Server.CreateObject("Microsoft.XMLDOM")
objXMLDoc=InputXMLValue
''from here I can start to parse the xml data, right
Set IncomeInfoRoot=objXMLDoc.documentElement
Set DescNode=IncomeInfoRoot.selectSingleNode("totalPayment")
Response.Write DescNode.Text & "<br>"
...
what about if they store xml in the body, what should I do in classic ASP. I
saw
in .net discussion forum, people can use Request.InputStream, but not sure
how can I deal with it in asp, not see this kind of discussion.
Can you shed a light on me?
Thanks.
--
Betty
- 8
- ASP/IIS communicating with a VB based executable on the webserver.I am test developing an internal webserver, on Windows XP, and IIS 5.1, with
ASP and MySQL.
One specific page is created from user input and database records in
previous pages and presents a page with customised data and a webform. It
then takes input from the form and session variables and passes these to an
vb exe in the the wwwroot using the from
http://localhost/example.exe?testparameters. The vb exe takes the command
line parameter input and does its thing and it all works, but I am aware
this is a very insecure way of doing this and I implemented this only as a
quick workaround so I could test implement it all then refine it for
deployment.
My question is, what is the best way for input to be passed from a web form
to an vb executable for it to do its thing. The exe will eventually
preferably run as a service, or at least all ways be active on the server,
and not starting for every request then ending, as I was hoping to allow for
sorting and queueing of requests passed to the exe, before they are
executed.
Obviously a model where the exe takes the input, does its thing, then ends
is not helpful.
I'm open to any and all suggestions, including completely different
approaches. I've heard of using COM or Active-X some how or other, but I
wanted to get some ideas before I commit myself to one route or another.
Thanks in advance
Gavin
- 9
- ASP Directory Listing!!!!I am running IIS and using asp, I want to be able to list a directory/
content of a folder using asp, and display it in a table using html.
I have seen many examples but have not been able to get them to work
All my html & asp are in a folder called webserver in the following
directory c:\Inetpub\wwwroot\
And I want to be able to display the content of a folder called folder which
is located within the webserver directory
I want to do it with asp instead of allowing directory browsing within IIS.
Can anyone help?
Thanks
- 10
- Online query analzyer for Access?What is the best way to create new queries and/or modify existing tables
within an online access database. At the moment, I am periodically
downloading the db and making alterations.
But, I have heard others on the list say they use a query analayzer built on
a <form> where they execute SQL statements....
Is this the correct way to go?
- Jason
- 11
- Adding Index Number to a Dynamic ArrayHi All,
I've probably done this before, but for the life of me I can't remember how
I did it. I need to move values from a DB table into an array to be used
for other queries. The number of records will vary, so I need to make the
array dynamic. Can someone remind me how I can increment the index when I
write a new record? Here's a sample of the code I wrote:
If rsGETKD.EOF = False Then
Dim KDLOTSQ
KDLOTSQ = rsGETKD.GetRows()
iRecFirst = LBound(KDLOTSQ, 2)
iRecLast = UBound(KDLOTSQ, 2)
iFieldFirst = LBound(KDLOTSQ, 1)
iFieldLast = UBound(KDLOTSQ, 1)
Dim KDLTable
MyCount = 0
For I = iRecFirst To iRecLast
MyText=""
For J = iFieldFirst To iFieldLast
MyText=MyText & KDLOTSQ(J, I)
Next
KDLTable(MyCount) = MyText
MyCount = MyCount + 1
Next
End If
What this code is supposed to do is read a DB table that contains two
values. These two values are written to another array (KDLTable) that I can
use as a reference later on in my ASP (I need to read this table four times
at four different record locations).
When I run this code, I get an "800a000d Type Mismatch" Error. Looking at
the code, the program breaks at "KDLTable(MyCount) = MyText". I'm sure the
program is failing when the system tries to use MyCount as the index number.
How can I increment the index number for each value in the table? For
example, if there are three records in the table, (ABC123, DEF456 and
GHI789), I would like to write in this manner:
KDLTable(0) = ABC123
KDLTable(1) = DEF456
KDLTable(2) = GHI789
Any ideas would be appreciated.
Thanks!
Brian.
- 12
- 13
- using variable in scriptusing access db and asp
i have a variable from a form
sRound = request.form("round") and for now let us say this value is 3
now i want to include that 3 in sql, but it is part of a field name which
is round3_report
cm.CommandText ="UPDATE rounds SET round" & sRound & "_report = '" & var5 &
"' WHERE Name ='" & sName & "' AND meeting = " & var4 & ""
cm.execute
this isn't working. i keep getting parameter error. i know there is a way to
join a word with a variable in order to make a field name in asp/sql, but I
don't remember how
can you help?
thanks
- 14
- Server side Tiff managementDear all,
I hit a problem about the Tiff management. I have several Tiff files located
at the server and I have to split and merge some of the files. Is there are
any plug-in for server side Tiff management? I found a plug-in "Tiff Merger"
but it is not working probably. Is there are any alternative for me? In
addition, is there any plug-in for merge and split action which is
supporting drag and drop?
Thanks
- 15
- ASP and ExcelHello,
in German ASP-Newsgroups nobody had an idea,
so I would like to ask the following here:
You can simply read the content of an Excel
worksheet via ASP by executing a sql-statement
like SELECT * FROM [Table1$A:E]
That works fine, but how can I search for one
special row for example ? I have tried
SELECT * FROM [Table1$A:E] WHERE [Table1$D] Like '" & searchstring & "%';
to search a string in column D, but it hadn't worked.
Anybody an idea ?
Maybe it is a question of the connection drivers ?
Should I use the Jet or the Excel drivers ? How
the connection-string would look like for the
sample above ?
Thanks for any help
Greetings
Thies
|
|
|
