Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Limit characters to numbers

Posted on 2001-07-26
11
Medium Priority
?
152 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 2
11 Comments
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6322111
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
ID: 6324144
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
ID: 6324190
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
Plesk WordPress Toolkit

Plesk's WordPress Toolkit allows server administrators, resellers and customers to manage their WordPress instances, enabling a variety of development workflows for WordPress admins of all skill levels, from beginners to pros.

See why 2/3 of Plesk servers use it.

 
LVL 7

Expert Comment

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

Author Comment

by:paulvb
ID: 6330626
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
 
LVL 7

Accepted Solution

by:
ClassyLinks earned 400 total points
ID: 6331406
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
ID: 6345642
How's it going Paul?
0
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6359179
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
ID: 6372268
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
ID: 6398635
3 weeks w/o response  ;-(

Submitting to CS.
0
 

Expert Comment

by:ComTech
ID: 6399160
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
Geo-targeting is the practice of distributing content based on a person’s location, as best as you can determine it. Let’s look at some ways you could successfully use this tactic. The following tips and case studies could lead to meaningful results.
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…
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…
Suggested Courses

609 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