• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 153
  • Last Modified:

Limit characters to numbers

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
paulvb
Asked:
paulvb
  • 8
  • 2
1 Solution
 
ClassyLinksCommented:
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
 
paulvbAuthor Commented:
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
 
ClassyLinksCommented:
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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
ClassyLinksCommented:
Paul.....does any of this help, or do you require further information?
0
 
paulvbAuthor Commented:
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
 
ClassyLinksCommented:
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
 
ClassyLinksCommented:
How's it going Paul?
0
 
ClassyLinksCommented:
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
 
ClassyLinksCommented:
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
 
ClassyLinksCommented:
3 weeks w/o response  ;-(

Submitting to CS.
0
 
ComTechCommented:
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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 8
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now