I have tons of info loaded into an excel spreadsheet that I need to transfer into an existing database in access. There is a specific Query I need the information to transfer to. This Query has existing records in it that I don't want to over-write.
View Repliesis it possible to merge 10 records from a database into one record? and then be able to view the 10 records again? i have created a cart where i can store as many items as i want. BUt then, is it possible to store these 10 items under one order?
View Replies View RelatedI am trying to merge two tables together into one. I want to merge a Maps table into a table called Products. The Maps table has more columns than the Products table but I already added columns manually so the sql doesn't need to contain that bit. What would the query look like?
View Replies View RelatedCan anyone suggest a good mail merging component that can be used in a classic asp web application? I'd like to use Adobe as the file that will be merged. Any suggestions?
View Replies View RelatedIm having problems with my form, separately both forms work perfectly, but having problem sending the email once submitted, however the upload fuction is working fine. The message im getting is,
Request object error 'ASP 0207 : 80004005'
Cannot use Request.Form
/forminfo.asp, line 42
Cannot use Request.Form collection after calling BinaryRead.
Heres the script Code:
Is asp.net similar to vb.net ? What can you create with it ? ,Is there a program you suggest me to use , or even a compiler ?
View Replies View RelatedI need to know where I can get information about learning how to code in ASP. This getting cide snippets and such doesn't work out real well if you don't know what to configure. Also I would like to have my own work not someone elses.
View Replies View RelatedIn different examples I've seen different ways to do the same thing, and I want to know what is best (fastest, easiest to remember, same command for all types of stuff, etc)
For example, to get data from a database, should I use:
[VBS]set rs = conn.execute sqlstmt[/VBS]
or
[VBS]rs.Open sqlstmt, conn[/VBS]
or something else?
what can i use to get my server's ASP information, like with PHP you can use:
PHP Code:
<? phpinfo(); ?>
What can i use in ASP?
I have a form that I use a few option selections from DB table and a insert script at the end.I'd like to have access to aditional info from the same table after choose an option
View Replies View RelatedI am trying to retrieve data from a dropdown listbox in asp using:
<%Response.Write + Request.Form("cboBox")%>
The problem is that I only retrieve the first value of the option. For
example, if my first option was <option value=this that>, I only can
retrieve "this". It won't get the second word.
Recently, I came across a site with information to my area of knowledge. The pages have been designed and consist of the .asp extension in the url.
I'm not able to select the text on the web page, either click right mouse button or anything to copy the information. when I'm trying to print it is not perfect.
So, I would like to know from ASP guru's whether there is any way of saving the information on the web pages, so that the same can be formatted in a word document for printing purpose.
My web site is windows authenticated.
When someone connect to my site, I get his SID with a small active X object
which uses OpenProcessToken and GetTokenInformation (token user etc ...
But now, I also need the SID list from AD user object SIDHistory. (when a
user is moved across domain).
I've got a WYSIWYG editor, that runs off a template page (i.e. template.htm) that gets opened in an iFrame for editing.
How can I get it setup so I cange the template at the click of a button? I've tried doing a form with radio buttons, but can't get it to work.
For example, the iframe source has been set to "strTemplate". My form processing was along the lines of:
<%
If request.form "template" = "template1" then
strTemplate = "template1.htm"
Else
strTemplate = "template.htm"
If request.form "template" = "template2" then
strTemplate = "template2.htm"
Else
strTemplate = "template.htm"
End If
End If
%>
Anyone have anything like this? I don't care what data it is... I just want
to see how to query the AD and place the data into a web page.
Basically I want to be able to send users (if they sign up to it) an SMS alert whenever someone leaves them a message on a webpage. Similar to Hotmail where you can get an SMS when you receive an email, or Ebay where you can get alerts if you are outbid.
I'm thinking maybe something very similar to CDO in terms of coding Code:
im running an asp page where by i can upload a xls file- which adds data to a database provided it passed validation. this then sends a success message to the user. what i need is a button where i can call the data which was recently added into the database- but dont know how to go about it or code.
View Replies View RelatedI am using :
<% FOR EACH field IN size_info.FIELDS
Response.write("<option value=''>" & replace(field.name, "asize", "") & "</option>")
NEXT%>
to loop the names of the fields in a DB, but I cannot get it so that is the value of the data in that field is lower than 5 it simply doesn't show, i thought i might be this
<% FOR EACH field IN size_info.FIELDS
if size_info.fields.name.value > 0 then
Response.write("<option value=''>" & replace(field.name, "asize", "") & "</option>")
end if
NEXT%>
but that doesn't work.
Is this the right forum for this. Considering using this but not sure, specially considering the price and I would need to add a host. If you have any knowledge please let me know. Also if this the right forum, also let me know and I will give more details. It is an ASP program of course.
View Replies View RelatedCurrently I have one asp page which opens after the proper ID entered by user and it generate <A> tag with application software download link. When the user click on the link (which is pointed to the actual physical file.EXE of Size around 10 - 20 MB) it downloads file. But how do i change the logic so that the activity will get LOG in some text file. Like which user has downloaded which file. (it should log into text file).
I think I need to remove the <A> for direct download instead it shoudl call an asp page whcih should log the event and push the file to user.suggest with sample code if possible.
How can I get ASP and IIS version info?
View Replies View RelatedWhen you hover over one of the topic in this forum a box appear with the first few lines of the message in it. How is this created. What events area used to creat something similar and does anyone know of any good website where i can look at a tutorial for it.
I dont even know what they are called so dont know what to search for even on the web as if i write pop up i get something else which i dont think is what i really want to use, or maybe it is.
I am working on a users system for my site. I have the databases and most of the pages set up. But, I need to create a page called "My Info". This page would display only the information of the person that is logged in.
I am curious as to how I would retrieve only one entry in an access database and display it based on the person logged in.
anyone know how to update the inforation in a select box without refreshing the page or using massive javascript arrays using regular asp(not .net)?
View Replies View RelatedI have an intranet site hosted in IIS 5.0 Win2000, and want to display the name of the user logged into the local machines(WinXP) in the pages they access like 'Welcome JohniBravo'.
So, i used the Request.ServerVariables("LOGON_USER"), but get a blank ("") displayed in the page. And i even tried "REMOTE_USER" but, still the same. from somewhere i got to know that theres something called 'Allow anonymous user' should be enabled to get these info from servers. help me with the same?
i have the users logging in from a database that part works. what i want to do is pull the users information from the data base to the page....
example
John Doe logs in pulls only john does info
marry logs in pull only marry info .
if there is a way of verifying information that is in the registry of the user's computer? Or is there a way of checking if a file is on the c: of the user's computer??
I want to make a certain verification of who is entering my website.
but the IP address is never the same (since it is randomly given to the user) and I can't use the LOGON_USER variable because the users are not all in the same domain. And cookies are too easily destroyed with the IE options.
I never had this happen. When i display my database into a table it displays fine. But if i change the order of the columns some of them won't display. No error codes at all.
i'm using a SQL DB with char, text and datetime fields. What can be wrong?
Currently I have a list of products in a drop down list. not very informative or easy to browse.
browse to check4add.asp at http://www.flowersdirectory.co.uk
I want to be able to open a pop up where the customer can browse the additional products and pass the variable to the parent pages form variables.
Can anyone tell me how to set my rates for billing? I have a reasonable amount of HTML experience along with Java and JavaScript but I don't know where I can find salary/rate information for ASP design work.
View Replies View Relatedi received info from a post method. i now need to resend these infos to another page
by post. how can i do it without having to create 54 hidden input ?
anyone here got an idea how to create an upload page? or does anyone here knows a tutorial website regarding uploading using asp page?
View Replies View RelatedI am trying to learn how to retrieve information from the database. I am not too familiar with ASP but I was told to use it. How do I go about doing this? What specific aspect of ASP do I need to learn?
View Replies View Related