Solved

Limit characters to numbers

Posted on 2001-07-26
11
146 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
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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
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 100 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

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…
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 automatically show related posts at the bottom of a blog post in WordPress. This will be demonstrated using a Windows 8 PC. Plugin “Yet Another Related Posts Plugin” will be used. Go to your…
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…

733 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