Search results for query: *

I'm trying to find out if an embedded database can be used online as part of a shopping cart or as a order system. I have a feeling the answer is no from what little i've read about embedded databases so far but i've not found any articles that address this issue. any body know of any...

Thanks VBSlammer it worked a treat :o)

I need to get an account number from my access form to a url which will be processed by an ASP page. Can you tell me how I would get the variable by the name of strAccount from the form onto the end of following URL: http://xyz123/accounts/account.asp? It's not really covered anywhere i've...

We use a batch file that copies the front end to the users c drive and a short cut that is saved to their windows start up menu that points to the front end on the c drive. so yes desktop shortcut =)

Hi, I have a front end database that attaches to the back end. When the front end loads I do not want to display the database window. In the start up for the front end I have unticked the Display Database Window and Use Access Special Keys check boxes and for most users when the database loads...

I'm trying to use a recordset to display all records based on a query with a maximum of 5 records displayed on a page. The records are displayed in a table. I need a submit button to take the value of each particular record to the next page via ASP. I'm trying to use a rollover image to act as...

I've solved this... basically it was the calling of Server Variable CONTENT_LENGTH. The data had already been posted from the search page so it was not setting the page number = 1. I rquested the value of the submit button from the form as my marker for a value of 0 rather than the...

Yes they are... tried an interesting test... I took the code out for the data from the search form on the previous page, substituting the acctount number instead of the strAccount variable in the SQL.It worked fine. Now i just need to work out where the problem is. Any ideas?

yes it is :0)

...Server.CreateObject("ADODB.Connection") strConnection = "DSN=wakeywaeky;Database=wakeywaeky;UID=;PWD=;" conn1.Open strConnection strSQL = "SELECT * FROM tblUser WHERE txtUserID = '" & strEnumber & "' " Set userRS = conn1.Execute(strSQL) IF userRS.BOF = false AND userRS.EOF = false THEN...

its ok i worked it out. I hadn't used the LIKE condition when opening the form. Blindness is indeed a disability ;o)

...On Error GoTo Err_cmdAccountSearch_Click strAccountNo = Me.AccountNo If (DCount("AccountNo", "tblAccountBase", "AccountNo LIKE '*" & strAccountNo & "'")) = 0 Then MsgBox "The Account Number you are searching for is not in the database!" Me.AccountNo = ""...

...Code on page with form (line 76 is in bold): <%@LANGUAGE=&quot;JAVASCRIPT&quot;%> <!--#include file=&quot;Connections/ntsa2.asp&quot; --> <% // *** Edit Operations: declare variables // set the form action variable var MM_editAction = Request.ServerVariables(&quot;SCRIPT_NAME&quot;); if...

The code underlying the pages doesn't use a record set. I think the problem is to do with the connection string because that is what line 76 refers to.

New to dreamweaver mx. Using ASP with JavaScript Built a form to send data to MS Access database and get the following error: Error Type: ADODB.Command (0x800A0BB9) Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /ntsa/register.asp, line 76...

how is this done exactly I'm not sure, new to ASP.

...'Set an active connection to the Connection object using a DSN-less connection adoCon.Open &quot;DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=&quot; & Server.MapPath(&quot;ksp.mdb&quot;) Dim iCount iCount=Request.Form(&quot;Count&quot;) Dim strSQL 'Holds the SQL query to...

...below, any ideas? <%@ page language=&quot;java&quot; contentType=&quot;text/html&quot; import=&quot;ShoppingBasket,Product,java.util.*&quot; errorPage=&quot;errorpage.jsp&quot;%> <jsp:useBean id=&quot;basket&quot; class=&quot;ShoppingBasket&quot...

Clue, have since discovered that problem is not with SQL code as it works fine if the following is taken out of the code: <jsp:useBean id=&quot;basket&quot; class=&quot;ShoppingBasket&quot; scope=&quot;session&quot;/> <% String title = request.getParameter(&quot;title&quot;); if(title!=null)...

Ok thanks to Sem's help I now only have 2 errors relating to the : getLastInsertID() Someone has given me a tip that this is not in the java.sql API so does anybody know how to get an autonumber id out of an access database from a newly inserted record? Thanks