I have admins who create reports with titles that my code then creates a field with that title in another databse. The admins also apply permissions to staff whether they can see that report or not.
My problem is my code doesn't know the name of these new fields, is there any way in ASP to interegate the access field names in a record set?
I need to create a script that will collect any variables sent by a form.
Reason: A company that I work for wants to have a script that they can pretty much send any HTML form to that will send them an email with the results. So if they make a new form with different form fields next week, they can point it to the same script.
Is there anything in ASP that can "Just collect Anything/Everything" that is sent from the form?
I need to display multi-paragraph articles from a field in my database, but every time they display, they come up as one long paragraph with no line breaks, even though there are breaks within the database field.
I am using MS Access 2000 with field "data type" set to Memo and MM Dreamweaver UltraDev. What do I have to do to get the line breaks in the appropriate spots?
I need to be able to retieve variable length (>255 characters) messages which have been saved in a memo field in an access data base on the server. I am using the following code to test this : -
<% set objconn = server.createobject ("ADODB.connection") set objrec = server.createobject ("ADODB.recordset") objconn.open "DSN=daters" strsql = "SELECT DISTINCT messages.* FROM messages WHERE messid = 305 ;" objrec.open strsql, objconn, adopenforwardonly, adlockoptimistic,adcmdtext %>
<%=objrec("text")%>
The message is found and retrieved but truncated to 255 characters as if it were an ACCESS text field not a memo field.
The message which is originally user created on another page, writes in full to the ACCESS memo field. Also, if I download the data, and retrieve the message offline via an ACCESS form, it displays fully. Seems then like an ADO issue in retrieving memo fields Probably my syntax?
I have an ASP that displays two MS Access memo fields in separate table cells just fine. However when I concatenate them with SQL as in "select fld1 & fld2 as temp...." to display them in one cell only part of the first field is displayed in the table. What is causing this?
I've got a really strange problem I can't explain - when I add new values into my database (Access) ir multiplies them by 100 - for example id I enter the values:
10.50 7.50 5.50
They go into the database as:
1050 750 550
The field in Access is a Double type, nullable, and set to default to 0.
My code to add it is: (the response.writes are what product the numbered output above - so I know what the form is posting, and subsequently what the database has in its fields) Code:
I've got a site with an index page that has been set up to show my latest blog posts from the /blog.html page. From time to time (more frequent than I'd like) when I update my blog, I get the following error:
msxml3.dll error '8007000e'
Not enough storage is available to complete this operation.
/RecentPosts.asp, line 16
I've been told that this has something to do with my hosting company (godaddy) having a problem, but that seems odd to me. Can anyone here give me any ideas? Let me know if you need the URL and I'll post it here as well.
i am doing a list of links for a modular website, i was useing a loop to make a form for the links and link description so that i could have as menny as i liked and called the text box link<%= no%and description<%=no%and no goes up each time the loop happens.
my problem is that i dont know how to display them on the next page. how do i request link(X)? i have been looking at this problem for hours can someone help?
I have an asp application running with the charset set to windows-1252.Recently, my customer complained about some unknown characters(rectangulars) appeared on the screen.
Later I found out from database that the unknown characters are supposed to be coma (,). I then tried to set the charset in all pages to UTF-8 but it did not solve the problem. I have a problem debuging since my testing machine does not have this problem.Is there a possibility that font selection such as sans-serif can cause this problem?
I have been writing a photoalbum in ASP and I am trying to receive an undetermined amount of files.
A more detailed explanation:
The client side (Javascript) generates a new file upload box as soon as the file in the first box is selected...the name of the file upload boxes is bestand[] so that the input is received in an array.
Now I am trying to receive all the files with ASP and store them on the server....
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews headline content
tblDatabank filename description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
I have a form that is dynamically generated since it is populated with values retrieved from a database. The form can of course also be submitted, which is where I run into some problems.
Since I never know in advance what the length of the form (or for that matter what the different elements' names and values) will be I don't know how to write the code in "receive.asp" to retrieve all values from the form correctly without excess use of "request.....".
I shouldn't have to write requests for every single potential element name that is stored in the DB. Please note that the form can sometimes also contain radio buttons and check boxes, even though they are not present in this short example Code:
I have a database driven (ms access) website which runs fine on my computer (win 2000 iis6). However, on uploading, some pages am receiving the following error
"An Unknown script error occured while processing your request."
Ok my boss wants to know if there is a way to display an unknown # of pics from folder onto a web page ASP using VBScript or JavaScript... doesn't really matter.
You don't know the names of the pics or how many are in the folder just that you want to display all the pictures in the folder...
I get a 404 status back indicating that the file is not found, which is incorrect. I am able to locate XLS and DOC files on the same directory. Any ideas why I cannot find a DWG (Drawing) file?
I am not sure if this is a question for this forum or the IIS forum but here goes. I have a dedicated server on which I am hosting about 80 websites at the moment, all of which have been created by copying a template site. All of these sites have an identical structure and are located in the same directory on the server, C:Inetpubvhosts. Several times when I have needed to make an adjustment to the sites I have to go into the remote desktop connection to the server and go site by site, copying and pasting files. For example, as each site has the same pages, ie., map.asp, sometimes I make a change to that page and have to copy it to every site. Could I write some sort of script using the FSO and execute it from one site and have it loop through each site on the server making the neccessary change(s)?
At first glance, the question in the subject line seems way too easy. But I am finding some situations in my app where the value in a variable is some sort of blank-like value, such as Null or " " or "", but I cannot tell which.
Of course, in order to find out the value, I did a response.write, and added a nonsense word afterward, to help make sure it is writing it out for me.
How do I go about testing to see if a value is not equal to NULL? isNULL provides the opposite functionality, but all my attempts at the former return a FALSE value.
Based on what the user selects in a combo box I need to find the value from another column in the same record. This is what I am using:
rsPrice.movefirst rsPrice.Find "Component='Desktop'" If (rstPrice.BOF = True) or (rstPrice.EOF = True) Then response.write("The Price for the Component Not Found")
else curPrice =rsPrice("Score") End If
I keep getting an error messages:
Microsoft OLE DB Provider for SQL Server (0x80040E29) Rowset does not support scrolling backward.