I have a string called EmployeeName. This variable has the first and lastname of the employee.I would like to know if it is possible to extract the lastname into another variable for searching.
Did anyone know how to do the seperate? when i search "aaa" keyword from database. and their is 100 result i want to seperate it to dispaly 20 result perpage. like the search engine 1.
I want to have a page that has several links on it, each link will do a different search on a database. Now I know how I can achieve this using different pages. (a.asp b.asp c.asp etc etc for example) however i've noticed a lot of webpage that just use one search.asp page and then the id changes for example the address will be search.asp?id=1 for example, hope this makes sense.
I have a dbase containing login details for 21,000 members. I also have a forum that I am about to implement.
When the user gets to the main site, he has to login (this is done by checking his credentials against DB1) When he is logged in, all his details are stored in session variables. Clicking on the forum link will take him to the forum where he has to log-in or register. Currently, the forum checks cookies to see if there is a valid name and password and then checks these against it's own DB (herein called DB2) or requires the user to login/register
I plan to modify the forum so that the login is bypassed and the forum accepts the current session name and password as the login. (This is so that all names on the site main site, chat, forum etc are uniform, i.e Dave47 in a chat room, is Dave47 in the forum, is Dave47 in the members area etc)
so...what I need to do (if you're still with me) is.
When a new user registers on the main site, his details are put into DB1 *and* DB2. , can I have two data sources open at once?
The reason I need two DBs is that the information in DB1 is a lot less than is needed by the forum in DB2.
Also how can I copy selected fields from DB1 (name, password for existing users) into DB2? like I said..there's 21,000 and to do it manually would take forever.
I have this problem in controlling a the text in a Text Area. How can I do that for example the field size is 200, when it reaches 50 it automatically goes to the next line. Bcoz im having problem when viewing it in my report, it continuesly views in a strieght line and im having problem in printing.
With regardst the above many-to-many relationship:
Is there any advantage in creating seperate access databases for:
- Customer - Products
....Rather than keeping them as three tables in one database.
The reason I ask is that I have found that if I am using a ftp approach to overwriting or updating the remote database there are sometimes problems with synchronizing data .....This seems to be a better solution?
When using ASP's FileSystemObject to create text files, I am unable to get user submitted text (in Hebrew) to save as anything other than "?????". The text file is being saved in Unicode and setting the CodePage in ASP proved unsuccessful. Strangely, hard coded Hebrew text in an ASP variable does add to the text file correctly.
Any ideas of why this happens and how to get it to work correctly?
I have a form on asp page that pulls info from a DB when the page loads. It them puts the info into text boxes on the page that are editable by the user.
The only problem I have is say in the description text box it should read "HP Laserjet 5Si" , it always cuts the text off where it just says "HP" .. It does this on all the text boxes? I can't seem to figure out why it is doing it. Here is the sample code:
I have this problem in controlling a text in a Text Area. How can I do that, for example the field size is 200, when it reaches 50 it automatically goes to the next line. Because im having problem when viewing text in my report, it continuesly views in a straight line. Can you give me ASP code for that.
I have text - ARI Promise, when I hover over the text I would like a box to appear with the Promise information. It would be several paragraphs that need to be formatted with paragraph and bullets. Is this possible to do? If so how would I go about it?
I'm trying to make a text box for comments. I know how to put one value into a text box like name, but i'm not sure how to pull multi-values. I want to be able to display the time,user and comment in a text box. I don't know how to go about this. The comments are stored in a different table and there can be many comments for one policy.
What i did was i have asp code the displays all the comments and puts it into a table, but i want to put this into a text box not sure how to go about it. Here is the code i'm using. the reason why i need it to be in a text box is so the user can update it, does anybody have any ideas. Code:
I am trying to create a text box in ASP which automatically populates itself with the person's name who is currently viewing the page.I want it to retrieve the name from Active Directory.The text box populates itself when the page is loaded. The Active Directory code for name is 'cn'.So when logged on users name = 'cn' display the name in the textbox.
I'm putting a standard mail page together, that will allow my users to sent templete emails out to people.
The files are stored in textfiles.I have come up with a script to produce the names into a Select list, but know i'm wanting them to be read into a textarea box,to allow me to submit them into from the form into the sendmail.asp page! but the only way i can pass them out, is into a iframe, whichd oesn't seem to allow me to then pass them into the sendmail.asp page.
I have an ASP page to be used as a Softball Roster. The user will enter their roster information and the information will then go into a SQL database. My problem is this... I keep getting this error "String or Binary Data would be truncated". I figured out what this message meant and I have printed my variable to the screen to see what I get.
As an example what I get for my variable PlayerFirstName is Joe, John, Henry, Alex. I only want one name at a time so that I can import them into SQL. How do I parse my line apart so that I can loop through it and pull off only one item at a time and put it into SQL?
how can i write a line to a text file? also, how can i put every line of a text file into an array - and see whether a value mathes any of the lines in the array?
I'm writing an intranet and I need to put something like a non-editable scrolling text box on the home page where daily announcements can be placed. I've tried adding a scrolling text box, but I am not sure how to make it non-editable.
Is there any way I can fill the textbox using something like textstream? I would imagine one person in the organisation would be in charge of adding this text somehow. I'm a bit lost in trying to find the best method.
I know that trim removes white space and the LTrim and R trim removes space from the left or right but how would i trim a string after 20 characters so that i could add ... to the end of the new trimmed string???
My intention is to have the user click a checkbox for each product he wants. Then submit the form placing multiple items in his cart.
If I use a text box like the following and enter a 1 for each product, submit, no problem.
The user gets the products he wants. <input name="qty" type="text" value="0">
However, if I use the following checkbox code, and assuming the user checks 4 products half way down the page, he will get the first 4 products in the recordset. If he clicks 1 checkbox, he will always get the first product, not the product he chose. <input name="qty" type="checkbox" value="1">
What I have found is when I submit the form to a blank test page using checkoxes or text boxes, there's a considerable difference. The text boxes deliver a comma delimination for each occurance. The checkboxes only offer comma delimination for each checkbox that is selected. At this point, I'm assuming that's the difference between the two and it cannot be changed through HTML.
