On the asp page, how do I get the following to format as currency
when the page is run:

<%=FP_FieldVal(fp_rs,"L_PRICE")%>

As it is, the resulting output looks like:   125000.

I'd like the result to look like:  $125,000.

Yes, I'm new at this.

--- In AspClassicAnyQuestionIsOk@yahoogroups.com, "Charles M.
Carroll" <darthcarroll@l...> wrote:
> At 03:53 AM 2/3/2003 +0000, you wrote:
> >I'm rather new to ASP. I'm trying to get a value from one field in
> >one record (using the primary key to select) in an Access database
> >table, add 1 to that value, then write the new value to the same
> >record in the database table.
> >
> >1. I can't get it to select the proper record, it just selects the
> >first record.
> >2. I can get a value (just not from the right record) and
increment
> >the number, but it doesn't update the record.
>
> You don't say what code you are using to SELECT the one record and
delete it.
>
> If you do know the primary key the query:
>
> Update [accesstablename] SET [fieldname]=[fieldname]+1 where
[primarykey]=17
> will work.
>
> http://www.learnasp.com/learn/dbSQLdelete.asp
> has the typical code you need - conn.execute will do what you want.
>
>
>

Thanks for your help - found out it was a corrupted Access Table!

Critters

http://www.cdolive.com/autoreply.htm
will get you started. It is one of the many ZIPPED samples at that
excellent site that shows "mailbox walker" code.

At 06:06 PM 2/3/2003 +0000, you wrote:
>I am looking for a tutorial that shows me how to check someones
>exchange inbox for new messages. I am creating a customer feedback
>tracking system. I'd like users of the system to be alerted when
>there are new messages in a certain dumby account's inbox. I have
>seen only a thousand tutorials for sending e-mail, but how about one
>for logging in as dumby user and checking dumby users inbox? Thanks!
>
>
>To unsubscribe from this group, send an email to:
>AspClassicAnyQuestionIsOk-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>---
>[This E-mail scanned for viruses by Declude Virus]


---
[This E-mail scanned for viruses by Declude Virus]

Hello folks,

	 I wonder whether some kindly soul might lend an ear to my database upgrade
troubles. Some months ago the technicians at our server made a partial
conversion of our Access DB to SQL Server. Unfortunately, at the time we
were not ready to complete the operation. Since then our original Access DB
has accumulated new records, existing records have been edited, deleted, etc.
	 My question is: would it be better to erase the SQL Server database that
exists and effect the transfer from scratch; or should I attempt to write
ASP code to copy our Access records verbatim from one database to the
other? Considering that we host 2,400 artists in one table, and 10,000
pictures in another, the latter operation may take some time.
	 I would certainly prefer to just to erase the old SQL Server database and
make the conversion from scratch: however, I'm not sure of the best way to
do this. I don't have SQL Server installed at home - a bit beyond my budget
- and therefore don't have the opportunity to carry out a trial run. In any
case, I would still need to upload the SQL data from my home computer to
the server; which I am not sure how to do. (I have a feeling it wouldn't be
as simple as FTPing the Access .MDB file into a private directory.)
	 Our Access DB doesn't employ any built-in queries, macros, procedures,
etc. Our searches have been basic enough so far that they can be carried
out with SQL statements through an ODCB connection.
	 I could ask the technicians to convert the database again - at the cost of
several hundred dollars. But I would much prefer to learn how to perform
such an operation myself. In any case, they experienced problems
translating MEMO fields into a format SQL Server could interpret. In short,
if there are hurdles involved in the conversion, I would rather grapple
with them myself. Such is the path to experience.
	 Any suggestions would be most welcome.

	 thanks,
	 Iian

> Update [accesstablename] SET [fieldname]=[fieldname]+1 where
[primarykey]=17
> will work.

Here is my code for this section:

' read from database
readSQL = "SELECT * FROM StoCust WHERE Email = 'xyz@...';"
cnnStrCustDB.Execute (readSQL)
' convert from text to long integer
OrderNum = Clng(OrderNum)
'put value from field into variable
OrderNumber=rstStrCustDB.Fields("OrderNum").Value
' increment OrderNumber field
OrderNumber = OrderNumber + 1
' convert from long integer to text
OrderNumber = CStr(OrderNum)
' update table with new values
updateSQL = "UPDATE StoCust SET Email = 'xyz@...', OrderNum
= " & OrderNumber "'"

I don't want to delet the record, just update it with the new
OrderNum value.

BTW, that's a great website.  I'll be using it!

I am looking for a tutorial that shows me how to check someones
exchange inbox for new messages. I am creating a customer feedback
tracking system. I'd like users of the system to be alerted when
there are new messages in a certain dumby account's inbox. I have
seen only a thousand tutorials for sending e-mail, but how about one
for logging in as dumby user and checking dumby users inbox? Thanks!

I am looking for a tutorial that shows me how to check someones
exchange inbox for new messages. I am creating a customer feedback
tracking system. I'd like users of the system to be alerted when
there are new messages in a certain dumby account's inbox. I have
seen only a thousand tutorials for sending e-mail, but how about one
for logging in as dumby user and checking dumby users inbox? Thanks!

Dear All,

I have an ASP file containt the following code which is not working
fine. Only the HTML part displayed. No ASP part diplayed. Some
nothing will de displayed....this case I can see the message on
status bar "connecting to site <computername>"

Appreciate if you could help me....

<html>
	 <head><title>This is the First ASP test</title>
</head>

<body>

	 This is the first line of the page <br>

	 This is the 2nd line of the page <br>
	 This is the 3rd line of the page <br>

<%
x = 10*30
Response.Write "The Product of 10 and 30 is :" & x
Response.Write "The Product of 10 and 30 is :" & x
%>



</body>
</html>

Rgds -Ahmed

--- In AspClassicAnyQuestionIsOk@yahoogroups.com, "Charles M.
Carroll" <darthcarroll@l...> wrote:
> At 03:53 AM 2/3/2003 +0000, you wrote:
> You don't say what code you are using to SELECT the one record and
delete it.
>
> If you do know the primary key the query:
>
> Update [accesstablename] SET [fieldname]=[fieldname]+1 where
[primarykey]=17
> will work.
>
> http://www.learnasp.com/learn/dbSQLdelete.asp
> has the typical code you need - conn.execute will do what you want.
>
>
>
Here is my code for this section:

' read from database
readSQL = "SELECT * FROM StoCust WHERE Email = 'xyz@...';"
cnnStrCustDB.Execute (readSQL)
' convert from text to long integer
OrderNum = Clng(OrderNum)
'put value from field into variable
OrderNumber=rstStrCustDB.Fields("OrderNum").Value
' increment OrderNumber field
OrderNumber = OrderNumber + 1
' convert from long integer to text
OrderNumber = CStr(OrderNum)
' update table with new values
updateSQL = "UPDATE StoCust SET Email = 'xyz@...', OrderNum
= " & OrderNumber "'"

I don't want to delet the record, just update it with the new
OrderNum value.

BTW, that's a great website.  I'll be using it!

At 03:53 AM 2/3/2003 +0000, you wrote:
>I'm rather new to ASP. I'm trying to get a value from one field in
>one record (using the primary key to select) in an Access database
>table, add 1 to that value, then write the new value to the same
>record in the database table.
>
>1. I can't get it to select the proper record, it just selects the
>first record.
>2. I can get a value (just not from the right record) and increment
>the number, but it doesn't update the record.

You don't say what code you are using to SELECT the one record and delete it.

If you do know the primary key the query:

Update [accesstablename] SET [fieldname]=[fieldname]+1 where [primarykey]=17
will work.

http://www.learnasp.com/learn/dbSQLdelete.asp
has the typical code you need - conn.execute will do what you want.






---
[This E-mail scanned for viruses by Declude Virus]

I'm rather new to ASP. I'm trying to get a value from one field in
one record (using the primary key to select) in an Access database
table, add 1 to that value, then write the new value to the same
record in the database table.

1. I can't get it to select the proper record, it just selects the
first record.
2. I can get a value (just not from the right record) and increment
the number, but it doesn't update the record.

Please help if you can,

Thanks,

Critters

We need to see both code samples to see what they are actually doing. There
are some subtle details to how the code works we can't know unless we see it.

Then we can determine what your test really means.

BTW "chunking" the Getrows/Getstring is accomplished with code like this:

rstemp.cachesize=1000
DO WHILE rstemp.eof
          alldata()=rstemp.getstring(1000)
LOOP


At 10:24 PM 1/31/2003 +0000, you wrote:
>    > To give you an idea on performance differences, I have two
>    > identical scripts, except that one uses GetRows and the other
>    > GetString. They retrieve email records from SQL Server and then
>    > dump them out in plain text in the browser.
>    >
>    > 20000 Rows Displayed
>    > ----------------------------
>    > GetRows: 1 Second
>    > GetString: 5 Seconds
>    >
>    > 87000 Rows Displayed
>    > ----------------------------
>    > GetRows: 6 Seconds
>    > GetString: 88 Seconds


---
[This E-mail scanned for viruses by Declude Virus]

1. More RAM
2. chunked GetStrings
     with .cachesize matching size of chunks.

I assume backend is SQLServer - you should join us @
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
to discuss how to optimize your code. I have a bunch of
ideas but it makes more sense to get several brains involved.

Is buffering true?
http://www.learnasp.com/advice/whybuffer.asp
discusses the importance of this.

    > At 06:54 PM 1/30/2003 -0800, you wrote:
    >
    > Hi Charles,
    >
    > I love your site LearnAsp.com. I wish I had studied it
    > earlier.... could have saved me a lot of grief.
    >
    > Anyway, I've been on a mission as of late to find the fastest
    > DB method in ASP for displaying very large amounts of data. I'm
    > talking about 100,000+ records.  I've known about GetRows for a
    > while and always had a hunch that it was one of the better
    > methods. More recently, I've been learning about GetString and
    > tried some experiments with it. I'll be studing your RSFAST
    > library tomorrow... (it looks great!)
    >
    > For the most part, I found GetString works well up to about a
    > 1000 or so records, after which performance seems to degrade
    > almost exponentially. My guess is that the (horribly expensive)
    > string concatenations that are probably happening "under the
    > hood" start bogging down the performance as the resultant
    > string continues to grow to enormous sizes. This goes along
    > with the common wisdom that's it usually better to have more
    > response.writes then to use expensive string concatenations to
    > build up one large string and spit it out with one
    > response.write.
    >
    > To give you an idea on performance differences, I have two
    > identical scripts, except that one uses GetRows and the other
    > GetString. They retrieve email records from SQL Server and then
    > dump them out in plain text in the browser.
    >
    > 20000 Rows Displayed
    > ----------------------------
    > GetRows: 1 Second
    > GetString: 5 Seconds
    >
    > 87000 Rows Displayed
    > ----------------------------
    > GetRows: 6 Seconds
    > GetString: 88 Seconds
    >
    >
    > I was just wondering if you have had similar experiences with
    > GetString or if I may be doing something wrong.
    >
    > Thanks for your time!
    >
    > John

At 02:35 PM 1/30/2003 -0500, you wrote:
>At 03:24 PM 1/30/2003 +0000, you wrote:
> >Hi Everyone;
> >
> >FIRST QUESTION
> >===============
> >My first question is what happened to those other asplists like
> >aspnewbie aspandsql aspexperts etc etc etc. I don't see it anywhere.
> >Did charles carroll get rid of it for some reason?

BTW I really miss [AspSQLHowto] and [aspSQLserver] and [aspnetSQLserver]
and quite a few of the old groups but I must confess I am limiting my list
creation to those closest to my heart and trying to participate on lists
and communities rather than create them. (I have myself on a strict
"creating 3 groups or less per month diet MAX" so I can participate more)

It is FREE and EASY to start your own YahooGroups and takes about 5 minutes
- so HINT HINT YOU can create any you miss HINT HINT. If any of you create
YahooGroups for lists you really miss I will promote them here as you can
promote them here as well. I was shocked at how easy and convenient it is
and although it does not have everything Lyris has it has Polls, Links and
other goodies Lyris did not and it is FREE!!!!! In the case of Foreign
language lists and some technical lists, in many cases if I trust you
because of past AspFriend's contributions I will actually "invite" the
members from the old AspFriends lists to yours with my copy of the database
because I know the community really needs some of these resources.

At:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/links
for example and my main page I do promote the various Groups/Lists out
there. I will put together initial links on this Classic List tonight and
updated as people let me know about new lists.

By each of us creating a list closer to our passions we gain a little fame
and they are easy to manage. I love the "Yahoo My Groups" feature for
example. The lists don't even have to be as strongly pre-moderated as
AspFriends lists since people after several years really seem to "get"
managed lists divided by topic and behave well in my opinion.

---
[This E-mail scanned for viruses by Declude Virus]

http://www.aspsimply.com/

It is unbelievable how much good material is there.

---
[This E-mail scanned for viruses by Declude Virus]

At 03:24 PM 1/30/2003 +0000, you wrote:
>Hi Everyone;
>
>FIRST QUESTION
>===============
>My first question is what happened to those other asplists like
>aspnewbie aspandsql aspexperts etc etc etc. I don't see it anywhere.
>Did charles carroll get rid of it for some reason?

I started http://groups.yahoo.com/group/MicrosoftCommunityComments
to discuss the many negative things I saw MS do from 1997-2002 that caused
me to be unwilling to go as far building a MS community as I have in past.
And hopefully to give others an outlet to discuss things they see at
Microsoft that worry them that will go censored in the
http://www.asp.net/forums and http://www.aspadvice.com (the ASP.net Forums
are heavily censored privately and publicly*) This list is really for
questions and answers, not a discussion of how MS treats the community.

I closed them because the 900+ lists took over 120 hours a month of my time
(moderating, tracking down email delivery complaints, writing utilities to
manage the searches and complex issues, etc. and several hundred hours of
volunteer time some months as well). The 18 gig SQLserver database and 20
million messages a month were a tremendous amount of $$$ per month
($3,000/month hosting fees) and programming headaches to write and maintain
searches, troubleshoot delivery problems, etc.I did it and spent over
$100,000 in cash in the 3+ years I ran it as gift to the community and
Microsoft because I love their software. Someone who has not run a project
of this size cannot imagine the technical complexity of such a venture and
the time drain. I loved it but it was the hardest task I ever took on in my
life.

* For example even though I have no history of EVER posting a single
negative message on the ASP.net forums and invented the AspAce =>
http://www.AspElite.com honorable title that gets 40 AspElite to Seattle
twice a year to meet with the ASP.net team and see beta products and test
them early so the customers have more community volunteers with months of
experience attained befoer the products formally beta, I was excluded from
all private forums and ASP.net 2.0 beta previews, etc. the moment I refused
to consider the absurd contract MS used to try to acquire AspFriends.com.
Even though I never recieved a dime of MS funding in my life - they felt
their assistance with less than 20% of the fees to ISPs over a 3 year
period entitled them to takover AspFriends.com and snatch the community's
archive messages and email addresses. And if I objected and tried to close
to protect the community email addresses from being owned by Ms to be
spammed at will and the archives taken from the 30+ AspElite volunteers and
myself who worked our butts off for years with no reward except the
satisfaction of helping.

Prior to 2000 I had minimal dealings with MS. But in 2000-2002 I spent more
time in Redmond and came to learn why everyone hates Microsoft no matter
how good their software is - the ASP.net team (primarily Rob Howard and
Scott Guthrie) flat out promised me several things ($114,000 of concrete
promises via face-to-face meetings and cell phone calls) and broke almost
every promise they made, and later even lied about making the promises and
attempted to make me the bad guy publicly and privately. In fact in my 2+
years dealing with the ASP.net team I spent much much money - and gained $0
from my relationship - in fact I found it took dozens of emails to get the
simplest things done - and have the time MS employees never even kept their
end of the bargain after dozens of promises and emails. They actually said
they love to support the community yet failed to do much to support the
community in terms of MSDN links, MVP promotions, etc. in atimely nd
reasonable manner. Ethically these are not the kind of people I can support
120 hours a month and spending lots of money out of my own pocket to
support. I don't deal with liars or unethical people and keeping AspFriends
open would involve dealing with them and signing a contract that risked all
AspFriends messages, contract and volunteer work as becoming Microsoft
property.

So I scaled back the kind of support I do so it could be done inexpensively
and easily and the time I spent could be spent helping the community in a
fast effective way without devoting the resources I was every month to
managing infastructure. I wanted to answer questions 100 hours a month and
write FAQs and tutorials based on what I saw on the lists not manage the
massive infrastructure AspFriends had become.

The FAQ @
http://www.learnasp.com/aspfriendshome/faq.aspx
explains some of this but is incomplete and does not detail all of the Rob
Howard/Scott Guthrie fiasco. I will get it totally up-to-date in a few
days. I think people should know how MS mistreats its closest allies so
they realize that even great software will run into barriers if it's
creators are dishonest and predatory to their most vehement supporters.

I did find some good MS employees. Omri Gazit, Ben Miller, Rob Caron and
quite a few others. But the were outnumbered at a 100:1 ratio with MS
employees who really put barriers up towards getting involved and linking
to the community through negligence and just plain deceit.

I love ASP.net and Classic ASP and it pained me greatly that the community
of 69,000 unique members, 900+ lists and 20 million messages a month could
not continue for so many reasons but the deceit and draconian contract
proffered by those 2 was just not the kind of treatment I expected given my
high sacrifice to help ASP.net succeed because I liked it. My Classic ASP
classes in 1996 started slow with 2-3 students but by 97 all classes were
8-12 students deep - that is the nature of beta/1.0 products. ASP.net
starts off equally slow with added burden of awful economy and few students
travelling after 9/11 - but I also had this huge time and money commitment
that was being taken out of my retirement savings with hope that 2003 would
make up the difference and I could replenish my retirement - but I can't
invest on that scale if Ms makes my volunteer work really hard and I
suddenly have to pay lawyers to review contracts to protect myself from MS,
etc.

Scott and Rob have however given all the $$$ and creative support they were
supposed to give to me to AspAdvice.com - because Steve Smith Is dumb
enough to sign their contracts and he is a "Yes Man" who will help them
censor the lists as they need. Steve tried to keep this a secret from most
of the AspAdvice supporters until I publicly spilled the beans on my
"Community" tab on main page and pretended all the funding (18k Lyris
licenses, 2 dedicated servers, etc.) was out of his pocket but the money is
straight from MS.

I am a participant on http://www.AspAdvice.com, the
http://www.ASP.net/forums. P2p, etc. because helping the community in any
form is fine.

I recommend that further in-depth discussion of this occur @
http://groups.yahoo.com/group/MicrosoftCommunityComments
so as not to bore the people here who only want => ASP Classic Questions
and Answers <=


---
[This E-mail scanned for viruses by Declude Virus]

At 03:24 PM 1/30/2003 +0000, you wrote:
>Hi Everyone;
>
>SECOND QUESTION
>===============
>Second question is ASP related.
>
>I just want to double check my premises regarding SSL and asp form
>data submission.
>
>Premise #1
>A Form Submission is only secure when the form's page is initially
>secure, the user fills in the form (ei social security, credit card#)
>and then submits to a secure page (as identified by the https
>protocol in the URL and the closed lock). after they sumbit to the
>secure page, any redirection after that point to an unsecure page is
>okay. The social security and card is secure.
>
>Is this correct?

Yes.

The way I explain it to people is to have them go to "cmd" prompt and
tracert to their site. i.e.
tracert learnasp.com
on my machine results in
*********************************************************************
    1     2 ms     2 ms     2 ms  207.233.209.129
    2    18 ms    18 ms    17 ms  207.233.254.1
    3    17 ms    18 ms    18 ms  F1-0.crva003.centrivity.net [207.233.168.6]
    4    18 ms    18 ms    18 ms  gige5-0-170.ipcolo2.Washington1.Level3.net
[166.
90.148.89]
    5    18 ms    18 ms    18
ms  gigabitethernet7-1.core2.Washington1.Level3.net [64.159.18.70]
    6    24 ms    19 ms    19 ms  qwest-level3-oc48.Washington1.Level3.net
[209.244.219.182]
    7    19 ms    19 ms    20 ms  dca-core-01.inet.qwest.net [205.171.209.45]
    8    26 ms    29 ms    29 ms  dca-core-02.inet.qwest.net [205.171.9.6]
    9    35 ms    35 ms    36 ms  atl-core-02.inet.qwest.net [205.171.8.153]
   10    35 ms    35 ms    35 ms  atl-edge-17.inet.qwest.net [205.171.21.186]
   11    40 ms    42 ms    40 ms  63.148.129.70
   12    40 ms    41 ms    41 ms  66.129.64.5
   13    44 ms    50 ms    44 ms  66.129.112.188
   14    54 ms    44 ms    45 ms  aspng.com [66.129.68.15]

Trace complete.
*******************************************

Any time a form that is HTTP interacts with my site any of those
"middlemen" could intercept the data.
HTTPS they could intercept the data but it would be encrypted and be much
harder for them to extract any of the real form data (credit card numbers,
text, etc.)

>Permise #2
>SSL does not prevent the URL from being picked up on the wire but
>simply encrypts the submission of form data over the internet to the
>web server.  Therefore a hacker could sniff and determine that you
>have just submitted form data to
>https://mysite.com/recieveformdata.asp?
>querystringval_1=x&querystringval_2=y&querystringval_3=z
>But they will be not able to determine the contents of the form
>submission.
>
>Is this correct?


Yes.

---
[This E-mail scanned for viruses by Declude Virus]

--- In AspClassicAnyQuestionIsOk@yahoogroups.com, "stephen
<stephensutherland@y...>" <stephensutherland@y...> wrote:
--------<% Snipped %<------------
> SECOND QUESTION
> ===============
> Second question is ASP related.
>
> I just want to double check my premises regarding SSL and asp form
> data submission.
>
> Premise #1
> A Form Submission is only secure when the form's page is initially
> secure, the user fills in the form (ei social security, credit
card#)
> and then submits to a secure page (as identified by the https
> protocol in the URL and the closed lock). after they sumbit to the
> secure page, any redirection after that point to an unsecure page
is
> okay. The social security and card is secure.
>
> Is this correct?
>
> Permise #2
> SSL does not prevent the URL from being picked up on the wire but
> simply encrypts the submission of form data over the internet to
the
> web server.  Therefore a hacker could sniff and determine that you
> have just submitted form data to
> https://mysite.com/recieveformdata.asp?
> querystringval_1=x&querystringval_2=y&querystringval_3=z
> But they will be not able to determine the contents of the form
> submission.
>
> Is this correct?
>
> Thanks in advance
> stev

AFAIK the way SSL works is that when the browser parses the URL and
when it sees https:, it first establishes a secure connnection
between itself and https://mysite.com. Once the connection is
established, then it passes the rest of the URL encrypted. This is
all done via port 443 by default.  If a redirection occurs to a non
ssl URL [ http://mysite.com/redirected.asp?..... it goes via port
80. There is no mixing and matching. Sometimes you go htps: URLs and
your browser popsup messages  about leaving a secure site noramlly
because <img src= referencecs use full URLs in the form of
http://..... so the browser uses normal http over port 80 to get
tose items.

Hope this helps.

Hi Everyone;

FIRST QUESTION
===============
My first question is what happened to those other asplists like
aspnewbie aspandsql aspexperts etc etc etc. I don't see it anywhere.
Did charles carroll get rid of it for some reason?

SECOND QUESTION
===============
Second question is ASP related.

I just want to double check my premises regarding SSL and asp form
data submission.

Premise #1
A Form Submission is only secure when the form's page is initially
secure, the user fills in the form (ei social security, credit card#)
and then submits to a secure page (as identified by the https
protocol in the URL and the closed lock). after they sumbit to the
secure page, any redirection after that point to an unsecure page is
okay. The social security and card is secure.

Is this correct?

Permise #2
SSL does not prevent the URL from being picked up on the wire but
simply encrypts the submission of form data over the internet to the
web server.  Therefore a hacker could sniff and determine that you
have just submitted form data to
https://mysite.com/recieveformdata.asp?
querystringval_1=x&querystringval_2=y&querystringval_3=z
But they will be not able to determine the contents of the form
submission.

Is this correct?

Thanks in advance
stev

Hi

My company has 'inherited' hosting of a web site that was built by a
now-failed dot-com - which unfortunately means that the original
developers aren't around to ask questions of. The site is built
in "traditional" ASP (with a few pages of ColdFusion thrown in...
don't ask :-) and uses an Access 97 database. The organisation the
site was built for has an Access 97 application in-house that they
replicate bi-directionally to the web site in what seems a peculiar
way; the web site has an administration page routine that queries the
database for new or updated entries and places these into
a "transfer" database (a separate .mdb file). This is downloaded
through ASP SmartUpload as a MIME type "application/msdownload". They
do a synchronisation into their in-house application with this file
and then upload, again via ASP SmartUpload, the resultant .mdb to the
web site, the relevant ASP page deleting the prior .mdb file first.
The problem is that the upload fails consistently writing the file to
disk (although it does appear to transfer the file to the server)
with an apparent permission error message, as follows:

Microsoft JScript runtime error '800a0046'
Permission denied
/content/admin/import.asp, line 25

The relevant ASP code page is included below. This code is correctly
called from a form page. The download works fine but uses a
completely different mechanism of course (just a link to the file on
the server), on a different page. It may or may not be relevant that
the download script is the immediate prior (web site) step as it's
not clear if the lock placed by it on the database is being correctly
released. This code is also included for completeness (just in case).
I've also anonymised the code in a couple of places to protect the
guilty.

This doesn't seem to actually be a permissions problem in any of the
database and site directories as all users (including the IUSR-
machinename and IWAM-machinename) have been given full access on the
entire tree for both (the database root dir is outside the inetpub
root). The issue would seem to be that there is still an Access .ldb
in existence and it is preventing the deletion of the "old" .mdb
file. There is a Technet article referencing adding the user account
into the Local Administrators group but since the account in question
is the IUSR-machinename, for obvious reasons I am extremely reluctant
to do this.

I've extensively searched Technet and other places and can't find a
resolution to this so far. I've also tried everything I can currently
think of to fix this, so if anyone can assist I'd be most grateful.

By the way, yes we know this is a horrible way to do it and have told
the client but they won't redevelop into SQL Server at present and we
don't in good conscience want to send them off to another host
without some kind of resolution.

The upload script that is failing on line 25:

<%@ language="JavaScript"%>
<% Session("lockOverride") = true; %>
<!-- #include file="../include/site.asp" -->
<%
checkAdminLogin();

// Close all database connections
closeDBConnections();
fs = Server.CreateObject("Scripting.FileSystemObject");
//Response.Write("Started\n");
newDatabaseFile = "new-" + databaseFile
//Response.Write("newDatabaseFile=" + newDatabaseFile + "\n");
if (fs.fileExists(databaseDir + "\\" + newDatabaseFile))
	 fs.deleteFile(databaseDir + "\\" + newDatabaseFile);

Server.ScriptTimeout = 60 * 60 * 3;  // three hours
up = Server.CreateObject("aspSmartUpload.SmartUpload");
up.DenyPhysicalPath = false;
up.AllowedFilesList = "mdb";
up.Upload();
up.files(1).saveAs(databaseDir + "\\" + newDatabaseFile);
//Response.Write("Save complete\n");

if (fs.fileExists(databaseDir + "\\" + databaseFile))
	 fs.deleteFile(databaseDir + "\\" + databaseFile); // Line 25
//Response.Write("Delete existing database complete\n");

fs.moveFile(databaseDir + "\\" + newDatabaseFile, databaseDir + "\\"
+ databaseFile);
//Response.Write("Rename new to clientname.mdb complete.\n");

Application("locked") = false;

Response.redirect("DSNKiller.cfm?
Action=enable&Location=dspImport.asp");

// This appears to have been an attempt to reduce/remove the problem
// by disestablishing and then resetablishing the ODBC connection

%>

The download script that is run before the script above (works ok):

<%@ language="JavaScript"%>
<% Session("lockOverride") = true; %>
<!-- #include file="../include/site.asp" -->
<%
checkAdminLogin();

outConn = Server.CreateObject("ADODB.Connection");
outConn.Open("clientnameOut");

exportTable("news");
exportTable("positionCategory");
exportTable("position");
exportTable("registrationCategory");

exportCanTable("candidateNationality");
exportCanTable("workHistory");
exportCanTable("licences");
exportCanTable("hoursEtc");
exportCanTable("medicalCert");
exportCanTable("candidateLicence");
exportCanTable("candidateAirframe");
exportCanTable("candidateEngine");
exportCanTable("candidateAvionics");
exportCanTable("candidate");
outConn.close();

// Close all database connections
closeDBConnections();

// Response.write("database dir = " + databaseDir + "
outgoingDBFile = " + outgoingDBFile + "<br>");
// Response.write(databaseDir + "\\" + outgoingDBFile + "<br>");

up = Server.CreateObject("aspSmartUpload.SmartUpload");

up.DownloadFile(databaseDir + "\\" +
outgoingDBFile, "application/msdownload");


function exportCanTable(table) {
	 outConn.execute("delete from " + table);
	 var newbies = openSQL("select " + table + ".*, ncType from "
+ table + ", newCandidate nc where " +
		 table + ".cdID = nc.cdID");
	 var out = CreateRecordSet();
	 out.Open(table, outConn, adOpenKeyset, adLockOptimistic,
adCmdTable);
	 while (!newbies.eof) {
		 out.addNew();
		 for (var ii = 0; ii < newbies.fields.count; ii++)
			 if (newbies.fields(ii).name != "ncType")
				 out.fields(newbies.fields(ii).name) =
newbies.fields(ii);
		 if (table == "candidate")
			 out.fields("recordType") = newbies.fields
("ncType");
		 out.update();
		 newbies.movenext();
	 }
	 out.close();
}

function exportTable(table) {
	 outConn.execute("delete from " + table);
	 var newbies = openSQL("select * from " + table);
	 var out = CreateRecordSet();
	 out.Open(table, outConn, adOpenKeyset, adLockOptimistic,
adCmdTable);
	 while (!newbies.eof) {
		 var names = new Array();
		 var values = new Array();
		 for (var i = 0; i < newbies.fields.count; i++) {
			 names[names.length] = newbies.fields(i).name;
			 if (newbies.fields(i).type == 200 ||
newbies.fields(i).type == 201)
				 values[values.length] = SQLString
(newbies.fields(i));
			 else
				 values[values.length] = newbies.fields
(i);
		 }
		 var sql = "insert into " + table + " (" + names.join
(",") + ") values (" + values.join(",") + ")";
		 outConn.execute(sql);
		 newbies.movenext();
	 }
	 out.close();
}
%>

Many thanks in anticipation.

Hi Ann,

Take a look at whats available at aspin.com:
   http://www.aspin.com/home/webapps/instantw

  ... Mike
http://aspalliance.com/mbrink1111/


--- ann aloy <ann_aloysius@...> wrote:
>
> sir
>
>  i am currently doing a project on creation of a frienship club web
> site .i would like to view a sample site which has used VBScript.
>
> ann
>
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

sir

 i am currently doing a project on creation of a frienship club web site .i would like to view a sample site which has used VBScript.

ann

DIM mynum   implies/equals Dim mynum as object

use
DIM mynum as long
instead.

At 05:43 PM 1/27/2003 +0000, you wrote:
>Dear All
>I have a function, it accepts LongInt's as one of the variables.  If I pass
>myFunc(30) to the function it works fine but if I set myNum = 30 and then
>pass this, it fails.
>
>call myFunc(30)
>is good
>
>but
>Dim myNum
>myNum = 30
>call myFunc(myNum)
>
>and it fails!  ANY ideas!?  Please help, thanks
>Neal
>
>***********************************************************************
>This e-mail, and any attachment, is privileged information and its
>contents are confidential to the intended recipient at the e-mail
>address to which it has been addressed. It may not be disclosed to or
>used by anyone other than this addressee.  If received in error, please
>contact Learning & Teaching Scotland on +(44) 141 337 5000 or e-mail
>enquiries@..., quoting the name of the sender and the
>addressee, and then delete it from your system.
>Please be aware that, although all reasonable steps have been taken,
>neither Learning & Teaching Scotland nor the sender is able to accept
>any responsibility for viruses.
>No contracts may be concluded on behalf of Learning & Teaching
>Scotland by means of e-mail communications.
>The contents of this message may contain personal views which are not
>the views of Learning & Teaching Scotland, unless specifically stated.
>**********************************************************************
>
>To unsubscribe from this group, send an email to:
>AspClassicAnyQuestionIsOk-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>---
>[This E-mail scanned for viruses by Declude Virus]


---
[This E-mail scanned for viruses by Declude Virus]

Dear All
I have a function, it accepts LongInt's as one of the variables.  If I pass
myFunc(30) to the function it works fine but if I set myNum = 30 and then
pass this, it fails.

call myFunc(30)
is good

but
Dim myNum
myNum = 30
call myFunc(myNum)

and it fails!  ANY ideas!?  Please help, thanks
Neal

***********************************************************************
This e-mail, and any attachment, is privileged information and its
contents are confidential to the intended recipient at the e-mail
address to which it has been addressed. It may not be disclosed to or
used by anyone other than this addressee.  If received in error, please
contact Learning & Teaching Scotland on +(44) 141 337 5000 or e-mail
enquiries@..., quoting the name of the sender and the
addressee, and then delete it from your system.
Please be aware that, although all reasonable steps have been taken,
neither Learning & Teaching Scotland nor the sender is able to accept
any responsibility for viruses.
No contracts may be concluded on behalf of Learning & Teaching
Scotland by means of e-mail communications.
The contents of this message may contain personal views which are not
the views of Learning & Teaching Scotland, unless specifically stated.
**********************************************************************

----- Original Message -----

From: yarmkn <yarmkn@...>

To: AspClassicAnyQuestionIsOk@yahoogroups.com

Sent: Monday, January 27, 2003 8:46 AM

Subject: [AspClassicAnyQuestionIsOk] ASP code not executed on Windows XP 2001

Hi, I am Using Windows XP Professional Edition 2001. I got some
assignment of ASP, but I can't execute it. As I mentioned I am using
Windows XP Professional 2001 Edition. Please give me some guidance in
datails. Thankx.



To unsubscribe from this group, send an email to:
AspClassicAnyQuestionIsOk-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Dear Pals,

What I need help from you is the following:

1) I am using CAPICOM in ASP and am trying to get the
    Data decrypted at server-end using CAPICOM.DLL.

I am failing to invoke the server-side DLL

Theerfore I made a DLL which would invoke CAPICOM and am assing
parameters from the client to that DLL but it is failing to call
CAPICOM.

No error message is there.

Just a blank screen is visible.


Can anyone help me?

regards

Harnath

Hi, I am Using Windows XP Professional Edition 2001. I got some
assignment of ASP, but I can't execute it. As I mentioned I am using
Windows XP Professional 2001 Edition. Please give me some guidance in
datails. Thankx.

All my testing could not reproduce the problem using exactly same code.

Check the following:

1. Tools; Privacy setting in IE to see if youhave disabled cookies.

2. Add the following to your second piece of code to see what cookies are
on the machine, i.e.

          For Each cookie in Response.Cookies
                  response.write "cookie name=" & cookie & "<br>"
                  response.write "cookie expires=" &
Response.Cookies(cookie).Expires = now()+365 & "<hr>"
           Next

These things will get us further.

A "out in left field" question. Is <%rosponse.buffer=true%> set on page?


At 01:52 PM 1/26/2003 -0300, you wrote:
>im doing some cookies tests and i have the following
>problem:
>my page cookies1.asp:
><%
>response.cookies("teste")("teste1") = "testando"
>response.cookies("teste").expires = now() + 365
>test = request.cookies("teste")("teste1")
>response.write test
>%>
>it works ok, it writes and reads the cookie.
>
>but when i have the second page:
>my page cookies2.asp:
><%
>test = request.cookies("teste")("teste1")
>response.write test
>%>
>
>i can not read the cook i wrote in the first file.
>does anyone know what the problem is ?


---
[This E-mail scanned for viruses by Declude Virus]

im doing some cookies tests and i have the following
problem:
my page cookies1.asp:
<%
response.cookies("teste")("teste1") = "testando"
response.cookies("teste").expires = now() + 365
test = request.cookies("teste")("teste1")
response.write test
%>
it works ok, it writes and reads the cookie.

but when i have the second page:
my page cookies2.asp:
<%
test = request.cookies("teste")("teste1")
response.write test
%>

i can not read the cook i wrote in the first file.
does anyone know what the problem is ?

thanks,
Erick

_______________________________________________________________________
Busca Yahoo!
O serviço de busca mais completo da Internet. O que você pensar o Yahoo!
encontra.
http://br.busca.yahoo.com/