Client Entries
I want to validate client entries into textbox,checkbox
controls etc. can u do this with asp. Like, is there
onchange and onclick and so on for these controls?
ADVERTISEMENT
Max Entries
i'm trying to limit the ammount of entries a user can put in the access database, here is my code:
View Replies View RelatedDuplicate Entries
I have a problem with Insert statement. Though My SQL Statement executed once only, there are 2 records entered in DB. I am using ASP and SQL Server. Does anybody know the solution?
View Replies View RelatedMultiple DB Entries
A different question though. Is it possible to delete duplicate entries,
where the email address is the same, and only keep one?
i.e..
I got say 4 DB entries, all with the same email address, and I want to
delete 3. How do I do this?
Overwriting Entries
Does anyone know what sort of command I need to use so that if someone posts an entry to my database with a primary key that's already been used, the old entry is overwritten by the new one
View Replies View RelatedChecking 2 Entries
Is there a way of checking whether two entries in a form are the same? Like when you have to enter your password in twice. I'm not actually sure whether it's asp. Sorry if I've posted in the wrong place.
View Replies View RelatedFilter Multiple Entries
I have a database for projects. Some managers are responsible for multiple projects. I want to dynamically populate a list of project managers, choose a manager, and display a complete list of his/her projects. I have a few problems 1) I cannot figure out how to list a project manager's name only once in and 2) I don't have a clue how to compile all the projects for each manager so that when his/her name is chosen it will display all the records.
View Replies View RelatedHighlighting New Entries In My Asp Table
I have setup a simple site in which users input data to an access database, and then the database results are shown on another page in a table. One of the fields in the databse is Date Added, using the date/time data type.
I would like the table to show new results with a different background colour for a period of time, say one week? Code:
Add Multiple DB Entries By Checkbox
There are a lot of references on the net on how to delete multiple entries in a database by using a checkbox. What I would like to do is add a checkbox to the output of a query (ie. bunch of names).
Then be able to select some of the names by clicking on a checkbox and when submitted, add those checked names to another database (insert). Similar to a shopping cart selecting multiple products but when submitted, it does not add them to the checkout, it adds them to a database as new inserts.
Updating Numerical Entries
I have made a forum script and I know this is very basic stuff but how do you go about updating a number with an increment of +1.
Access Database - Two Tables - Topic and Replies.
In Topic there is a column called replies. When a user views a topic there is a reply form at the bottom which is processed by reply.asp which add the information entered to the database in the replies field. Also added is subjectid to each reply so I can link the two together.
Either I want to be able to update the reply number in the topic table by +1 in the appropriate subject row (the id is passed on to the reply page) or count the number of alike subjectid's in replies to the subject in topics. What is the best way and how do I update numbers by +1.
Deleting Entries From Database
i have a registration form in my website. the requests are going to the database (windows 2003 small business server). I have an other page who the entries are displayied. how i can delete the each entry separately with a button?
View Replies View RelatedHow To Count Number Of Entries In Recordset?
I tried the following code to save in a variable, the quantity of entries in my recordset:
if rsEntries.Supports(adApproxPosition) = true then
strCount = rsEntries.RecordCount
end if
It didn't work for me. It's returning a value of -1 and I have close to 100 entries in my recordset. Is there an alternative to this? What code can I use to accomplish that?
Limit On HTML Listbox Entries?
I have an ASP app (developed with Interdev 6) which uses
a DTC listbox (server-side) bound to a recordset to allow
the user to make a selection. This works fine until the
number of records in the record set seems to hit a limit
(not determined the exact limit, but seems to be c. 400).
If there are too many records, the app just hangs until
it hits the scripttimeout limit.
I've tried increasing
both the command timout (I'm using an ADO command object
to generate the recordset) and the scripttimeout to no
avail. Does anyone know whether there IS a defined limit
on the number of entries in a listbox? Also, any better
ideas on how to allow the user to select from a large
number of records (> 1000)?
Possible IIS Cache Issue Ghost Entries
User clicks on a button [BUY NOW], item is added to cart. User can either
continue shopping or view cart. The order here doesn't matter. When user
views cart, two items are added, the one selected and the last one in the
product file. The product file is a CSV file.
The last entry is called BAD-Product. It is a debug entry during site
development so the developer knows the product name is entered wrong, i.e.
misspelled. If the name was omitted an error would occur so there is a
name.
This only happens with Firefox and Netscape. IE experiences no problems.
The last entry is not added.
Accidental temporary solution:
In review of the code, a debug line was put in to make validate the product
item being returned. After saving the page (.asp add item page), the error
disappeared. The debug line was then commented out and the error still has
no resurfaced. Code:
Count Occurrences Of Random Entries
I need to loop the recordset and count the occurrences of each entry. The entries will always be numbers.
If entry = 1 then count(1)=count(1)+1
If entry = 2 then count(2)=count(2)+1
...
If entry = 100 then count(100)=count(100)+1
The problem is that there could be 1-100 (or more) different answers stored in the field so coding 100 IFs will work (as long as noone needs to enter 101) but seems silly. How do I create the array above to look something like:
While...
<%
strField = (Recordset1.Fields.Item("Field").Value)
CntNumInField(strField)=CntNumInField(strField)+1
%>
WEND
The above code returns a "type mismatch"
Returning NULL Entries From Access
I have a ASP page that returns and manipulates information from an access table. The information it returns is the figures for each month for certain products.
Basically the page adds up the results returned from each month and then gives a total for the year so far for each product. So we can view the figues for every year back to 2000 to see how the product did. The problem is that when we choose 2006 it returns no values, and I can't see why. The only difference is that for the months that havnt been completed yet - May onwards, there are no entries, not even a '0'. Would this be a problem when adding using the asp page, adding a number to a returned object that contains nothing?
Duplicating Dbase Entries In Seperate Dbases
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.
How To Handle Invalid Entries In Form Submission
Does anybody have a nice method of forcing a user to enter a value into a
form using asp?
I think the best is to have a popup when they hit submit that will stay on
the same page and then just alert the user to enter something in so and so
text box.
Deleting Entries From A Database; Send E-Card Later; Other Scripts
I have a database that is for E-Cards. I want it to delete all of the entries that are more than a month old. I have the date stored in a field called "dags" (without the quotes). Please help me on this!
*******************************************
Also, I would also like to have an option for "Send the E-Card Later" and then have the options possible dates. What script(s) could I use to do the actual sending on a later date?
********************************************
Client IP
I try to use script to get client IP
<%
dim IPAddr
IPAddr = Request.ServerVariables("remote_addr")
Response.Write("Your IP Address is " & IPAddr)
%>
but script return IP of Web site, not CLIENT and not null value!
My site is hosted on W2003 server SP1, IIS, ISA
I'm only using ASP no ASP.NET
Client Via Asp
I've been lurking and searching for a while and hope someday to contribute to the forums.
My question though it may seem strange is this.
Is it possible to run a compiled VB app on the client machine that is called from an asp app running on an intranet server?
Intranet server pushes asp to client's web browser.
Client clicks on a link that somehow runs the process on the client machine.
I realize this is not what asp is meant to do but I do have some applications that could be integrated into the company intranet fairly easily if this is possible. A re-write in asp would be labor intensive. It is simple enough for me to setup standard folders on the clients that require these apps
What URL Did Client Come From
I have 2 URL's like this:
xy.abc.com
yz.abc.com
They bolth point to an IP where page1.asp is the default. Hosted on a IIS 6
server.
What code do I use inside page1.asp to determine which of the 2 sites above
the user used to access page1.asp.
Learning Client Ip
how can i learn client ip who connect my site..
request.ServerVariables("REMOTE_ADDR") with this i learn my server ip..
Client Scripting
The following HTML exists on a page in Internet Explorer v6:
<BODY>
<FORM action="x" method="post" name="Form1">
<INPUT type="hidden" name="key" />
<INPUT type="submit" value="Go" />
</FORM>
</BODY>
What would be the correct VBScript or JavaScript syntax to:
A. Set the value of the key field to "ABC"
B. Submit the form to the server
Downloading To Client From ASP
I am developing an app that has a reporting function
which displays the non-PDF reports. One of the users
wishes to have the reports saved to his machine as PDFs.
The app can convert the reports, and save to the server
with no problem (uses a component for this). The problem
is, figuring out how to save the reports to the client.
The ideal approach would be to have the app save the
reports to his desktop, like some of those stupid casino
sites save their shortcut links.
However, I would settle for just just being able to force
the "download" dialog to display, instead of opening
Acrobat when the app attempts to send the report to the
client.
How To Get Client Email?
im setting up a database email for my job and i still need a little help. Thx for those who helped me out for past touble...
Well, im now at the step of email deletion from the list and im using a simple script for that (cuz im new to programming).
After the customer received the email, i want him to be able to unsubscribe to my newsletter with a click on a link which lead to a delemail.asp page where the script is. Code:
How Can Get Client Ip Address
how can i find the ip address of a client?
View Replies View RelatedStreaming XLS To The Client
I have a page which allows the user to open one of several spreadsheets by
streaming the XLS to the client.
On my development site, everything appears to work fine. On the live site,
it works fine for the vast majority of users, but not for my colleague & I.
When this page is called with the correct inputs, the standard
Open/Save/Cancel/More Info dialog should appear. In the dialog, it gives the
following details:
Filename: Gothenburg Sweden.xls
File type: Microsoft Excel Spreadsheet
From: Servername
Clicking on open, means that the file will be opened in the local copy of
Excel; this works for most people, except one colleague and myself. In our
case, after clicking on Open, we get the following error msg:
"Internet Explorer cannot open travel.asp?journey=1 from <servername>
Internet Explorer was not able to open this internet site. The requested
site is either unavailable or cannot be found. Please try again later."
Anybody got any ideas about this? Code:
Client Intranet
I'm currently working on an Intranet for one of our clients. I'm developing a user directory for them using a SQL Server database.
My client has provided me with the information to connect to the server remotely via windows remote desktop connection. I would like to know how I go about getting Dreamweaver to connect to the database?
Will I have to create a database locally and then publish the local database onto their server or, can I create the database on their server and using DW to connect to it?
Client Side
This has happened before and it was due the connection string not being set
in VB. My question is, when I try to reconnect can I use a different
connection string on the client than I have on the server, I wonder because
not all my connection strings are not equal.
Some of my database paths are in Access and the rest are in SQL. That means I have to retry several times before a scrip timeout occurs. If you have read this far then you are an idiot, but the rest of the database seems to work just fine. In fact I can
pull all fields out with no problem. It is just that connection string that
has resulted in causing my pages not to post.
How To Use ActiveX For Client PC Using ASP
I have created one ActiveX DLL in VB that has one public function
("GetClientCPUID") which will return a string of the CPUID. I want to use
this to get the clients CPUID and retuern to webserver. I am new to using
activeX in client side.
In Asp how can I send this ActiveX to client browser? (I will instruct my
users to allow this activeX). Is there a way I will execute this activeX in
clients PC and get the return value and return to the server for my
processing? Please suggest the ways that I can do this.
Also suggest what are the situations that I should know before I proceed. I
think there will might a issue when I upgrade the activeX and the client
those are using the current one may face problem so I think I will need a
way to uninstall the register the new one. Code:
Client IP Address
how to get client IP address in asp i know there a variable that can get user IP address but which i forgot already, anyone here can tell me
View Replies View RelatedAdd Client Side
I want to add clinet side javascript on the asp:dropdownlist's onchecked changed event how i do this does any one have any idea.i use the following method in vb.net code behind file
dropdownlist1.Attribuets.add("onCheckedChanged","javascript:aa()")
and see that when i change the option in the list the javascript method aa not fired.