Solved

Limit characters to numbers

Posted on 2001-07-26
11
142 Views
Last Modified: 2013-12-24
How do I limit a search field so the end user can only enter 7 digits and be in number format only?

Thanks
Paulvb
0
Comment
Question by:paulvb
  • 8
  • 2
11 Comments
 
LVL 7

Expert Comment

by:ClassyLinks
Comment Utility
Using the FP search feature?  <AFAIK> it is not possible.

There is no way to set these parameters within the wizard itself and because this is one of those features which needs to be "published" there is also no way to modify the html externally.

You could easily build a search feature in ASP to do what you require though.  Is this an option?  If you can run ASP on the server, I could walk you through it.
0
 

Author Comment

by:paulvb
Comment Utility
What I really need to do is setup an Access database, I am very familiar with Access,
but I have no idea how to even start with ODBC. If I had a simple databse to start with that I could look at and take apart and change. This would be a great help to me.
As far as .asp I know very little about this. What do you suggest I do?

Thanks
Paulvb
0
 
LVL 7

Expert Comment

by:ClassyLinks
Comment Utility
Good choice!

As an aside 90% of the questions I answer in here are related to just that.  FP can't do exactly what we want it to.  Usually ASP can.  8-)

Great sites for ASP components/tutorials include:

www.asp101.com
www.activeserverpages.com
www.asphole.com

As for a search script...

http://asp101.com/samples/db_search.asp

Either download or view the ASP code...it is well documented.

You can always post here for more help, or ask ASP specific questions in the ASP topic area.  In here, you get input mostly from me.  In there you get help from dozens!

Does this help?
0
 
LVL 7

Expert Comment

by:ClassyLinks
Comment Utility
Paul.....does any of this help, or do you require further information?
0
 

Author Comment

by:paulvb
Comment Utility
I went to these pages, but I think .asp is over my head. I need a sample ODBC to see what is involved. I know Access pretty well.
Thanks
Paulvb
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 7

Accepted Solution

by:
ClassyLinks earned 100 total points
Comment Utility
Take a peak at this thread:

http://www.experts-exchange.com/jsp/qShow.jsp?ta=frontpage&qid=20155672

I posted a little script for pinkstronm.  Perhaps it will give you some ideas.

There is no way that ASP is over your head.  If my little blonde brain can do it, anybody can!

The beauty of ASP is that you are really just plunking in "variables" into your HTML....pulling in values from a database.  You can do all your design work in FP, and just switch to HTML mode for the database connection.

The simple DB connection is:

<%
    'Opens a connection object
          set conn = server.createobject("adodb.connection")
conn.ConnectionString="Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../yourdb.mdb")&";"
conn.open
    sql="SELECT * FROM yourtablename"
       %>

In this example, the database is one level up from the page this string is on.  All that is needed is to change the MapPath setting to point to whatever folder you are looking for.

Questions?
0
 
LVL 7

Expert Comment

by:ClassyLinks
Comment Utility
How's it going Paul?
0
 
LVL 7

Expert Comment

by:ClassyLinks
Comment Utility
Paul, please return and let me know how you are making out.  I cannot provide assistance if I do not know what has already worked for you and what has not.
0
 
LVL 7

Expert Comment

by:ClassyLinks
Comment Utility
Paul...I haven't heard from you in almost 2 weeks.  I'll wait until monday and then request assistance from CS to close this question.
0
 
LVL 7

Expert Comment

by:ClassyLinks
Comment Utility
3 weeks w/o response  ;-(

Submitting to CS.
0
 

Expert Comment

by:ComTech
Comment Utility
This question has gone over the require 21 day period.  The give me the ability to accept an answer due to the absence of the User.

I will award this question to ClassyLinks.  In he last comment to Paul was that it was not over his head, and provided information as to how it can be done.

Thanks all,
ComTech
Community Support
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now