Active Server Pages Blog News 2003-05-29

Home | Advertising Info

119 USERS CURRENTLY ONLINE

Site Search Contact Us

Friday, March 14, 2025

Code Snippets
Hints & Tips
Code Wizards
Guestbook
Newsletter
Forums
Links

DISCUSSION ARCHIVES
DISCUSSION ARCHIVES 2
DISCUSSION ARCHIVES 3
BLOG

We didn't realize
the site was so popular.

Other Stuff

Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds

Blog Entry: 3/25/2006 1:43:47 PM

To be honest I just can't remember what happens. It has been a long time since I did a real live test of that. I know it seemed like a pretty smooth process to me. Right now I can not test it out as I am on a road trip with my motorcycle and I am sending this email from my PDA.

I would ask Dave at this website.
http://www.davephoenix.com/

Or via this username in the forums
PhoenixUK

He can tell you what happens as he has been using the IPN stuff for about a month now.

Perhaps another user could chime in here as well and let us know. I know there are a lot of people using the IPN stuff.

, I am running into problems with the import function. I have 25 photos loaded into the import folder. The page see all of the photos. But after I click on the import process it takes me Picture Manager with no pictures loaded. I have hit the refresh button, but there is nothing there. dr_bones38394.676412037,

it might.. I might be wrong though as I guess that could still be an issue with access not being able to keep up.. and then the xml parser just isnt getting the page it is requesting in time,

Triple check the upgrade instructions because I think you missed something important.

line 227 on "/password_admin/save.asp" refers to the "Password" field

the error your getting most likely means it is not there..

Pay close attention to the areas in the upgrade instructions regarding renaming your existing "Password" field to "Old_Password"

Then making a new "Password" field and carefully following the instructions needed to convert your old passwords for use with the new system.

If you don't everything carefully and perfectly this is the sort of error you will get.

cwilliams38451.8787268519,

sorry, I am guilty of being very tired and didnt read your message fully.

I know this forum area is called "database connection issues" but it is only meant for generic issues.

Issues specific to a particular application need to go in that applications area in the forum. It keeps the forums more organized and helps other people fnd help later on.

So please post in the correct area.
I will answer this question soon. I have to do something 1st though.

I would also double check that you changed the field size correctly and on the correct database that is being used in the connection string

It a generic error that means something is wrong with your data connection.

http://support.cjwsoft.com/code/moreinfo27-1.htm

http://support.cjwsoft.com/code/moreinfo136-1.htm

These are 4 valid examples of calling a flash movie.

The more simple examples may cause problems for people that don't have the flash plugin installed. I really do not know as I am no flash expert. All these work fine for me. Of course I have the latest flash plugin installed. Perhaps some of you can shed some light in this. The 3rd and 4rth examples are obviously only slightly different and mention different versions of flash as far as downloading the plugin goes.

cwilliams38089.6129513889, I really need more detailed information to say anything about it.

I would try different methods of calling banners as well to see if that helps.,

No worries

then..

is there any way I can get rid of those information shown on User activity screen, so I can at least know who logged in current day?

thank you in advance

Now, we can connect to the MySQL database with ASPBanner using the following connection string if we like.

"driver={MySQL ODBC 3.51 Driver};server=localhost;port=3306;uid=root;pwd=temp;databas e=aspbanner;option=16386"

But we really do not want to connect to the aspbanner MySQL database using the "root" account

So, lets make an account to use..

In MySQL Administrator select "User Administration"

Down below you will see the user "root"

Right click on "root" and select "Add new user"

Type in a New MySQL Username and Password

I am going to call my new user "aspbanneruser"

Hit the Schema Privileges" tab

In this case since I am using the root account to manage my MySQL system I am just going to give this new user account what it needs to use the aspbanner database.. you may want to apply more permissions to the new account, that is up to you.. I am giving the new user (select, insert, update, delete, execute) So I right click on the aspbanner and then bring over the permissions I need for it.. and hit apply changes down in the bottom right.

We can now connect to the aspbanner MySQL database using this new account like so.

"driver={MySQL ODBC 3.51 Driver};server=localhost;port=3306;uid=aspbanneruser;pwd=tem p;databas e=aspbanner;option=16386"

------------------------------------------------------------ -----
article still in the process of being written (3/14/06)

enjoy the bar.. drink one for me.. cause that was the problem..

, at some point I can do the users in mass correct using the import feature in aspprotect right?,

The Pop-Up Javascript Date Pickers will only show up of your server's regional settings are set to one of two lCID values.

1033 which is English - United States
mm/dd/yyyy date format

2057 which is English - United Kingdom
dd/mm/yyyy date format

Many servers are set to run the default LCID which is 2048 so the banner system will not show the date pickers.

This setting can however be easily overwritten when using the ASPBanner system.

Edit the "config_inc.asp" file with a text editor.

Add this code between the <% and %> tags.
Near the top is good

Session.LCID = 1033

or

Session.LCID = 2057

depending on what date format you are looking to use

Save the file and go edit a banner. The date pickers should be there now.

cwilliams38325.7403125,

I am getting closer.

This error actually does not have anything to do with the forgotten password feature or your database.

It has to do with the settings you chose for emailing.

it relates to aspmail and it not liking the remotehost you used, or something like that.... etc etc

Two things you can do to test..

make sure there is at least one ".log" file in that directory.. then if you go to the log file screen and it does not show up in the list the physical path you are using is just not correct

remember the physcial path must contain a drive letter (sometimes a network path starting with // is ok if they have it setup as a network drive)

the other thing you can do is use this script to try and write a simple text file in the directory

http://www.devasp.com/samples/writetofile.asp

That will show you if permissions are correct

all that docmunetation is online as well right here so you dont really need the chm file
http://support.cjwsoft.com/code/info24.htm

the chm format is a windows format that can only be viewed on windows pcs. I do not know why you can not see it. I would do reseach on viewing CHM files on whatever operating system and version you are running because perhaps you are using a mac or linux operating system which can not natively view chm files ?

Christopher,

I have a follow-up to this question.

Is there a way to get the photo descriptions to save with actual spaces instead of the HTML space code all of the time?

I know that is does this if you hit Enter while typing a description, because it creates a 'br' tag. The main reason I am asking is because if the user does not enter a line break, the description is saved a single long string and the pic_window.asp page is generated with one long description which makes the page very wide.

I tried to get around this by changing the description style in pic_window.asp to reflect a value like 50% or 200 pixels, and I have tried putting it into a table with a fixed width, but there is no effect.

Thanks!

- Jason

, Hey, I thought I'd share this tip with the ASPProtect community...

If you'd like to remove, modify, or add fields to the "Users" view in the password_admin default.asp page, it's really easy to do. Well, at least it was for me. I'm using an MS Access database, by the way.

For me, I don't need "Company" info, but I do need last access and # of times accessed displayed. Therefore, I had to change the default page in three areas:

In /password_admin/default.asp, go to about line 185 or so, where you see stuff like:

[code]<td valign="bottom">First Name& lt;/b> </td> [/code]

OK, those are the column headings. Each one corresponds to a column from your USERS table in your database. There are two more areas to consider, both of which appear immediately after this section.

The next section has statements that look like this:

[code]<td valign="bottom"><a href="<% =THISPAGE %>?SORTBY=First_Name+ASC&MyPageSize=<% =MyPageSize %>&Keyword=<% =Server.URLEncode(Keyword)%>"><img border="0" src="../images/sort_ascending.gif" Alt="Sort Ascending"></a><a href="<% =THISPAGE %>?SORTBY=First_Name+DESC&MyPageSize=<% =MyPageSize %>&Keyword=<% =Server.URLEncode(Keyword)%>"><img border="0" src="../images/sort_descending.gif" Alt="Sort Descending"></a></td>[/code]

See the "First_Name" items? The first is for an ascending sort, the second for a descending. This particular line corresponds to the code snippet immediately above it. But all this does is handle the sorting. For the actual data, look lower for this stuff:

[code] <td bgcolor="<% = Cellbgcolor %>"> <%= CmdListUsers("First_Name") %& gt; </td> [/code]

It's a good ways down, so don't be impatient if you don't see it in 10 lines from the end of the last mentioned section. This stuff handles the display of the data from the database (where else ya gonna get data, anyway?)...

Now, to remove a field, you need to find the three sets that go with that data. The ascending/descending sort is potentially the trickiest, because it's the longest set of data and can take a number of lines. Just clear it from the start td to the end /td and you'll be fine.

To *add* a field, copy and paste the code from an existing field and modify it. In the first one, the column title, you can type whatever you want to describe your info. Nobody but you and your admins will see it. For the next two sections, though, you need to get the correct column heading from the USERS table and use that to correct the lines in the copied code you pasted in.

For example, when I added a column to show the number of times a user logged in, I copied the above snippets and pasted them in where I felt the column I needed should be. Then, in the first one, I changed "First Name" to "Logins". In the ascending/descending snippet, I changed First_Name to Counter. Same for the last snippet.

The result? A new column, showing the number of logins my users were successful with.

Of course, before you experiment, back up your existing default.asp file, JUST IN CASE.

Have fun!

,

thats not good.. its a web server configuration issue of some sorts ?

post is a common method for forms.. if it is not supported it is something you should ask the server admins about.

Is this a windows based web server running true microsoft ASP because that error is usally associated with non windows IIS based web servers from what I can see by doing a google search ?

ASPProtect only runs on windows servers running IIS and True Microsoft ASP.
http://support.cjwsoft.com/code/moreinfo165-1.htm

My guess is your web server is running Apache Unix or something like that.

We have been using ASP Protect for a while now and are big fans of the program. We received ASP Banner 8.2 with our puchase which we now have a need for. I went to put the files on our webpage, and doing nothing else other than locating the directory there, I noticed differences with how ASP Protect operates. We have customized it a bit and want to keep the 2 programs separate. the login screen for one showed up on the other, and some ASP Protect pages appeared altered so i immediately deleted ASP Banner. did I do something wrong, and how can i ensure the 2 programs work completely independant of each other? We can't risk braking what we're now using but would really like to add banner functionality to some of our pages. maybe an update to the program before we install? puchase new software? Thanks for your help-

This issue came up once before and when I investigated I could find no error in the html that aspprotect generates and those files do exist where they are supposed to. We concluded it was a parsing error from the log file system.

There just really isn't anything I can do about it. I spent a week trying to figure it out. It is just the log parser screwing up under certain circumstances where there is no reason anything is wrong. They have trouble dealing with some of the complex URL/querystrings that the ASPProtect admin area uses. They think there is a 404 eror when there isn't... etc etc

Not to be pushy, but how's the new version progressing?

I'm hoping these features will be in it:

possibly add the ability to move pictures around in an album. and maybe between albums, I must also remember to move the ratings and desc as well for that image.
possibly add a feature to store 3 versions of images uploaded
thumbnail, medium res, and high res/original
add option to store the images orginal name in the images description area during upload
may be helpful to people that name their images in a somewhat descriptive way
add support for the ibulc bulk upload client that I recently discovered

If you could use a beta tester, I'm still just setting up my site and would be willing to run a beta.

Thanks

I purchased 6.0 in Feb 05. Is there an upgrade price to 7.0

I spent considerable time setting up 6.0 to work with my web site. From what I read in the forum, it sounds like I have to start over again to integrate the new version into our web site. I do not relish the thought of that, but I have to move to an email system with a valid MX record.

Will I be starting over from scratch with this upgrade?

It is refered to as the internet guest account but that isn't the actual username. The username is different for every machine. It usually starts off with "IUSR_" and then your machine name. "Internet Guest Account" is always the account's full name as labeled by IIS when it is installed.

Regardless,

If an account isn't listed you have to add it.

Click (add-advanced-find now) and it will list off all the user accounts on the machine

You can also click (add-advanced) and simply type in the account name or part of it.

Some more tips:

If on a local machine you always just give the "everyone" account full control which is pretty much going to make anything work.

You can also go to computer management in your server's administrative tools and view all of the accounts and groups there under "Local Users and Groups".

cwilliams38417.7186689815,

Its not on their end. Using ASP alone you really won't be able to send more than around 300-400 individuals emails at a time before things will time out. Its just that ASP is not an efficient way of sending email and it never will be.

You really should look into worldcast like I mentioned before.
http://www.fairlogic.com/worldcast/

Then just export the email list from the database into worldcast and send out the newsletters.

You will get much better results and perfect newsletters and it really only takes a little bit longer to do each time once you figure it out. That is how I send out my PowerASP and CJWSoft newsletters and it works perfectly every time.

, Not sure how to response.write the session variable,

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/aspprotect/password_admin/default.asp, line 287

I'm doing an upgrade from an OOOOOOOOOOLD version (not sure if it was 6 or not) and it read my database OK prior to adding a new user. Now I get this error message. I was able to run the password encryption function OK, but I still get this error when I try to view the password_admin stuff. I can log in via the "get_me_in" asp page just fine, but I get the above error.

If I try to log in with my admin account, I get

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/aspprotect/password_admin/check_admin_inc.asp, line 166

*****

OK, my question is this... if I retype all the info from the old DB into a brand new one, never before used, that would work, right? I only have 108 users, so that's about an hour of work. Or is there a 5-minute fix that I can try? I've done some messing around that got nowhere and returned all edited files to their original state, with the exceptions of the ones calling the DB location.

I'll start the C&P process and await your reply...

On a side note, I really love the new format and am excited about the new features. I'm not married to upgrading the DB and if copy and paste is faster (I just need first name, last name, username, password, email, and expiration date), then I'm using v.7 that much faster.

cwilliams38457.6090509259,

its a text file you just edit it with notepad.. if ya mess it up ya put an original copy back in

no biggie either way

jump in there..

I just showed ya exactly what to change.. its a no brainer man
This is simple source code. It's meant to be edited and hacked.

The only reason I warn you is so you can't blame me later on if it effects something

I am just trying to help

If ya dont like that solution why not just use periods for the first name field.. or a dash or something... then nobody will really see it

or maybe store the company name in the first_name field

seems like clever things to try without changing the code..

good luck...

cwilliams38326.870474537,

look in the "check_user_inc.asp" file

Thank you that did it !!

I used Dreamweaver4 to make my site is there anything I can do to make it work?

Hi,

I am just wondering if anyone else has had this problem. Even though the guestbook is empty, it takes just about 20 to 30 seconds for the guestbook/default.asp lto oad. Is this normal has anyone else has had this problem.

Thanks

Don't want to install the application ?
Having trouble doing it ?
Don't think you can ?

No problem, have us install it for you.

PLEASE READ ALL OF THIS

Installation service is generally available Mon - Fri during the hours of 10 am - 7 pm EST.
We may very well be around to do installs at other times but we do not guarantee that.

To do an install we generally need FrontPage Explorer or FTP access to your site.
We also need a way to set permissions on any necessary directories, etc etc.

To do a SQL Server install we need to access your SQL server via Enterprise Manager.

Some installs may require access to other things not mentioned.

The server must be a properly set up NT/2000/2003 server running IIS 4-6 for ASP 3.0 applications.
(with support for ASP scripts and database connectivity.) Parent Paths must be enabled on the server.

Please Note:
These ASP scripts do not run under Chillisoft ASP. That means they do not run under Unix, Linux, Apache, etc etc.
We do not install our applications on free ASP Hosting solutions. Why, because they are more trouble than they are worth. Free hosts like that are usually zero help if we need something changed. There is a reason they are free.

We install the software in it's base configuration. We make sure it is running correctly. If you break the installation you will have to pay to have it fixed. We do not integrate it with your existing site or edit any of your existing web content. That is up to you. Installation fees are non refundable as is the digital source code we sell. When you purchase anything from us you agree to this.

We do not do installs for IPNFulfill and Color Sequence Protection as they are simple scripts and do not even use a database.. We also do not install the IPN Support Pack as it is just a folder you copy into your web and some configuration files that you must decide how to configure based on your needs and your PayPal account info.

Installation Service Pricing

Any CJWSoft ASP 3.0 application (Access Database Installation)	25.00
Any CJWSoft ASP 3.0 application (SQL Database Installation)	40.00

Contact us if you have any questions.cwilliams38165.5615277778,

ok, well if you want to test on your own.... in the ipn.asp file for the subscription folder you will see this area of code used for testing

' Un-comment this section and give this directory proper permissions to enable logging to a text file
' Very helpful for troubleshooting
'   Set ObjMyFile = CreateObject("Scripting.FileSystemObject")
'   LogFileName = ("paypal.txt")
'   'Open Text File.. If doesn't exist create it and append to it .. If exists just append to it
'   Set WriteMyData = ObjMyFile.OpenTextFile(Server.MapPath("paypal.txt"),8,True)
'   RowHeaderString = ""
'   RowHeaderString = RowHeaderString & OrderID & vbTab
'   RowHeaderString = RowHeaderString & Custom & vbTab
'   RowHeaderString = RowHeaderString & User_ID & vbTab
'   RowHeaderString = RowHeaderString & subscr_id & vbTab
'   RowHeaderString = RowHeaderString & txn_type & vbTab
'   RowHeaderString = RowHeaderString & subscr_date & vbTab
'   RowHeaderString = RowHeaderString & Access_level & vbTab
'   RowHeaderString = RowHeaderString & Groups
'   WriteMyData.WriteLine(RowHeaderString)
'   WriteMyData.Close

now that folder will need modify permissions for the text file to be written to but this is a good way to test if the ipn.asp page ever gets hit by paypal.

ITS REAL IMPORTANT THAT THE TEST FILE CAN BE WRITTEN TO OR DOING THIS WILL JUST CAUSE MORE ISSUES

To ensure the text file can be written to and permissions are correct for that folder you can make a new .asp in there and run this to see if the text file writing works

   Set ObjMyFile = CreateObject("Scripting.FileSystemObject")
   LogFileName = ("paypal.txt")
   'Open Text File.. If doesn't exist create it and append to it .. If exists just append to it
   Set WriteMyData = ObjMyFile.OpenTextFile(Server.MapPath("paypal.txt"),8,True)
   WriteMyData.WriteLine("the file was written to")
   WriteMyData.Close

Now, you can even change the location of the text file to place that does have permissions if you like.

This is what I would do if I was in there... then I would make some test payments using 1 cent and another paypal account (your allowed 2)

and see what happens

it is always possible the subscription code may have a bug in it. The last time I tested I only tested the single payment folder which worked perfectly. If I have time in the next couple days I am going to test the subscription stuff again. If there is something wrong I can cure it quickly.

The two routines share a lot of code in common.

cwilliams38421.6488773148,

Your users with Internet Explorer may have received the "Page Expired" error. For ASPProtect users, it happens when the user is not logged on and tries to invoke the target page. check_user_inc.asp puts up the login form, and IE sees it as part of the target page. Any later attempt to Back up and reload from cache gives the errror.

My solution was, after successful login, instead of falling through the bottom of check_user_inc.asp and running the target page, I issue a re-direct to reload the target page. I also added META tags on the dynamic login form to say no-cache and expire now, so the re-direct really does reload the target page. This time, of course, check_user_inc.asp does not need to put up the login form, and the new target page in cache contains no form at all. So, IE will not give a Page Expired error when Backing up to it later.

Netscape, and I gather other browsers, do not behave the same way, so I limited the solution to IE. Also, the solution only works if the target page has no form of its own.

I'm uploading my customized version of check_user_inc.asp that contains this solution. (In it, I also used the Javascript focus method to place the "cursor" in the Username field when the login form loads.)

2004-11-22_050940_check_user_inc.zip

cwilliams38313.494537037,

It's custimization work. and just not something I can support.
Basically it is basic ASP/Database work.

Something you kind of need to figure out on your own. It's not difficult work for a good asp coder but there is no easy way and it is time comsuming.

I wouldn't use the custom fields though. I would make your own.
It's simpler that way.

cwilliams38437.0929282407,

It really means just what it says. Your connection string is just not valid and the sql server speicifed can not be reached. The username and password could also be invalid. Since you already had a database set up you should use the same username and password you have always been using. You also need to use the same database name you have always been using. Without actually knowing more and seeing what you are doing it is pretty hard to tell you anymore than that.

The directions and sql scripts given are for setting up a new sql database. Applying them to an existing sql database requires a slightly different approach. Modificiations to the SQL scripts elimintating references to the usernames/password/database we suggest in the scripts is also a good idea.

A data connection is a low level as it gets. Until you get that working you are really not even touching any of the code in the ASPListings application.

If you want I have no problem going into your sql server and web and setting up for you correctly.

cwilliams38301.7362037037,

Than you

I'm happy after changing to XML parser for two of the ads. Later I'll change the other codes to XML, never to use iframe again!

, Okay, I'm going nuts trying to find that settings screen.

I've got a dedicated server that I connect to using "Remote Desktop Connection" so it looks like a regular Windows desktop. It's running Windows Server 2003.

There's a program called "IIS Manager" but I've looked at all the options for all the different sections and I don't find anything that looks even remotely like that screen. And, of course, Windows Help is no help at all.

What program do I run to get to that configuration screen?

Thanks,

Robert Gidley
,

The parent paths things really should not be an issue.

This is an article from the troubleshooting section of the documentation that takes care of it all very easily.

http://support.cjwsoft.com/code/moreinfo162-1.htm

As for a good host that knows ASP and does not mess around when you ask for something. I always recommened www.alentus.com

Timecard Entry: 3/25/2006 1:43:47 PM

*energy initiatives: conversation w/Craig Kieny, teched phone calls, Talked to Amy about new site: Gtosportspromotions.com, go over stuff with andy and check on stuff in other building, Answered phones and did callbacks and DUI. Not busy., Took tech calls, checked DUI, AUAQ, RAD, and Voice Mail. Called users back with expiring accts, and DUI. , Brownville specialty- quoted ISDN for Tramway in Watertown, spooke to affordable housing, spoke to rex re: whites quote- spoke to Seth about the weeks quotes, contacted Jim Crowley regarding the Sithe Quote, prep for Tech meeting, Home sick with the flu., had a few general calls. had to call dave because several of the watertown lines went down, Answered the customer's email that were sent in. , steady, techcalls, new users, BALWINSVILLE CHAMBER : DESIGNING GRAPHIC OF ALL MAJOR LOCATIONS FOR TOWN TO BE PLACED ON HOMEPAGE., Download and set-up streaming media tools, QB bounced checks and reports for admin site and faxed to Errol and the McNally's, making text changes on Ogdensburg Brige page (ogdensport.com, billable), VT invoices, Discussed wan quotes with dave storandt, broght rex inon a few new projects , checking and responding to email, 7513, Worked on Web site evaluation survey for JCC business class and emailed it to Pope Vickers., work on emails, voice mail, timecard., Traveled through Ogdensburg and then back home. , had a call about email, PSI, Vermont Trip, Newsletters, Old Customer Letters, Power Point Presentation, meet with Bob Redd from TeleVantage, discussed quote the followed him to Lockport and Rochester for demos of working TeleVantage systems, answering phone, taking sign ups, checked emails. , callbacks. new users, lunch, MLS training meetings,

Active Server Pages Rule The World

Contact Us

All artwork, design & content contained in this site are Copyright � 1998 - 2025 PowerASP.com and Christopher J. Williams
Banner ads ,other site logos, etc are copyright of their respective companies.
STATS Unless otherwise noted - All Rights Reserved.

Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspclassifieds.com, www.powerasp.com,www.cjwsoft.com,www.aspphotogallery.com,www.codewanker.com,www.aspprotect.com,www.aspbanner.com