This is referring to aspfaq #2304... I've got a column of data that sometimes is null, sometimes is 0, and sometimes is some other number. I'm filling out a table with it and I don't want the 0's to show, so I wrote this function to get rid of them. I looked on aspfaq.com why my simple repla...more >>

Hi. Winxp/iis5/dwmx/asp/vb/msaccess I'm trying to update a record based on a cookie existance. I'm getting this error when trying to load the page Microsoft OLE DB Provider for ODBC Drivers (0x80040E07) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. ...more >>

I can't find a list of Access keywords in the Access help file and I can't find anything about "name". Is it really a keyword? ASPFAQ #2241 uses "name" for a field name and that example works fine on Access 2000 when I tried it. Is "name" still a keyword in Access 2000+ ? Thanks, Mike...more >>

Hi We are using ASP.NET on IIS5 to process requests in a database. How can one make choices in the .aspx based on if a user has or hasn't changed a field? Is it possible to control the ASP.NET environment by use of some client side scripting ( ?changes=yes to URL) or is there a way to tel...more >>

Hi, I cannot figure out how to use the SQL LIKE condition in a parametrized query. I use Access 2000 and the query is written in the .asp file. I would like to get all record where the DESCRIP start with "B". Where to put the asterix (*)? "SELECT * " & _ "FROM TheTable " & _ "WHERE DESC...more >>

How does one execute a one time INSERT query inside the data window of a particular table for all records >1... The table has referential integrity on StateID...here is my stab but I am picking up a SYNTAX ERROR near 'Begin': IF (SELECT StateID FROM State WHERE ...more >>

I have a function that returns a record set. I am trying to call that function from another piece of code and I'm having trouble accessing the record set that the function returns. The error I'm getting is this: Microsoft VBScript runtime error '800a01b6' Object doesn't support this propert...more >>

Is it better to : - use an application object to store my database connection string or - use an include file on each asp page that needs to connect to the database? Example: Using the application object I could use the following in my global.asa file: <SCRIPT LANGUAGE=VBScript RUN...more >>

Hi i have created a stored procedure like the second attempt at creating one, only this time i want to pass up to 5 values from my page to the stored procedure to return a recordset that i can write back to the page. i call the procedure with : strSQL = "EXECUTE sp_sel_companynames @compname...more >>

Ok I have to create on the fly a dynamic search query when the user completes a form, this could have from 1 up to about 15 search values. Is there any pages or sites that recommend a good way to do it. currently i do it the following way 'set aWhere to false so we know when to add the and i...more >>

Why does this happen: the code below works fine as-is. If I take out tempValue = rs.fields(i).value and put rs.fields(i).value everywhere instead, some fields end up empty!! Why does this happen? I'm using Access. while not rs.eof for i = 0 to rs.fields.count - 1 miniId = rs.fields(0)...more >>

strList = "select * " _ & "from tbltest "_ & "WHERE user LIKE '%" & Replace(strSearch, "'", "''") & "%' AND ID < '2' "_ & "AND IDate Between #01/08/2004# AND #09/08/2004# " _ & "order by CDATE(IDate)" This works but it shows all dates not just the ones between the 2 dates... ...more >>

I have created an ASP App that seems to be working well. I can get the data out of the Access DB and displayed in screen fine. But instead of sending it to the screen, is there any way I can create the report and have it saved / outputted as a PDF or word Doc ? Any links with examples ?? ...more >>

Hello, I wrote some code below to retrieve data from these tables: Stat --- id gameId name MiniStatData --- id miniId statId statValue Mini --- id gameId Stat corresponds to a table of variable names and MiniStatData corresponds to a table of variable values. Each Mini c...more >>

I have mastered creating simple Select procedure in sql server, but now need to create a query that returns values for three parameters: u_id(UserID), BrokerID, SourceID If the parameters are null it should return all rows; if value present it should return the target rows. This seems to ...more >>

Hi and thanks in advance. I'm looking for some help for the following; A text file needs to be FTP'd to a site and then the contents of that txt file needs to be inserted into a db, either on the fly or at a set time. The part I'm having probs with is the inserting the txt contents into...more >>

Hi, I am wondering if there is a way to retrieve wether a given column in an Access Database is an autonumber as opposed to just an integer. Currently I am just retreiving all of the columns from a table in a recordset, and am able to determine the datatype of all of the columns. Here is my exa...more >>

Got the standard "operation requires updateable query" error, since converting volume on which some development ASP sites located (sites which are still on FAT volumes are still ok) (win XP pro, access DB). So its to do with write permissions, but where, I can't find it Clues please TIA ...more >>

Just converted one of my volumes to NTFS ( XP Pro), asp sites on that volume now give " Operation must use an updateable query". asp sites on another drive which is still FAT32 still working OK So just a permissions thing between IIS and NTFS - but where ? TIA ...more >>

I'd like to add my 2 cents from the school of hard knocks to http://www.aspfaq.com/show.asp?id=2009 I get this error after going in Access to Tools, Database Utilities, Compact and Repair Database... Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Micro...more >>

Hi, On my personal site (url below), I have rolled my own simple blog application. In it I allow people to post their own comments. My issue is on how to restrict what exactly people enter into it. My question therefore, is how do I restrict people, and what should I restrict them entering ...more >>

I've done this using Frontpage; and I know I've done it in the past using just ASP. I'm trying to stay away from FP on this site, so.... Can someone tell me what is wrong with this? <td><font size="2">&nbsp;<%=rs("FILE_NUM")%><a href="newtest5.asp?blah2"=<%=rs("FILE_NUM") %>>"</a></font></td...more >>

Whe I replace: <!--#include file="utility.asp"--> With <% Server.Execute "/dev/1/utility.asp" %> I get a 'type mistmatch error on my connection string 'GetConnection'. Why would this be so if server.execute is including the same file as the include file in the same directory...? Than...more >>

I'm a bit confused, or a lot. I'm developing a web app in Frontpage that needs to access a MySql database. MySql database is on the server located at my hosting company. My hosting company uses DSN on the server side. What do I use for a connection string in Frontpage (ASP) that doesn't have c...more >>