Home | Advertising Info111 USERS CURRENTLY ONLINE   
PowerASP
   Site Search Contact Us Friday, March 14, 2025  

PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net CJWSoft ASPProtect ASPBanner ASPClassifieds



Blog Entry: 3/25/2006 4:33:50 PM

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"><font face="Arial" color="#000000" size ="2"><b>First&nbsp;Name& lt;/b>&nbsp;</font></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 %>"><font face="Arial" size="1">&nbsp;<%= CmdListUsers("First_Name") %& gt;&nbsp;</font></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!

,

Christopher

I have gone back to your original files and uploaded them to another server folder and instead of using a DSN I have tried this with a DSN less connection and changed the database to MS Access 2002.

This has corrected the problem.
I will check this out again using the DSN with access 2002 to see if this was the problem. It may be something to do with an older format of database on this particular server.

I will let you know what I find.

Thanks for your  quick reply.

,



  Much thanks, the duplicate incl's I spaced on and should have caught.  The hidden form variable was a key issue.  Thanks for the syntax and the help.  Now I get this page together. j  As a note - I got faster results by dropping my timeout to 3 minutes temporarily while progging and cleared browser cache between tests.  Thanks again.

,

Now that I think about you may very well be able to use the existing login_form_inc.asp page

the header and footer files for the users area may be ok as well.

probably the smart thing to do is try your old ones and compare them to the new and see if everything you need is there. If not add it by looking at the source html and comparing.

All other files should definetly be replaced with the new.

,

yes, How can I have fixed size height and width image without distortion. Is there a component that I can use or how can I change the existing code.

 

 

 

yes, unless its ratio matches

how could it not be ?

Please keep questions like this in the forums... thx.
there is no need for this to be a private message


-- Previous Private Message --
Sent by : eeye
Sent : April/29/2005 at 2:19pm


If I choose fixed width and height is the thumbnail image going to be distorted?

-- Previous Private Message --
Sent by : cwilliams
Sent : April/29/2005 at 1:17pm

that is not possible unless you rewrite the code.

You onlyahve the two options we give in the config file for thumbnails

fixed width and height all the time

or

fixed width / dynamic height



-- Previous Private Message --
Sent by : eeye
Sent : April/29/2005 at 1:07pm

Hi William

One more questions for you. is there a way to make sure that all the thumbnails are the same size without distorting the images (in the thumbnails). Or if a picture's height is bigger than its width is there to create the thumbnail such that the height of the orginal becomes the width of the thumbnails and vice versa.

Basically I just want the thumbnail pictures to be in a perfect row with all the picture heights the same and all the pic width the same.

Thanks

Sean

,

(User Search & Contact Mod) for ASPProtect Version 7.x

This will allow an individual user to search for other users as well as email or call them.

Notes: This is a down and dirty mod. The users page from the admin area was used as a starting point. I then edited it up real quick to be used as a user search. The way it is it shows the user email as a regular email link. If you want to set it up so emailing is done from the application and emails are not actually shown you will have to do some extra work. If you don't want phone numbers shown you will have to remove that column which is not very difficult.

Directions:
Back up your existing ASPProtect installation.

copy "search.asp" into your "users" folder

2006-03-10_143253_User_Search_Contact_Mod.zip

Direct your users there. They will have to be logged in to view the page.

WARNING: This has not been extensively tested for SQL Injection attacks.
I think it is perfectly fine the way it is by looking it over quickly, but use it at your own risk.

,

I'm having another problem-hopefully it's a quick fix.

 

If i try to login as a user in the Http://localhost/aspprotectlogin.aspx page

 

it tries to go to a page: default.aspx    

 

Server Error in '/' Application.


The resource cannot be found.

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested Url: /default.aspx

 

When i log in as admin from the aspprotectadmin/default.aspx that works fine...

where should the user be sent when they log in? Am i supposed to specify that or is it automatic? Why isnt it working for me? I dont believe i changed any settings that correspond to that either

,

Javascript Popup/Pop Under Generator

Until I have time to make one I suggest using the one on the banmanpro support site as it is pretty nice.

Just dont use option 2 on that page as that is specific to banmanpro


http://www.banmanpro.com/support/popupgenerator.asp

cwilliams38291.614849537,

Yes.

Now its OK

Thanks Christopher

,

I post new ads ,  can view it in  admin area 

but  when  go to first page  no ads show  

all categories show   (0)  

How solve this problem ?

PS: I set default auto approved ads

,

This is a great article from my old powerasp.com site.
Connections And Server Database Permissions

 

cwilliams38084.7458217593,

This isn't going to help you much but here is the deal.

The 2checkout support in ASPProtect actually is not supposed to work with 2checkout subscriptions and therefore does not need to use an item number.

It is intended to be used for single payments only with 2checkout as explained in this thread.
http://support.cjwsoft.com/code/moreinfo212-1.htm

Single payments with 2checkout use their shopping cart which allows for dynamic payments without needing an item number.

I agree with you that 2checkout's interface is confusing. It's actually about the worst system I have ever seen. I could not make a 2Checkout subscription system because their system is just too limited and I couldn't make it work the way it really needed to.

,

I am confused.

Humm, how did ASPBanner 8 come with your purchase of ASPProtect ? That is not something I am aware of or something I do. Please provide more information on how you obtained ASPBanner 8. If I gave yu a copy for some reason please refresh my memory so I can go look up th emails about it. I need to know you have a valid license.

Now, as for the two not working together and the login screens messing with each other. I am even more confused. Tell me more as I just do not understand what you did ? ASPBanner has it's own user database and login system so there is no reason you should be mixing the two together as far as logins go. The two applications can certainly be in the same web together and not bother each other. ASPBanner can certainly serve banners to any pages you protect with ASPProtect or don't protect, but you certainly should not be protecting any ASPBanner code with ASPProtect code.  ASPBanner already has code in it to do that. If that is the case don't do that. ASPProtect is not meant to protect code that already has a login system. That should just be obvious as far as I am concerned and hopefully you dintn't try to do that.

(you said you just put the directory in there but there must be more too this than that)

But again, tell me more. I can't really know everything  ??

I just dont see how your ASPProtect pages could be effected by ASPBanner unless you really did something wacky like included the ASPBanner "check_user_inc.asp" instead of the one that comes with ASPProtect or overwrote it... etc ect

If in the same web aspprotect can be wherever and aspbanner needs to be in a folder called "aspbanner". There should be no conflicts under normal use and the two will essentially run seperate of one another.

,

sure (XP PRO), see my article on that

http://www.powerasp.com/content/new/windows_xp_pro_and_permi ssions.asp



 

, Okay, got it!!  just in case anyone else is having the same problem, after creating the new thumbnails using the "generate_new_thumbnails.asp".  Turn off the random photo selection for a 10 minutes or so, and then turn it back on.  
bwinklesky38324.5085069444,

import/export feature WARNING !!

I just want to warn everyone that the built in import/export feature can be a little dangerous.
The reason being is when you import users they get new "Users_ID"s in the database.

The "User_ID" field is an autonumber field and that is why and there is nothing you can do about it.

So, if you are using a user's current "User_ID" to keep track up something important NEVER export the users and re-import them. Because their "User_ID" will change and you will be in trouble.

The PayPal signup features of ASPProtect actually use the "User_ID" like this and that is the main reason this warning is here.

now, that being said

If you are importing new users into ASPProtect

or

simply exporting existing users to another system

then this is nothing to worry about.


Basically, the moral of this story is dont think of the built in Import/Export feature as backup system because it is not. It is not a substistute for backing up your database.

It is a just a tool that can come in handy for various things.

cwilliams38425.0597685185,

A very common and extremely bothersome error encountered when running ASP apps that connect to a database is the "80004005" error. It comes in many varieties.

These articles cover it.


(an article I wrote)
http://www.powerasp.com/content/hintstips/permissions.asp


(more articles)
http://www.aspfaq.com/show.asp?id=2009

http://support.microsoft.com/default.aspx?scid=kb;en-us;3065 18

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=115

http://www.macromedia.com/support/ultradev/ts/documents/8004 005_cannot_open_unknown.htm

 

 

cwilliams38102.4447222222,

you have to check the session variables for groups a little differently.. info on that is here

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

,

here ya go

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

 

 

, humm,

thats a new one.. something is very wrong.

Please show me screenshots of exactly what happens and what you see. It does not make any sense so I need more info or I least need it described in more detail.,

Thank you so so much! I went to the admin area and changed the email component from CDOSYS (using remote server) to CDOSYS (using port 25 forwarding) and all is working great now!

Again, thanks!

,

Please be aware folks..

This file is not provided by CJWSoft. Though this may work very well use of it is not supported in any way. We have not tested it.

This user is not using the option pack so this file will not be compatible with anyone using that because it does not have support for groups and some of the other new features.

Regardless..we appretiate users sharing ideas and solutions that they have come up with.

cwilliams38313.499837963,

the reason being is because when I do installs I do not touch any of your existing content. I only install the base application and make sure everything in it working correctly and also that the example protected pages are working. I do not integrate it with your existing site or edit any of your existing web content. That is up to you

sorry about that, but it would be way too time consuming and editing people's existing pages is a good way to cause a lot of headaches for me and the customer if something goes wrong. Not only that but everyone uses the system differently and it wouldnt make sense for me to be the one doing that based on access levels, groups.. etc etc  which will all be custom to how you want things set up.

more on installation policies here.
http://www.cjwsoft.com/installation_service.asp

,

Tony,

ASPBanner.NET was discontinued about 14 months ago. It is no longer supported in any way because quite frankly the classic ASP version is faster, more stable, has more features, and is a lot easier to install and get running.

If you PM me via the forum you are welcome to a copy of the current ASP Unlimited Version. It can serve banners to any type of page extension. All you have to do is ask for a copy.

Whether or not your existing ASPBanner.NET database is exactly the same structure I do not know, but I believe it is. You should compare the two if you plan to keep using the old database and make any neccessary changes so the old database has the exact same structure as the new version. If there are any differences they are very few.

,

I just moved servers and now my "code" ads are giving me errors...

"google_ad_width" is undefined.

I have tried adding the width and height... taking it out.. all the basic stuff.

Any ideas?

TIA  

,

Your probably talking about "Session.Timeout" which is a feature of the IIS webserver. Please do a google search on it for more information.

In the meatime if you look at the top of the "check_user_inc.asp" file you should see a section like this where you can try to change the value.

' Minutes you want before the session times out.
' This is set on the server to be default to 15 or 20 minutes depending on the server version
' You can change it there or override it here.
Session.Timeout = 30


Specifying it like that is supposed to overwrite the value for your web in the IIS console which is usualy 20 minutes.

,

Hello,

In that version is is not easy to change the values as they were not intended to be edited. You would have to dig through quite a lot of code as those values are hardcoded in quite a few pages. Probably at least 10 or more.

In the pro version there are variables you can change that very easily as that is intended to be easily changed in that version.

,

It appears there was a flag problem. When reading it into SQL Server, it converted the True/False in Access to 1/0 in SQL Server.

 

, If you PM your site info and I can go in and troubleshoot. I have no more ideas. Usually people have zero issues installating this application as I got it pretty tweaked so I need to see what is going on in order to help.,

Here are three known bugs and their fixes...

 

If you have any of these symptoms these fixes will most likely take care of them.
If you don't have a symptom do not make any changes as you most likely have an updated copy of the application.

Technically if you bought that app on or after April 27th 2004 these bugs should all have been corrected.

 

 

Description Fix

(no descriptions showing in pop up window)

 

Edit pic_window.asp with a text editor

 

Change

 

Set f=fs.OpenTextFile(Server.MapPath("pictures/Album_ID_" & Album_ID & ".txt"), 1)

 

To

 

Set f=fs.OpenTextFile(Server.MapPath("../pictures/Album_ID_" & Album_ID & ".txt"), 1)

 

 

Slideshow Fix…

(last image in slideshow it not showing)

 

In slideshow.asp

 

Change

 

<% For PicArrayIndex = 0 To Ubound(PicArray) - 1 %>

 

To

 

<% For PicArrayIndex = 0 To Ubound(PicArray) %>

 

 

Add To Favorites fix

(add to favorites feature doesn’t work at all)

 

Edit "album_uppermenu_inc.asp" in the scripts folder

 

Change

 

<a href="users/favorite_albums.asp?Album_ID=<% =Album_ID %>"><img border="0" src="<% =application("skinpath") %>add_to_favorites.gif"></a>

 

To

 

<a href="users/favorite_albums.asp?Album_ID=<% =Album_ID %>&Action=Add_To_Favorites"><img border="0" src="<% =application("skinpath") %>add_to_favorites.gif"></a>

cwilliams38104.7034375, As I'd said in my previous response, I found those databases and they didn't work. All three databases in asptest do work.,

I am having an issue with the Thumbnailing process. My host does not support ASPImage so I have to use something called asp thumbnailer which is similar to ASPImage. I am trying to modify the Dundas upload to automatically reduce the images to create thumbnails. I ripped out the asp image code and replaced with the bottom. The main issue I believe is grabbing the image files. I am not sure how to name the actual image file that is already uploaded by the dundas upload. the code is below:

The peices in red are where the issue is I believe. What you see below is my attempt to identify the exact image and then rename it tthumbnail. My optimal solution would be to take the picture, resize it and rename it exactly what it was named before.

 

Any ideas

 

Thanks

 

 

<% Else %>

<%
 Dim thumbObj
  
 Set thumbObj = Server.CreateObject("ASPThumbnailer2.Thumbnail")
  
 If thumbObj.LoadFromWeb("../pictures/" & Filename) Then
     thumbObj.ThumbMaxDimension = 140
     If thumbObj.CreateThumbnailToWeb("../pictures/Thumbnail.jpg") Then
         Response.Write("Thumbnail successfully created.") 
     Else
         Response.Write("There was an error creating the thumbnail.")
     End If
 Else
     Response.Write("<p><hr><b>Unable to load the original image.</b><hr>")
 End If

 
Set ConnClassified = Server.CreateObject("ADODB.Connection")
ConnClassified.Open ConnectionString
Set cmdTemp = Server.CreateObject("ADODB.Command")
Set CmdSetImageInfo = Server.CreateObject("ADODB.Recordset")
cmdTemp.CommandText = "UPDATE Ads SET Image" & PicNumber & "_Uploaded = 1, Image" & PicNumber & "_FileExtension = '" & FileExtension & "' WHERE (Ad_ID = " & Ad_ID & ")"
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = ConnClassified
CmdSetImageInfo.Open cmdTemp, , 1, 3
%>

,

no, that only applies to random pictures and stats..

 

The issues you are talking about usually relate to issues created by switching back and forth between a local install and a live server install and not being careful about changing the paths in the settings depending on where you are running it from.

For example.. it trying to use a url at the server level that is only valid when you are running it locally

cwilliams38394.7554976852, Its not a known issue.. I would try the original code before you made any changes and see if it still happens to you.

It seems to be working fine here for me in amy test web.

I am going to look into some more in the meantime.cwilliams38341.7166782407,

I know what is happening.. its the old single quote thing messing up the query string..
but it shouldnt be happening with the newer code as I fixed it.

If you like I can go in and reproduce/fix the issue. I can not think of any other way I can help you as other users have not reported the issue.

Chances are if it is happening in one situation it will happen again in the future.. it really all depends on the passwords being used and your encyrption key... other passwords may produce the issue even if the password is correct

basically once the password gets encrypted it by chance has a single quote in it... then it messes up the query

I take care of the situation by replacing the single quote with a double quote but it looks like you found a situation where that didn't work out

 

cwilliams38453.8921990741,

I'm all set - after thinking about your replies - i checked a bit more and changed the email component type -- thanks again for all your help.

,

all I can say is try other things...  like

mail.yoursite.com

or

smtp.yoursite.com

etc etc etc

replacing yoursite with the name of your domain of course


the settings for sending email via ASP are no different then the settings you would use in outlook or something... except sometimes on the server level localhost works as the email server because they set it up to allow that

and of course those 3rd party emailing components need to actually be installed on the server

,

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.

,

If things are not perfect there will be no log files and no errors.. it can only be one of these things really
http://support.cjwsoft.com/code/moreinfo313-2.htm

You may also want to make your the filesystem on the server is working and not disabled by norton script blocking or anything random like that. Testing the filesystem object is best done by writing a simple text file to a folder. Plenty of examples of doing that can be found at www.aspin.com

Recent activity is temporary and admin activity in the admin area is not tracked. If your application in IIS has reset or there has been no activity in the users area or in pages you protected there will be nothing there. The busier your site the more chance something will be there. For example usually our online demo has something there except right after 4am when my server does an iisreset.

, Well, I had no more trouble after I read the instructions.

The PayPal integration is really neat stuff! WOW!  And the email users function got up and running in a snap... this is an awesome package!

The coolest thing with the user registration is that the account username and password are selected by the user. That is very very nice. Much less typing for me to do.
,


Timecard Entry: 3/25/2006 4:33:50 PM

Creating sample site for school grading system so Beth and Kelly can use it without corrupting database., worked with by on handout - finalized notes with jc. worked on layout. reviewed mbo layout with kv. went to watertown office to drop off cds., Ordered line for Hyde & Stone, TICC bills/PO's/ WO's, talked to ef about changes made with by in contract. emailed revisions to by. talked to kw from seneca about ks and sr at matrix. called sr to find details. , training on dsl in watertown, mail out press release, work on mls, timecards again- trip to the post office., travel to watertown, Balance Sheet, develop proposal for space age pools , Easy afternoon, Duties: answering phone, quality checking sign ups, taking sign ups, callbacks from voicemail. checking billing emails, making copies of gisco forms, cancellations, , business fair, Checking out Steves new time-card package, *TaskForce: Competitive research; Technology research and discussions; MS Exchange Server Install, SoftMLS Trip to Florida, SoftPublication - Completed component type1 (Text and/or Picture u/l) edit/delete commands. Adding ''show-more'' feature., Helped Tara revise couppon copy and discussed tracking codes for the new cds, Nortel 3161 Passport, steady, techcalls, new users, voicemail, new/close out w/o, close out time sheets and archive w/o's, time card approval, work Lovelynx issue, issue account cancellation policy to Amy/Lisa, work Velcrostore issues, work Allman promo issues, Jim Wright letter rewite, Not too busy a few calls... cleaned up a little and took out the trash., work on some network problems and customer problems, Stopping in Clayton. Dropping off copy of social security card to Fred. Checking on a few things in Clayton., cphospital.org - installed new navigation rollover menu and fixed all links. Re-coded admin main menu to match new navigation structure, setup all upload and banner ad components. (billable), JCC - community center meeting, Checking e-mail. Checking voice mail., On phone w/Forever Broadcasting about this weeks updates and front page training classes., Alliedcoop.com exchanged cow photo in header with another photo, search for cow photos, photoshop work on those photos, insertion of photos, hyperlink graphical , Spoke to leslie McKinney, sent out promotion schedule worked on the time cards, SQL Self-Study,

   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 a directory of ASP tutorials applications scripts components and articles for the novice to professional developer. 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