Webmaster Tracker :: There are Better Ways to Search!

I am currently writing a little gadget where users can create, delete, alter... tables in a database. Some kind of MyAspAdmin... Everything works fine as long as I specify the MSSQL-Login-Infos database, user and password.

But if I want to make it possible to switch from one database to another, here comes the problem: The user has to choose a database that he wants to work in, and type in user and password.

I need the (probably very easy) solution, how i can check if this user/password/chosen_database combination is correct. Code:

I have seen a code to populate a list box from a data base table. Earlier I gave my own values using HTML coding like :

<Option Value="P-159">P-159</Select>. It was working fine but not after using code to build a list box, it is not coming in form value as input and next redirecting page retutns with error:

two codes pages are attached : profile page and search page. Profile page sends input to search page and search pages returns the output.

Basically, I have a dataset I need to send to a vendors site. They
have a page that will accept from form posts. What I'm trying to
figure out is how to loop through and submit form data when I do not
have control of the end site.

My basic idea is to have a page that will cycle through the dataset
put into invisible form fields and submit to the site (many times
over). Is this possible through asp?

I've come across some weird bug with Response.Cookies. Or maybe it will be
called "by design" but for the life of me I can't figure out what purpose it
would serve. If you're setting a cookie (say Response.Cookies ("TEST")) and
you have a query string variable &test=x or &Test=x and you get
Request.QueryString to parse the query string, the cookie that gets dropped
matches the case of the query string, not what your code says. In other
words even though the code says Response.Cookies ("TEST"), it drops
Response.Cookies ("test") instead.

Anyone have any idea what's going on here? There's an example below. Try
it with http://127.0.0.1/cookieTest.asp?test=x and without the query string
variable.

<%@Language=Jscript Enablesessionstate=false%>
<%var exp = new Date();
exp.setTime(exp.getTime() + (2 * 365 * 24 * 60 * 60 * 1000))
var expDate = (exp.getUTCMonth()+1) + "/" + exp.getUTCDate() + "/" +
exp.getUTCFullYear()

var x = Request.QueryString ("dummy");
Response.Cookies("TEST") = "This is a test";
Response.Cookies("TEST").Expires = expDate;
%>

CDO is perhaps the most obscure art in web programming, but I hope someone
would understand my issue. I have an ASP web application that needs to send
email messages in HTML format only -- there is no plain text version. The
messages are summaries of answers that people have input into an online
survey, and need to have a tabular form.

The following somewhat plausible code does not work:

dim OMsg
Set OMsg = Server.CreateObject("CDO.Message")
OMsg.Fields("urn:schemas:mailheader:return-path") = BounceEmail
OMsg.Fields("urn:schemas:mailheader:content-type") = "text/html"
OMsg.Fields.Update

The return path header is set as desired, but the content type header
stubbornly defaults to "text/plain". What is the secret to setting that
header?

I have seen lots of code examples on the MSDN site for setting the
content-type of body parts, but it seems needlessly complicated for my
situation and doesn't work on my system anyhow (unknown ProgID error). So I
was hoping to just set the message-level header to "text/html". (If I edit
one of the messages from my script in notepad, changing the header to
text/html by hand, it then is rendered correctly in email clients.)

I'm getting an error from something that seems too easy to cause
trouble. Here's the scenario. User fills out a form. User saves. On
submit, an asp script attempts to save the data. it deletes all of
existing child records, and then re-inserts new child records.

Heres the chunk of code thats bombing out with a 'Microsoft OLE DB
Provider for SQL Server error '80040e31' ':

'delete all children for this Parent record
strSQL = "DELETE FROM qcspec_is_tasks WHERE parentID = " & nRecID
debugPrint strSQL
cn.Execute strSQL

The print statement yeilds the following, before the Execute statement
dies:

DELETE FROM qcspec_is_tasks WHERE parentID = 20

If I run the above in query analyzer, it executes instantly.

Incidentally, at this point in time, the table is tiny. Its only 50
rows or so, at the moment.

I'm trying to read in image data using the filesystemobject. I am able
to read the comments field for all file types it seems, except the ones
I want, .gif .jpg and .bmp.

Is it possible to do this?! If so what might I need to do? Code:

I'm trying to find information on applying CSS to asp Controls. However, all the searches I do relate to ASP.NET 2.0 but I am only using 1.1 (I can't switch to 2.0).

Does anyone have any information or good links to explain how to apply templates or CSS to asp 1.1 controls?

I have a series of checkboxes:

<td><input type="checkbox" name="reportTo" value="Rob"></td>
<td><input type="checkbox" name="reportTo" value="John"></td>

etc...

but I only get a value passed to the database if just one is selected. If more than one is selected, no value is returned. I thought the value passed was s'posed to be a comma delimited string of all checked boxes?

sql = "SELECT * FROM Calls WHERE Date BETWEEN " &startdate& " AND " &enddate

Where did I go wrong?????????????

Ugly response:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

I need some code that will enable people once they have signed up with all their details including their E Mail address to send a confrimation E Mail address to the users E Mail address wich contains their Username and Password.

I am generating Purchase Order from database. Then i send it to the
supplier. I am using CDONTS to send mail.
I am not sure that it was sent or not.
So i need confirmation when they read it or received. How can i send a mail
with acknowledgement?

i got a problem dealing with this sql statement, i data stored in a table in 3/13/2006 format, and i input this data into table by calling date() using asp, but when i try to run an sql statement by using this sql statement,

a="2006/3/5"
b="2006/3/7"

sql="select * from userlog where AccessTime between '"&a&"' and '"&b&"'"
response.write sql
set rt = conn.execute(sql)

if rt.eof then
response.write "no record"
else
response.write "got record"
end if

i got no record display on my page, may i know what to do to get the data from the tabel?do i need to change the structure when i insert this date or do i need to change the structure of my variable a and b in order to perform this search correctly?

I am wondering if their is a strategy or tool for syncing a local
database with a web-based database? Specifically I have an application
where orders are entered via a web form and the data emailed to my
client who processes the orders. I extract the order information and
update a local "order tracking" database. There are several order
processing steps.

I want to update a web database to reflect the status
of the order as it flows through the local tracking application. I will
send an email to the "orderer" at the major steps, but my client wants
to have a web-based report shows the status of all orders for a company
that has pending orders. In other words a company will enter multiple
orders and will be able to track the status of the orders by signing on
to the web site.

This status report gets its data from the
web-database.....which I must update from the local tracking database.
A pretty long winded explation which I hope mades sense. Has anyone
found a solution to this problem? Any reference or tools you can
suggest?

We run a small web ministry.

Our hosting company doesn't allow PERL, only Bamboo.SMTP and JMail asp's. (myhosting.com)

Our need? Turn the prayer request forms to an email that can
1. either send a different email to the requestor OR BCC an autoresponder we can set up.

2. BCC an email exploder on our mail system

3. make the FROM the requestor (done) and the TO: a 3rd email name on our system.

I see someone asked about a BCC function on Bamboo (none found), but the JMAIL set up we put up successfully executes but no emails are sent.

I have written an ASP.NET 2.0 application that uses Active Directory or ADAM
to manage account users - the site has a page that allows people to create an
account (much like any site). The page populates the AD with all the
information and the user account but I am unable to enable the account.
Microsoft has information on how to do that here -->
http://msdn.microsoft.com/library/d...ting_a_user.asp
(the sample is for Visual Basic) - and I am unable to complete the bottom
portion of the script. Can some one point me in the right direction - or can
you tell me how I can add a snippet of VBscript code to an ASP.NET page.

I am using the Active DS Type library - not sure why there are multiple ones
(System.DirectoryServices) but it is rather confusing - I seem to accomplish
one thing with one and another with the other (they did have trouble
co-existing however). Anyway my script works very well but I am not able to
access the properties required to enable the account.

Here is a simple version (no error checking) of the code.....

what I want to do is - the user is presented with a form with a drop down box at the top with two options - Yes or No, If No is selected then the form stays as is and the user can complete the other text boxes.

However, if the user selects yes I want the page to refresh with a different set of input boxes.

My question is do ASP need to declare smtp server when send email using CDonts function?

I am trying to upload a file from one server "A" (ADSL 64k) to another
server "B" (ADSL 128k) and it starts (I am using a script with ftp -s
scriptname.txt) and since I have "hash" as one of the flags I can see
that the file is being transfer but when the script is done server
"A", the file dissapears from the server "B".

I did try with server "C" (ADSL 512k) to server "B" and everithing is
ok (so it is not a permissions problem) but still the issue is that
server "A" is in a small branch and this HAVE to work. could it be the
speed? timeouts?

I am looking to create some sort of function that on the click of a submit button, a new HTML page will be created. Is this a simple task or something that I should research?

I'm attempting a login script where I first authenticate a user's login info for a valid connection. When I use a valid ID/Password everything works. When I use a bad user/password I get an error page stating the login failed.

I would prefer to redirect the user to another page on a failed login. This is the part that doesn't work. I'm new to ASP and JavaScript, but have done this kind of thing with PHP with no problems.

i am getting this error Code:

Microsoft OLE DB Provider for SQL Server error '80040e07'

Syntax error converting the varchar value 'Canvas' to a column of data type int.

/store/administrator/special.asp, line 98

what i am doing is selecting an item from the drop down and i have textbox i want to display the items price from the table here is the code:

The problem is that the code for "change_school.asp" takes the user right to "portal.asp". I checked the code of "change_school.asp" and it does indeed set a cookie value for "school", but for some reason "default.asp" is still finding the old cookie stored and then redirecting...any ideas guys?

'code for change_school.asp...clears the cookie "school" and redirects to page (default.asp) where user can select a new school
<% Response.Cookies("school")= ""
Response.Redirect "default.asp" %>

'code for default.asp which allows user to select a new school, and if the cookie "school" has some value then they are redirected.
<%
If request.cookies("school") <> "" then
Response.Redirect "portal.asp"
end if
%>

I'm running windows 2000 profession, and i know that i can install it from control panel but i tried and it's asking me for the cd and id ont have it.

Could you give me the direct links to the IIS Download as well as the Personal Web Server download.

I have a Client Mailer page which basically sends emails off containing information specific to each client = email address found in the relevant database. I basically get this to simply loop through the client recordset (recordset.moveNext), and on each loop it sends an email to the relevant email address via CDOSYS.

Can I just check that this is ok, and this could :

a. Not have a maximum amount of clients this could send to, and basically be too much for the page to cope with if there were too many clients to loop through?

b. This could not cause some sort of Email block due to the server thinking it is spamming, etc.?

This was something someone mentioned, which I just wanted to check out!, as they suggested changing it to a Javascript refresh page, whereby it will send an email every 6 seconds for example by refreshing the page with Js, but I don't really want to change it to this unless I have to... as I was hoping the way in which I have it with the recordset loop, that it would be ok.

Is there a way to read email messages with ASP without installing components?
And will it work with any email server, or just windows IIS?

Something that will work almost like Webmail. But I just need to read the From, Subject and Body of the email.

I have a site that currently has custom error messages enabled for all error messages, i.e. any error goes directly to error.asp etc. What I want to do however is have this error.asp email me with a fairly detailed error message outlining the problem that caused the error.

What is the best way of doing this? My server allows me to setup custom messages for any type of error but obviously to do this would be time consuming. Is there a way I can basically email myself an almost exact copy of the error message that I would get if I was viewing the page and the error happened to me?

For example, a 501.100 error can cover any number of error and whereas a message telling me that a person got a 501.100 at 12.43 on 31/5/2004 is ok it isn't very helpful. I want it to say:

501.100 at 12.43 on 31/5/2004
Error Type:
Microsoft VBScript compilation (0x800A03F9)
Expected 'Then'
/kshs/cms/cmsDefault.asp, line 54, column 39

I have a small shop on my web site and you order the products via a simple form. As an owner of the site, I want the order confirmations to be emailed to three email addresses, two adresses of mine plus one email to the person whoplaced the order. I don´t know how to fix this in the code though and that is my problem.

I can easily arrange for two of the addresses to get emails via the objMail.To command, so it´s when I try to add the buyers email that it gets weird.

That email address, I´m getting through the form and the name tag "Emailaddress".

I tried to use the commands objMail.Cc and objMail.Bcc, but nothing happend and then I still only got emails sent to the addresses that I put in at the line objMail.To. Below is as far as I have gotten. If I put the three addresses like that and separate with a "&", I got all three email addresses right, but no space between them. So do you have any ideas on what character to use, to split these three addresses so that an email can be sent to all of them? Code:

i need to view audio and video files on asp files...something like youtube, but from my own server and i want that files be secure...that the files can be view only from my page how can we make it happen?

I have an encrypted .txt file created by asp. Its formatted with lines etc. Title followed by description underneath. I need to read this into ASP now, and parse it line by line. On each line read, run the function to unencrpt and add line to a new file.

Its the line by line Im having trouble with. If i do the full textstream no formatting takes place coz im adding the fulltextstream all in one addline call. How can I loop through lines ?

does anyone know where i can get a good free javascript that sorts, filters and pages my ASP page? if it will work with my ASP page and if this is the best way?

if the default value of my my option value i want to retrieve it from the record if it's not empty. how can i do it? for example Code:

I wanted to write a simple page to let me choose a directory and then list
the files in it. The end goal was to make an easy way to copy all the
file names in a directory. I tested with Opera7, Mozilla 1.4 and IE6 -- all
on windows XP Pro

Here is the code. In all three, when I select a file, the complete path
is displayed in the file input box. In Opera, reading the form field gives
me the same full path. But in IE and Moz I get only the filename -- none of
the path information. Code:

I'm using Access Database with ASP. There is one particular thing that I
have issue with.

My purpose is for user to update their own profile. Their existing profile
information will be display in Edit Form format. The problem is if the field
has space, the second word will not display, when I display in input text
format.

E.g if My first name "User_FirstName" in my table has entry, let say "David
Johnson" as FirstName, when I execute following code and do a input text, it
will display "David" only. Code:

I have an XML file containing this: ....

I've recently made a recursive sub in asp to search all folder and subfolders of the map "file" for a certain filename. It will list all results and show a link.

Now there's still a bug. I can't place files in the root because this script won't find 'em. The root i mean files.

If i replace the empty dir with Server.MapPath("") it will show the files in the root but it will show 'em twice. Code:

I'm sure I have missed something but I can't see what...

I create two cookies on one ASP page as follows:

response.cookies("Errors") = "Must not be blank"
response.cookies("User")("Mem_Username") = response.write(M_Mem_Username)
response.cookies("User")("Contact_N") = response.write(M_Contact_N)

This page then calls the second ASP page which then reads the cookies:

E_Contact_N = request.cookies("Errors")
C_Contact_N = request.cookies("User")("Contact_N")
C_Mem_Username = request.cookies("User")("Mem_Username")

When I then use response.write (for example, response.write(C_Mem_Username)) to view the contents of the variables, there is nothing there.

As I say, I am still developing the site and so am using IIS on a Win XP Pro machine (local host)

What I am doing wrong?

On allot of professional web sites, i have notised that When you are looking for something on the site and it needs you to login first
before you can see the content, when you do login it knows exactly where to take you before you loged in, how do they do this???
what type of code do they use??? i would love to apply it to my site.

I have the following line of code in my asp page:

Dim ix
For ix = 1 to Request.Form.Count
fieldName = Request.Form.Key(ix)
fieldValue = Request.Form.Item(ix)
Response.Write fieldName
Response.Write fieldValue &
Next
Response.End

It is not returning the results of any field on the previous form page.
Does anyone know what I might look for?

I am creating a user tracking app that tracks a user one of two ways...

1)First Method is cookies
2)Second Method MS SQL DB

I first check if the users browser accepts cookies if not I go to the db. If the user accepts cookies then I check for a specific crumb if it does not have the value I am looking for I kill it and rewrite it. This is working fine (im in the middle of testing it). The problem is I decieded to test the script with NN7 and not turn cookies off but block cookies from my site and all fell apart. The condition that I have set (detect if cookies are enabled) does not stop the script from trying to set a Session Variable because the browser accepts cookies and to keep a long story short it goes into an infinite loop because the script is looking for a Session value and Its not being stopped becaues the script thinks its alright to write cookies! Is there a way to detect if a user has your sites cookies blocked? This is important because Server.CreateObject("MSWC.BrowserType") will return .Cookies = True and you will not know that your script is not executing properly because a user has your sites cookies blocked but excepts them elsewhere...

I have a JavaScript function that gets a boolean value and checks or unchecks a checkbox based on the boolean value.

function initialize_p(thevalue) {
if (thevalue) {
document.form.cbx1.checked=true;

}
else {
document.form.cbx1.checked=false;

}

In the example, I want form.cbx1 to be checked if 'thevalue' is true and unchecked if 'thevalue' is false. However, it's not working as desired. I used the alert stmt to see what it does:

- When 'thevalue' is true, it goes to the 1st part of the if stmt and checks the checkbox.
- When 'thevalue' is false, it still goes to the 1st part of the if stmt and checks the checkbox

It looks it never goes to the else!! I used alert stmts to see where it goes if the 'thevalue' is false (used alert to show me the value of 'thevalue' and where it is in the if stmt). I don't understand what's going on. Can anybody see what is wrong with the function?

Code:

' then set up a query
' -----------------------------------------------
sQuery = "SELECT DISTINCT * from tablename Order By columnA, columnB " ' << insert your own sql here

could someone give an example so I could follow it?

Is there anyway I can check to see if a server is online in my network with an if statement saying if online response.write "Online" else response.write "Offline"?

I am calling a recordset from sql which happens to contain one column that is a datetime in the format: DD/MM/YYYY HH:MM:SS. So when I call that column from the db, it displays in the same format within my page.

However, I would like to be able to display the datetime as part of my recordset, but in a more aesthetically pleasing format (i.e: Sunday 1st May 2000, 7.23PM)

I have tried using the formatdatetime() function along with my rs, but this causes syntax errors. I know this is probably dead simple, but I don't get it!

How would I remove a varable so i can redefine it. I just get an error: "Name redefined"

<%
Dim MyVar
MyVar="Hello"
Response.Write(MyVar)
[REMOVE VARABLE SO I CAN DEFINE IT AGAIN]
Dim MyVar
MyVar="Hello Again"
Response.Write(MyVar)
%>

I have a serious problem with an application that was developed by a contracted coder. The application that was to go live today for the company. The developer that normally does the code work is in the States and I cannot get hold of him. I need to have this resolved. Can someone help me?

How do I fix this?

The error occurs on attempt to login to the application.
See below the error I receive when I attempt to login to the interface.

Response object error 'ASP 0156 : 80004005'
Header Error

/tram/admin/checklogin.asp, line 8

The HTTP headers are already written to the client browser. Any HTTP header modifications must be made before writing page content.

I just bought a site it was zipped up to me and when I went to upload it I realised it was coded in asp. I have absoultely no knowledge on asp. If I get a host that supports asp then do I need to know any information to upload it and it to be a working site?

I know in PHP and CGI there are certain ways to upload the files to the server such as chmoding it. Is there anything special that I need to know? Also I'm looking for a low cost host to host this site. I already have three web hosting accounts for my multiple sites but they don't offer asp.

I've got an asp page with a CDONTS object sending HTML mails with proper attachments on them... thing is, some mail recipients get the full attach ok, and some don't (but still get the HTML ok)! (all recipients added to the same object... no more than 10 recipients)

i believe it's got something to do with MIME types and stuff, but i've got no ideia on how to solve this problem...

I am working on a piece of software that needs to store email data in a SQL server table. Been flicking around and it looks like the ASP mail components are a good way to go. Basically I will be recieving mails from a pop3 server (prob outlook) and using the same program to put the data in a database.

I develop a .asp app that reads its data from an Access DB "A", and I have a desktop app with a FoxPro DB "B".

How can I insert data from a table in DB "A" to a table in DB "B". Im new to asp and I really know only the basic's, so who can guide me to a tutorial or where can I dowload an example...

When I try to open an aspx file located on my computer it doesn't load properly (i.e not all objects are visible like text fields and such) and it gives me a syntax error stating that it expected a semi-colon (;) on one of the lines.

My page language is VB and so no semi-colon is required and when I load the file through my web server by typing
http://myIPaddress/myfile.apsx
the page loads correctly and functions normally.

Several hard drive formats ago I was able to open aspx files with internet explorer without going through my web server. I am pretty sure I have everything installed like IIS 5.1 and the .NET framework.

I need to build a script where in the source code i enter a number and when the page is executed it shows a percentage.

Here is an example of what i'm trying to do

88.83 / 12 = 740%

and the 740% is the only visable thing on the page

I found a recordpaging script that works fine except when I try to add additional fields. This script came with 3 field and 3 headings.

Adding addtional headings are easy but when I tried to add addtional fields, I don't get an error just a page with 5 headings and 3 fields. Take a look at the file an it's .inc file attached. I can't see where the field is referrenced from.

I need to display the contents of an external XML/RSS feed in an ASP page. I have found a couple of scripts that seem to do the trick at:

(URL address blocked: See forum rules)
(URL address blocked: See forum rules)/ow.asp?ASP_Based_RSS_Reader

(any good alternatives will be much welcome)

However, my problem is that the ASP page is part of an Intranet site, so it can only access the Internet (in order to fetch the RSS) via a proxy server.

Can somebody tell me how can I modify the above scripts (or any other that does the same) so the IP/port/login/password parameters can be passed along with the feed URL?

I am having one asp page(i.e home page) which has two frames in it. Left frame contains menu and whichever option is clicked in it that corresponding page is shown in the right frame. In those pages i am checking for sessionid and if it is different from what is there in the table i want to show the login page.

The problem is that as i am using response.redirect in the pages shown in right frame to go to login page but then the login page is shown in just the right frame but i want to show the login page on the whole page.

I'm writing an ASP cart and hit a problem.

I have 2 db's, one is products, one is cart contents.

Cart contents holds the unique ID from products when you do your 'basket'.

When I display the basket, I want to display the products name from the
products DB based on the ID stated in the cart DB

I have been informed I can do this with SQL some how, but that means I'd
have to create two conn objects? or can it be done another way?

I need to create a page which updates a products information within a record.

the tables are,
products (ID,CatID,sID)
supplier (sID,sName),
category (CatID, CatName)

The above tables supplier and category have relationships to products by using the sID and CatID

I need to update the product details by having a select/option for a supplier and category but if not changed by the user the value already within products table stays the same, therefore the list must be dynamic so that the first item in the list is the one relating to the value in the products table. Also the value must be the ID numbers but must display the names not the ID's to the users within the select/option.

I am using the below command to restart a service on one of my web
boxes, this runs fine from the command prompt and also through a *.bat
file.

"Server1Applist$BOBJCentralMSpsservice.exe" Server2 -u
eutee-ww02pUsername -p password restart BOBJCentralMS

I found this asp code in this forum but can not get it to work with my
command

<%
Dim oShell, sCommand
sCommand = "MyCommand"
Set oShell = CreateObject("WScript.Shell")
oShell.Run sCommand, , True
Set oShell = Nothing
%>

I replace "MYCommand" with the command i wish to execute but the page
just hangs with the blue status bar halfway complete at the bottom,
when checking the services on the box it is not restarted.

I have a form with severakl fields and a picture of a human being. I want to user to be able to mark/shade any section of the body they want and add notes next to it.

When they submit the form, thhe image must be added to the DB.

Is this possible - if so, how? Any demos, examples, guides?

I am using a couple of session variables in my site. From what I can figure
out, session information is stored on the users computer in a cookie -

If the user has cookies disabled, do session variables still work - just
without the option of setting the Timeout property, as I'm assuming?

I have a main file (asp), from which I include 2 different asp files. The second included asp file references an array element deefined and populated in the first include asp file. However, the array value is not being resolved in the second include.

This is not on a Windows server, but rather a UNIX server. However, the host provider claims ASP and SSI support.

i have got one field in sql server 2000 database.
field1 char 50

in one record, i m storing value -1

but it doesnt satisfy following condition

if (rs("field1")) = cstr("-1") Then
response.write ("true")
end if

i already checked its value by response.write and
print -1 only..
then y its above condition is false???

Since our application uses ASP, I am posting this in this group. Pardon
if wrong group.

Our product/application replies a lot on bounced back emails, that way
we correct this and let the client know. Off late we are receiving very,
very few of these emails. It turns out, with amount of spamming going on
most of the companies have set up filters. As a result, most of emails,
even though incorrect don't get bounced back.

Is there another way to track bounced back emails?

I have a simple website linking to an access database. The script works fine on my local machine. And it works fine on my regular host. However, I have uploaded the website to a Windows account with GoDaddy and here is my problem.

I am receiving the following error:

Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/home.asp, line 10

- the WEIRD thing is that if you hit refresh enough times, the page loads fine. Then, at random (it appears), the error resurfaces. No coding changes at all. Code:

Didn't remember if anybody had started started like this, but I decided it would be cool to start it again. If you have a math function request ask it below, or if you have made one then add it:

I have a few cretegean plane (think thats how you spell it), calculations. One request I have is, does anybody have a short function for square root?

I have created one of those change your password forms whereby the the old password and new password are provided.

What I am having trouble with is ensuring that the old password entered actually exists already. Below is what I have tried, but I am getting a syntax error:

Code:

'Check Password

if request.form("CusPassword")<>rsCheckUser.fields("CustomerPassword") then

response.write "Invalid password"

end if

Else

if request.form("CusPassword")= rsCheckUser.fields("CustomerPassword") then

'write new password to databasestrSQL ="UPDATE Customer Set CustomerPassword ='"& NewPassword& "',CustomerPasswordverified ='"& NewPassword& "' where CustomerEmail = '"&CusEmail&"' "

I need to select the data where the data ID is equal to the variable supplied in the submitted form. Below is the line of code I used for the radio select and the code to do the SQL search on it. I get the following error using this code:

Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/MyWeb/CheckIn.asp, line 93

The items are listed by ID 1-X.

<input type=""radio"" name=""CheckIn"" value=x.value>Check In<br>

Dim junk
junk=request.form("CheckIn")
'If Session("UserType") = "User" Or Session("UserType") = "Admin" Then
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db1.mdb")
Set rs=Server.CreateObject("ADODB.recordset")
'in below, WHERE id = Request.Form("CheckIn")
SQL = "SELECT * FROM CompsIn WHERE ID = junk"
rs.OPEN SQL, Conn, 3, 3

rs.OPEN SQL, Conn, 3, 3 = Line 93

anybody know how to write a code for pop-up message in asp?

is asp code able to do the extraction of text from PDF File without using a third party software?

I've got a webpage that calls some stored procedures with input variables.
The procedures return recordsets and also some output variables. We're
trying to get the values of the output variables. I've done this using the
method I found in MSDN, as shown in the code below. The problem is that we
believe doing it this way involves the use of the Microsoft Transaction
Server (IIS transaction server). Is this true? (The SQL Server and IIS
Server are on different machines and, I believe, a firewall separates them.)

I can't see why this method would use MTS. The problem is that in the past,
we have had problems with MTS stopping for no reason, which causes the
websites to not work. So my boss doesn't want to use any ASP code that
relies on MTS. Not using the stored procedure output variables makes things
way more complicated. So does this code really invoke MTS? And if it does,
is there a way to obtain SP output variables without using MTS?

I am running SQL Server 7.0 with the latest service pack and IIS version 4.
We do have an IIS version 5 server we can use if that matters. Code:

I try to grab the checked files from HTML page and then send those PDF
files as attachments. It can just send email, there are no PDF files
attached. Can anybody point out my error?

My idea is:
When people check the check boxes in HTML page for the PDF files, it
will transfer the files' name to ASP page. Then, it will attach it in
the email. Code:

I am trying to get a asp-mailer setup that will send a specified attachment.
I have tried both CDONTS and CDOSYS methods ... both are giving me headaches.

And the best part is how incredibly helpful the error is: (Sarcasm Intended)

Error Type:
(0x80004005)
Unspecified error <-- They should change that error to ... "Good Luck!"
/knowledgetree/emailer-drivers.asp, line 90
I hilighted the above line in the code as well.

Here is the code I am working with: Code:

When I try to use the response.redirect or response.cookies I get an error saying "object required". I`ve tried to write response.buffer=true with no luck. May this occur due to bad config og iis 5.0?

Is there a way that I can read the current url.

I have an asp page currently such as default.asp?x=1&y=2&z=3

Now I want to keep the existing parameters and attach another parameter
to it and resend to default.asp

As the original parameters are dynamic, and may or may not be
generated, the only way is to read the current url and to simply add my
new parameter such as h=5 to the url.

I don't know how to read the current url.

I tried Request.ServerVariables("SCRIPT_NAME") but that didn't include
the parameters. i.e. it just returned the default.asp

I have a cookie with a path of "/"

im trieng to delete it before the expired time has comed anyway i am trieng to delete it by setting the cookie to ""

like so: Response.Cookies("name") = "";

but its not working but...i found out that if i dont set the path it is being deleted but i have to set the path because from some reason without it i have issues where the cookie is not found in some pages.

Error Type:

Server object, ASP 0177 (0x800401F3)
Invalid ProgID. For additional information specific to
this message please visit the Microsoft Online Support
site located at:
http://www.microsoft.com/contentredirect.asp.
/forums/functions/functions_upload.asp, line 108

I'm getting this error, how do I rectify this.. this error comes at this stage.
Set objUpload = Server.CreateObject("Persits.Upload.1")

What should I do now?

I am trying to set up a contact page using Matt's FormMail ASP script (because my hosting is on a Windows server I am unable to use the easier Natemail PHP script)

It is simple enough to send an email to a single email address but I want to have a form with a choice of 4 email address's to send to that are chosen by way of a tickbox (it doesn't have to be a tickbox but that is what I prefer at the moment)

Does anybody know of a method to do this?

(I am using Adobe Golive CS2)

I created an Email sender to get emails out of my database, and send it! But when they get the Email it goes into Junk Mail, which most people dont read. Just wondering is there a way of sending the Email, and for it to NOT go into junk mail?

Does anyone know of a way to disallow a user to refresh a certain page? I ask because I have a page that duplicates itself when it is refreshed and would prefer to not allow the user to refresh at all.

Can someone give me an example how to use the Imagemagick - Identity
command?

I am having trouble getting my scripting to look in more than one database field when presenting results from one form field.

I can get it to work when there is more than one form field but I am trying to get the system to look in both a description field and keyword field then present the results.

The problem area is: Code:

formFields = Array("name", "shop", "suburb", "city")
dbFields = Array("shoptitle", "shopdesc", "shopsuburb", "shopcity")

The formfields and dbfields relate to each other. What is want is 'shop' to look not only in shopdesc but also in shopkeywords I have tried commas with out quotes, semicolons etc etc Code:

I could not find the equiavalent code of following in javascript, pls advise if you know? my Vbscript is as follow:

<script type="text/vbscript">
function save()
for each text in frm1
if text.value="" then
alert ("please Fill All The Required Fields")
exit function
end if
next
</script>

I need to provide a way to download a software and its corresponding
manual from a web page.

So far I have done the sign in page where people give their data. I
will then give access to a page with a link allowing to download the
required file(s).

My worry is how to avoid that somebody grabs the URL of the file and
send it to another for downloading directly from the server. What can
I do to avoid this ?

My main page shows a table to which a user can add data to by clicking on a button, this in turn loads up a pop up window where the data to be entered is typed. Once the data is submitted the popup window is closed via Close button, but the table on the main IE page only shows the updated information if the refresh button is clicked.

All i want to know is, is there a way of forcing refresh of the main page when the close button in the popup window is clicked. Code used for the close button:

<TD><a href="javascript:self.close()" title="Close"><IMG align="center" src="http://localhost/***/close.gif" alt="Close Window"></a></TD>

I'm writing an ASP script to move records from a MySQL database to SQL Server 2005. I've been able to successfully query both databases so my connection strings work. But I'm getting a '800a000d' Type Mismatch error for my insert query string:

qi = "INSERT INTO dbo.testimonial (testimonialid, testcatid, name, email, country, title, testimonial, testimonial_dt, approved) VALUES '" & records("testimonialid") & "', '" & records("testcatid") & "', '" & records("name") & "', '" & records("email") & "', '" & records("country") & "', '" & records("title") & "', '" & records("testimonial") & "', '" & records("testimonial_dt") & "', '" & records("approved") & "')"

can anyone identify a problem with this query string that would cause this?

i am wanting to put a simple search box within one of my pages, which will search a specific field of a table and display only the reaults matching those entered.

I have an ASP page working the way I want it to, no issues there. What I am trying to accomplish now is more on the graphic side. I have some hyper links on the left hand margin of the page. WHat I want to do is Color the width of that area different from the center of the page. Does anyone know how I can do that?

Can I add an image to the background adn have all the hyperlinks in the for front?

Is it just a color sertting in the form?

I need to display on a web page a 7 day week split up into 30 minute blocks.

I have written the code below to do this. No doubt it is a load of rubbish (I know the bit that prints the days of the week is, but I'm not worried about that for the moment, I'm more concerned about getting the times correct).

The problem is that I cannot get it to print out midnight. The day starts at 00:30:00 and ends at 23:30:00.

Looking at the code below, can anyone suggest how I might be able to do this please?

I know I could just type in something like:

<TD>00:00:00 AM</TD> manually, but I want it to go in via a loop so I can compare it against data that will eventually be pulled from a database.

I tried setting up formmail ASP based on Matt's cgi script but only got these errors when submitting this page: http://www.a2zli.com/surveycl56.htm

Formmail v1.3 detected the following errors:
error no.: -2147220973
description: The transport failed to connect to the server.

I have recently had the pleasure of installing Norton Internet Security 2005
and finding that I can no longer create or open a web-based application in
Visual Studio .Net. The IDE just freezes. I tried fiddling with the
configuration settings of the Norton Firewall but was not successful. I
tried launching IIS from the Control Panel and it would not launch.

I saw one article in Groups.Google from a previous post that the individual
was eventually able to unravel the mystery but they did not list the
specifics of what they did.

i need to make some text editor like this in the sitepoint which we enter our threads

i saw it in many asp sites with many enhanced features so how can i desig some 1 or get a it from the web

i need to unserstand it's idea how can i format the text into html format and how can i save the formated text into the database and the important point how can i display it as html

I have an asp page which displays a list of records depending on what was selected via another form.

I want to have these results broken down, displaying only 10 records, with links underneath to display as 'Previous' and 'Next' Code:

I have an asp page that I'm trying to make, that will allow users to start a new time sheet. when doing this, the users will select a pay period start and end date. I have a table with the days of the week for two weeks (i.e. mon1-sun2). When users select the start and end dates I want to populate these fields with auto increment... Soo my question is, does anyone know how you auto increment the date using ASP?

I want to maintain a high score file on an iis server, and I try to use a txt file to contain the scores.

The server can't run the ASP file but writes HTTP internal server error (in danish). Is it possible, that the server does not support

Server.CreateObject("Scripting.FileSystemObject") ?

In other cases the server gives me an ASP error report (line xx in file yy and so on). Here it only says HTTP 500 (not 404). Even if I call the ASP directly. Code:

I am trying to send an email from some server side ASP code and the CC field
is giving me some problems.

The code works fine if I have one or 2 email addresses in the field (The
addresses are valid.) However if I have 4 it breaks. Now the good
part......If I copy the 4 addresses (that were causing the problem) into the
field a few times, so basically I have 16 addresses the code works!!

I don't get an error back from the code when it breaks and I don't see any
emails in the Bad Email, Pickup or Queue folders, the email just doesn't
sent at all.

Also if I put the 4 addresses into the BCC field it works fine. It only
breaks on the CC field....

In IIS, when I try to browse an aspx, I get a popup message asking me if I want to open or to save the file instead of actually browsing to the page. Any idea of what could cause this issue?

A client wants a splash page with the option of going to his website with the flash header or the one with the .JPG header.

Now it's only the header that will be different and all the content will be the same. I don't want to make two seperate websites, because I'll have to update it twice then. Is there a way to just have the header change, without using frames. Maybe SSI,

I have a code In asp, but i don't know this function.below is code:

1.if instr(strq,"http://localhost/ab") > 0 then
...........
else
...........
end if

2.fid=replace(fid,"pdafid_","")

1.What function the code "instr"?
2.What function the code "replace"?

I have tried mail sending in asp but it has the following error

Error Type:
CDO.Message.1 (0x8004020D)
, and neither was found.
/New Folder/candidtech/finalsite/asp/support.asp, line 49

code is given below
------------------------------------------------------------

.....

I'm writing an ASP validation script that uses a cookie that is created by a user validation page and has a single value. This site will be used only under Internet Explorer 5 and more recent.

My problem is that the page called after the cookie creation can't read the cookie unless I set the Cookie.Path attribute to "". All the documentation that I found about it is very brief, don't explain how it really works and if there's any kind of "side effects". An even stranger fact is that some people of my team can read the cookie without setting the Cookie.Path attribute.

Can anyone tell me how the Cookie.Path really works or witch browser settings make it needed (or not)?

I am trying to connect to a Mysql database in the following manner:

Dim conn As ADODB.Connection
Set conn = New ADODB.Connection

Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset

conn.CursorLocation = adUseClient
conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=myserver;PORT=3306;DATABASE=mydatabase; USER=myusername;PASSWORD=mypassword;OPTION=3;"

however I am getting an error:

visual basic run-time error microsoft [odbc driver manager] data source name not found and no default driver specified.

I store dates in my table as

FDate TDate NoDays

Where Fdate is From Date
TDate is To Date
NoDays is number of days.

We use this to record holidays for our employees.

I would like to write a SQL query which will display all the records where
Fdate or Tdate are within the current month. Not very good at writing SQL
hence need some help.

Some sample data can be like this

Fdate TDate NoDays
15/05/04 18/5/04 4
29/04/04 2/5/04 5
29/5/04 3/06/04 4

If that was the data in the my table and running this query I would expect
it include all the three records when searching for month of "May" as all
three records have atleast one day which falls in the month of May.

I have a form that needs to handle international characters withing the UTF-8
character set. I have tried all the recommended strategies for getting utf-8
characters from form input to email message and I cannot get it to work. I
need to stay with classic asp for this.

Here are some things I tried:

'CDONTS
Call msg.SetLocaleIDs(65001)

'CDOSYS
msg.HTMLBodyPart.Charset = "utf-8"

I included the following meta tag in the email HTML:
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

I also tried modifying the CharSet and CodePage of all involved Request and
Responses.

I was able to Response.Write the form content on post back to the screen and
it was properly rendered. However, none of my efforts can get the email to
render with the correct codebase. I have tried opening the email in Outlook
and Thunderbird. Neither one picks up on the UTF-8 charset meta tag.

I have an application which was successfully writing data from submitted
forms to a text file in a directory - in this case:

/data/findata.txt

This was fine because the forms lived at the root level with this directory.

Since then I have added enabled the forms to be used on subdirectories :

/subdirectory/myform.asp

I've used the same code for server.mapparth("data") etc - but instead of
locating the directory at the root of the server called "data" it looks to
the current directory- doesn't find it and creates another! eek!

What I need is a way to say "right, it doesnt matter what level you are at
at the moment, always look at the root level /data directory"...

This has to be fairly dynamic - on the development server here its got a
different file structure than on the live server (ie, it lives another level
down again on the physical drive)...

Anyone got a good idea on how to look back up?

I do have one way to test which level they are at - but I feel that its a
bit 'weak' - I have an ID that tells me if they are working on the upper or
lower levels (ie, anything other than 1 is a lower level) - whilst I realise
I could use this in the test I'm not sure if its going to be 100% fool proof
to base this criteria on this ID.

Therefore I was hoping for a better way using the server.mappath etc...

I have an asp site which I try to bet unicode compatible (UTF-8
codepage=65001). In the site a user can upload documents and I store the
document on the server in a database. I also store the original filename. If
this filename contains for example swedish characters like å,ä ö which are
outside ascii 0-127 i get problems when I try to download the file from
server-->client.

In my com+ packages (which are instantiated from asp files) I set the
following headers/content types

GetObjectContext("Response").contentType = "application/octet-stream"
GetObjectContext("Response").AddHeader "Content-Disposition", "attachment;
filename=" & rs("orgfilename")

The database value is correct and I have set the codepage in the ASP file to
65001 (UTF-8). The problem is that the filename shown in the "Save as"
dialog is incorrect. If the filename only include a-z the filename are shown
correct.

I tried adding a charset header but it does not work.
GetObjectContext("Response").AddHeader "Charset", "UTF-8"

Browsers used: IE6 sp1.

I am using a ASP page(User_Account.asp) to create username and password & updating the info into the database through another ASP page(User_Account_Upload.asp).

The problem I am facing is that, at random instances the data gets duplicated. I tried to check if the user Id exixts in the database before updating. After implementing this logic, whenever I create a new user, if the ASP page tries to store the username for the 2nd time, it generates an error message that the user_id exists and doesn't update the database. However, this error message is displayed on the screen even though the user_id was created for the 1st time ....

Previously, I used ms front page editor for my asp development ... and now I am planning to start another development soon with asp but this time I want to use an IDE instead of an editor ... I heard about visual basic interdev 6.0 ...

The problem is I need a useful documentation to help in learning about this tool ... I looked in some libraries in my country but these books are very hard to find in Oman ... I am wondering if I can find a useful tutorials for this tool on the net?

I have a database that has 2 tables linked into it from another database. I am having problems trying to pull in values from those 2 linked databases. One of the tables is tblClient. Code:

i got a string- for example the word "CodingForums" i want somehow to add randomal char- for example "0", 3 times the output can look like this-

"0C0odi0ngForums" "Co0ding0Foru0ms" "Co0din0gFor0ums" "0CodingForums00"
what is the best way to do this?

I've got another email prob. Does anyone know how to link an external stylesheet in an html email via asp? I've got this so far:

While NOT offerCustRS.EOF

Dim strBody

strBody = "<!DOCTYPE HTML PUBLIC ""-//W3C//DTD HTML 4.0 Transitional//EN"">"
strBody = strBody & "<html>"
strBody = strBody & "<head>"
strBody = strBody & "<title></title>"
strBody = strBody & "<meta http-equiv=Content-Type content=""text/html; charset=iso-8859-1"">"
strBody = strBody & "<link rel=""stylesheet"" href=""CSS/blue.css"" type=""text/css"">"
strBody = strBody & "</head>"
strBody = strBody & "<body>"
strBody = strBody & "<div id=""head"">Special Offers from the best online shop</div>"
strBody = strBody & "<p>"
strBody = strBody & "<div id=""content"">"
while not offerRS.EOF
strBody = strBody & "Product:" & " " & "<a href='http://localhost/New Shop/products.asp?id=" & offerRS("Product_ID") & "'>" & offerRS("Product_Name") & "</a><br>"
strBody = strBody & "Price:" & " " & offerRS("Offer_Price") & "<br>"
strBody = strBody & "</div>"
offerRS.MoveNext()
WEND

strBody = strBody & "</body>"
strBody = strBody & "</html>"

The email doesn't have any of the formatting but I haven't a clue why. The css file has been tested on another page and it works so the css is fine. Can anyone help?

All the HTML contained within the <BODY> tags is contained within a DB I have for a CMS. I have 2 pages... CURRENT_LIVE and LAST_UPDATED... I want to compare the content of both and highlight the changes... is this possible? if so, how?

Is there any way, having a SessionID in hand, for an ASP
page to "join" an existant Session and have access to its
values without writing everything to SQL server and all
that?

There's an access database on an iisserver and asp makes updates to it. The
database got moved to a newer server. The users used to be able to open the
database and use the asp pages at the same time. Now when the database is
open the asp pages won't update.

I wish to create a page with a validation code (something like rapidshare.de or gmail, when u want to submit, u will required to type the characters in the image shown for validation)

any idea how to do it?

Is it possible to restart a service using ASP ? I have some code here to restart a service using vbscript, but it doesnt translate into asp at all. I also have a script here that displays the status of a service, and that works fine in ASP, so i know that it can be done, and that security, once set, wont be an issue.

Does anyone know how i can restart a service with ASP? any examples?

I have an sql database, and an asp website. I need to send emails to users from the site. I have loaded the recordset with the email field from the table. I them send an email to all the emails in the recordset. I use the BCC field to do this. The problem is, sometimes the emails get missed judged as spam or junk. How can I fill the TO field of the email instead, with the emails from the recordset, and send an email to each address individually, in like a loop or something? So like, it will go through and send an email to email1, then loop back through and send one to email2, and so on....

How do i select all records from a table that has a datetime field in it by date.
so i want all the records that was created today.

if i put only the date it doesn't work. this is what i have:

Code:
strsql = "select cnum from [topline data] where cnum = '" & cnum & "' and activerecord = "& activerecord & " and timestamp <> '12/10/2007'"

I need to be able to email to all email addresses in db (like a newsletter) I have seen some code samples but really need something simple and web based.

i want to add columns dynamically from asp......say for eg. i have a drop down and from that if a user selects 10 as the value it creates 10 textboxes and then when saved it should generate that much columns in access table for saving............hope u guyz got what i am saying... i want to create fields dynamically in access database.

I have a form on which I have a INPUT Type='Reset'. On clicking this button all the fields on the form should reset except a few. Is it possible to do this by setting some property of the control or do I have to specifically write code form that?

I've searched the net but I couldn't find any SQL code on how to insert an autonumber column into an access database and table. Can anyone include the code?

How do I convert one DataType to other using the CType Function?
and can you show some examples......

I want to create form in which user specify his details. But that mail should be take cc address from database and also that form have one attachment field.

Mail body must be in html format. Attachment and "from" his email field compulsory....

i wish to enable users to submit an image on one of the fields on the form within an asp page.

essentially i suppose they would submit it as an attachment though it would be entered and stored in the access dbase, from which it would be pulled in connection with specific text fields.

i'm using ultradev though trying to use an input field though it seems to talk about retrieving data. can this image as a field collection by done on the input with asp form ?

Can anyone get me started or point me to a resource for some help?

I have an ASP page that displays various boxes, tables, and information. I want to be able to click an "Email" button and have the asp page save the page as an attachment (html?) and then launch Outlook and automatically attach the page to it and enter the email address of the person I want to send it to.

I can't just send a link because the page is generated on an Intranet and I need to send it to people outside the network. So, I need to save a print screen of the page and then have Outlook grab that and the recipient's email address and put those into Outlook so the sender can review and send out.

Is it possible to generate private key and afterwards apply the CA digitaly signed certificate within CDO code so I can send signed e-mails?

I have several websites running on a 2003 IIS6 box, all
running basically the same code (each site has its own home directory
and copy of the code). All are running in the same App Pool.

One site gives the 800a0006 error on a formatpercent, another site (on
the same server) does not.

Here's the kicker...the one site only fails if the number is LESS THAN
1.

formatpercent(0.999) ---overflow
formatpercent(1.000) ---100%

The one "abnormality" is that the default script language is set to
jscript, and I call the function via a call to a vbscript block -- but
this works on several other sites on this same server.

set rs = Server.CreateObject("ADODB.Recordset")
objConn.usp_RetrieveCategories rs

Method 2:

set rs = objConn.Execute("usp_RetriveCategories")

Which method is considered to efficient. Is it method 1 or method 2?.
The stored procedures returns no values.

The original programmer of our website put "on error resume next" on
every page to cover up his lack of skill. Many of our pages are
returning errors that we never see.

I want to make a little script that emails me at the occurance of an
error. I copied one that used the Err object but I don't want to use
it because I would like line numbers is the email.

I then copied our custom 500 error page that uses the GetLastError
function but it always seems to be empty, like no error occurred.

The function "If Err Then" returns true so the Err object sees the
error. Why won't GetLastError return the error.

Is it possible to embed an image, like a company logo in a CDOSYS generated
message?

If yes, IÂ´ll apreciate some code sample. IÂ´ve been able to format messages
in html the way I like, but I can't figure out how to embed an image.

I am using On Error Resume Next to allow my application to deal with errors accessing the database, i.e. if the DSN-less connection doesn't work then it tries the DSN connection and this is fine.

What I want to find out is how can i stop the rest of the page continuing after errors, in essence I want to cancel the On Error Resume Next statement after the database connection stuff is done so that errors will stop the page and I can debug them.