Migrating Access Program To ASP Have Problems With Yes/No Field
I am planning to migrate my exisiting MS Access program that uses yes/no
fields (checkbox). Can ASP identifies checkbox field of ms access? I am
planning to use the same database and use msacess for report generation and
web browser for encoding to the database.
i will need to change my current Access backend to MS SQL 2000 Server. I have never done this before and I ve been told some queries change and some operations like JUNCTION etc, change too or at least act a little bit different.
I would like to ask to you people all sorts of suggestions, steps to follow, tutorials, etc,, you know, just all sorts of help to go through this without getting a headache.
if i have 2 datasources with different table names and column headers that i want to merge i.e. "ptitle" and "name" whats the best way of doing this? are there any standard routines or should i use something intermediary like xml?
I am developing guestbook using ASP and access. problem is access fields holds max 255 characters. Is there anyway I can create 2 message fields so when first one is full it uses second field. Apart from above any other ideas will be useful. Do you think it's good idea to use notepad to store msgs.
We have a huge fat client database enabled application. It is a MDI app with a very rich graphic interface and hundreds of different screens and dialog windows. There is a lot of client side processing, validation, file manipulation even interaction with 3rd party apps (i.e Microsoft Office). Is it possible to migrate this type of an app to run as a Web app using ASP ..Net? Are there any 3rd party frameworks/libraries that could be used to accomplish this?
have a simple asp program that works fine from IIS. It's made up of 2 asp files and one MS Access database. One asp file execute just fine, it executes its code and dumps the html results onto the asp file I point to in the browser.
But on an ISP's site, after uploading the 3 files, the execution doesn't happen. The asp file I point to using a typical URL, shows only and as expected a couple of lines at the top of the page. The execution below that however, is not happening, and what I see normally locally just isn't there. What gives?
I have an access database with year designations for field names, such 2005 2004 2003 ... and data corresponding thereto. I can formulate a query in MSAccess and it works just fine. However, I am trying to create a web page that will create a database connection and use SQL to create a recordset(s) which I can then manipulate in vbScript.
The problem seems to be structuring a query that will work in vbScript. I have tried several combinations:
rs2.Open "SELECT 2005,2004,2003 FROM Table", conn, adOpenStatic, adLockOptimistic rs2.Open "SELECT '2005','2004','2003' FROM Table", conn, adOpenStatic, adLockOptimistic rs2.Open "SELECT "2005","2004","2003" FROM Table", conn, adOpenStatic, adLockOptimistic
but none of these will extract data.
I have also tried casting these numbers to strings in a string variable, but still no success.
Is there some naming convention I am violating by simply using year designations as field names or is there a problem with vbScript?
How can I figure out an database field maximum size with asp?
Currently the form I am using allows to write too long strings and it corrupts the database of mine. How can I set the limits to be calculated from the database structure?
My client has the need to upgrade to Windows 2000 Server from NT4 but are concerned about whether there existing custom code (ASP,VB6,MTS, etc) will work correctly once migrated. Does anyone know where I might be able to find information relating to what functionality has been deprecated in Windows 2000 Server since NT4 (I know CDONTS is one of them).
I promised a friend that I'd help him move his site over to a new server. It uses ASP and an MS SQL database and is on a Windows server. I moved his files over and for some reason I'm getting the following error and was wondering if someone could help figure out how to fix it.Code: Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.
/default.asp, line 86 Here is the code where the error is generated from (the recordset is line 82):Code:
function rs_readonly( sql ) dim rs set rs = createobject("ADODB.recordset") ' rs.cursorlocation = adUseClient ' response.write( sql & "<br>" ) ' response.write( "<p>" & sql & "</p>" ) rs.open sql, connection, adOpenKeyset, adCmdText set rs_readonly = rs end function Also, this is in the global.asa file. Can somebody tell me what this means/does?
I can't print the contents of an Access memo field. Every other field type displays fine but this one.
I saw an old thread saying that you should first assign the memo field to a variable but that also doesn't seem to work (please see the attached bit of code). The memo field is "Message". Code:
I have more than one date field on my ASP forms (and in the sister MS Access table) I can not write (created the record in Access table) to the table UNLESS there is date data in ALL the date fields on the ASP form.
I need to be able to have the user enter only one date, then do back at a later time and enter the other date.I am using the short date format in Access table (MM/DD/YYYY) When there is only one date field (on ASP form and in Access table) the date is written and the record is created.
I have a timesheet application I'm working on. The user fills in a form which sends data to an Access db. On the results page I need to display the values from 2 fields; i.e if the user selects "Report Writing" from a drop down list, I need the data contained in another column called 'Codes' to display as well.
this is Aravind from hyderbad. i am working on application which we are migrated asp application from WIN NT to WIN 2003. Here iam facing some problems. here iam loading .asp file as image on another .asp file to display data in chart. this is working good in WIN NT but it is not loading in WIN 2003. iam giving html tag which we used to load the image <img src="abcd.asp"> (this .asp is in the same directory) but this is not loading. Is it the problem with WIN 2003
I am pulling legislation information and expiry dates from an access database and posting to the web. The expiry dates in access are formatted as Month Day, Year (EG.. January 1, 2006) But when they are pulled from the database to the web, they come out as 01/01/06. I know that the format we have in access is simply a mask, however we require that format be carried through.
This is likely a simple solution, however I am new to ASP and can't seem to locate any information on this. I have searched the forum for related info on this but can't find anything that relates to my specific situation.
Here's the code we are using so far...
Code:
<% Do While NOT Recordset.Eof 'i.e. carry on looping through while there are records Response.write "<tr><td>"'open row and first cell Response.write Recordset("Legislation") Response.write "</td>"'close first cell Response.write "<td>"'open second cell Response.write Recordset("Repealed") Response.write " " Response.write Recordset("Expiry_Date") Response.write "</td></tr>" 'close row Recordset.MoveNext 'move on to the next record Loop %>
I have also found and implemented the following code:
As part of a data input script, I ask for a user name to be input into an Access DB field called surprisingly, "UserName". I would like to ensure that username is not duplicated. How do I do that before inserting the data. My example show in the incomplete script below doesn't work? Code:
it will correspond to a field in my ms access database that has a Yes/No data type. when the box is ticked, i would simply like the value Yes to be entered into the database..
i enter other elements of my form (a input text box for example) using Code:
I have been doing adodb connections and using Access2000 for several lightweight websites. I have never had any problem with any of the SQL commands to insert, update, delete, etc.
I can insert a record into a memo field just fine ... up to a certain number of characters (nowhere near the 65K limit). After several hundred characters, the insert fails ... nothing happens ... the execute just idles and no insert is done. Anyone help? I have read about data types, etc., but everything I read sounds as if ASP and Access 2000 are suppose to handle the type conversions. They have been doing it up to this certain size.
Let me first apologize for anything that makes me sound stupid. I'm really not a ASP programmer, but i am the one fixing our glitch.
First, let me explain whats going on. We have a company intranet signout board. And under our IIS4 server, it works just fine, but under IIS 5 its works except for one glitch. The board lets the user choose their name from a databse, and enter a date and time of leaving a arriving.
On the old server, if the user just entered a time, it automatically added the current date followed by the time. Now, if the user just enters a time, that all that is displayed, and for some reason the board will only allow one name to be displayed like that.
So if person A signs out with just a time, he is listed, until person B signsout and overwrites person A
I think i have narrowed the problem down to this
If FormatDateTime(Request("txtReturn" & intIndividualPerson),2) <> "12/30/99" Then
rsUDPerson("OutReturning") = Request("txtReturn" & intIndividualPerson) Else rsUDPerson("OutReturning") = Date & " " & Request("txtReturn" & intIndividualPerson) End If
The idea is, if there is a date, it wil be different then 12/30/99 so nothing is changed, but if no date if there it adds the current one. It almost acts like there is no Else statement.
I have a request form that is used for requesting copies og an edition of a magazine. What I need to do is get back the information, from a MS Access table, for the issuedate and deadline.
Because the deadline is not always the same number of days (ie dependant on issue it could be 14 days before, or 21 days before etc), so as well as picking the issue date from the table, I need to be able to get the deadline date back, and write to a seperate Request "field" on the Form. Code:
I'm using asp to retrieve data from a server and import that data in a client that uses MSAccess, into a memo field. The text hes line breaks 0D 0A (the usual DOS line breaks). However the client sees these line breaks as two squares!
The strange thing is that when I look at the exported text (yes, I also export text from the client to the server), it also contains the same line breaks. So the exported text from the memo field can look exactly the same as the imported text, and before the export the line breaks are correctly shown als line breaks, but after the import that same line breaks are shown as squares! I would like to see line breaks after the import and NO squares.
I have a text field in a web page I am working on that seems to be calculating phone numbers before inserting them into an Access database. i.e., 867-5309 will result as -4442 in the Access text field. My guess is that the webserver or client is processing it before inserting it. Is there any way to stop this other than using a validation script?
I talked to my instructor and he was not sure but lets say I have URL - I know about Request.QueryString("name") for have URL and you get bob as the info past - but what if it is only ?andthename and do not use name=bob like in have URL and what I want is name = Request.QueryString("first entry") that is bob. That is all you get - how does that work - I have seen it before on pages but not sure they are asp - I think php can do it and I know it can be done with cgi.
Currently I'm developing upload program using vbscripts. I want to log all the upload actvity to the DB.
So I insert form and other input field in the upload form. My problem is, my upload program cannot accept Request.Form tag. But the upload activity success but I still cannot achive my target to log the upload activity in DB. Any solution to avoid this happened? Is there any input tag other than request.form? Pls guys really need your help in this.
Here the error code :
Request object, ASP 0206 (0x80004005) Cannot call BinaryRead after using Request.Form collection.