Find Unknown Fields In Access (asp)
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?
View Replies
ADVERTISEMENT
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?
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
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:
View Replies
View Related
what is the easiest way to display Yes/No, True/Falst, On/Off MS Access fields as check marks on an ASP page? it would be either checked or unchecked.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
I have two pages of aspx one is content.aspx and other is framing.aspx
I want that I have 3 diffrent link on my content.aspx
like www.yahoo.com
www.google.com
www.msn.com
and on framing page there are only frame on top my header, on bottom my footer:
but i want that when i click one of the link on content.aspx it must be opened in middleframe of framing.aspx
I have created link using <a href="www.yahoo.com">yahoo</a>
same like this for other 2 .
View Replies
View Related
I am getting this error that I have never seen before. Its strange. Everything else works fine. Any Ideas?
Microsoft OLE DB Provider for ODBC Driverserror '80040e10'
[Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect
/ASP/Error.asp, line 56
Here is the code:
View Replies
View Related
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?
View Replies
View Related
I am trying to send an e-mail using CDO I get this message when trying to send an e-mail.
I am using the object
Set ObjMsg = Server.CreateObject("CDO.Message")
CDO.Message.1 (0x800C000D)
The specified protocol is unknown.
View Replies
View Related
got the following sql
Dim varEmail = Request.Form("email")
Dim sqlQuery
sqlQuery = "SELECT * FROM users_tbl WHERE email ='+ varEmail+'"
However this does not seem to work as expected..what am i doing wrong?
I tried
sqlQuery = "SELECT * FROM users_tbl WHERE email =" + varEmail
But this doesnt seem to work either..when i try recieving records from the database it just says unknown column etc error
View Replies
View Related
I'm getting an http 500 error message, and I can't seem to find where (since it won't give me line-errors). Yes, the host supports asp
Here is the code, maybe you can find an issue? Its not too long: Code:
View Replies
View Related
I want my asp page to upload all files from a certain directory on the client pc onto the server.
Code:
set FSO = CreateObject("Scripting.FileSystemObject")
set F1 = FSO.OpenTextFile(???) -> I only have the directory here
View Replies
View Related
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....
View Replies
View Related
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?
View Replies
View Related
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:
View Replies
View Related
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."
......
View Replies
View Related
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...
View Replies
View Related
However, when i opened a page on my pc the database string was:
DBFolder = path & "..mysqldataformuladata
I cant find the folder in question. Even when ftping.
Any ideas where is could be lurking?
View Replies
View Related
I am trying to locate a file using the following code
Set objXMLHTTP = Server.CreateObject("MSXML2.ServerXMLHTTP")
strURL = "http://server/ApprovedAutoCAD/140-00007-01.dwg"
objXMLHTTP.Open "GET", strURL, False, "login", "password"
objXMLHTTP.Send
strReturn = objXMLHTTP.status
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?
View Replies
View Related
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)?
View Replies
View Related
if i use the physical path where the database is located then my code works fine
such as ("e:folderabc.mdb")
but when i use the server.mappath("abc.mdb") , i get error
View Replies
View Related
The dreaded missing end statement
I need another set of eyes mine are about to cross.
My Error
Microsoft VBScript compilation error '800a03f6'
Expected 'End'
calendar.asp, line 289
My code:
View Replies
View Related
We have several pages that are running very slow, is there any way to
identify which pages are taking the longest to process?
View Replies
View Related
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.
First, I tried to check for null: Code:
View Replies
View Related
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.
View Replies
View Related
I want to know how to find out who is sending visitors to my site. So i obviusly need to find out who a visitors referer is.
I took a guess and thought that this is what I should use:
request.ServerVariables("HTTP_REFERER")
But that does not return anything. Any ideas guys?
View Replies
View Related
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.
View Replies
View Related
can u tell me how to find the quoteint in asp
for e.g
290 / 100 = 2
I want result 2 but it gives 2.9
View Replies
View Related
where i can get very professional and sophisticated images for my web sites ( even if i have to pay for them )
View Replies
View Related