i have this query string and goes off and pulls off all records from the inktest fields where stock level is below min. But i also want to pull off the make of ink from another table tblmake.
the problem i have is that tbl make is not linked to inktest it goes though another table tblmodel as there is only one make ie Canon many models of printers and each model can have anything upto 4 inks, is there a way i can have another record set something like select * from tblmake or i could create a query that pulls off the ink model and make but only displays the ink and make then select * from newquery where inktestid = newquery.inktestid that should give me what i want kinda rite?? Code:
Last week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. ../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page: GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?
I have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.
Ship Date: 04/06/04
Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx
What I want is:
Ship Date: 04/06/04
1: Data xxxxxxxxxxxxxxxxxxxxx 2: Data xxxxxxxxxxxxxxxxxxxxx 3: Data xxxxxxxxxxxxxxxxxxxxx 4: Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
1: Data xxxxxxxxxxxxxxxxxxxxx 2: Data xxxxxxxxxxxxxxxxxxxxx 3: Data xxxxxxxxxxxxxxxxxxxxx
How can I get these numbers printed againsts the records ?
I have it at the moment that on the main default.asp there is a recordset that will display all records within that table, these are a list of forums that will be available.
I have a table that will show the forum name, and the description. This table is then looped using Do while not, now what i need to do is show how many records in the Treads table are related to each forum using asp. Code:
I want to have a single script for sending emails, accessible from both ASP pages in any virtual directory in our websites (all on the one server), plus accessible from a number of WSH (windows scripting host vbscript files) which are triggered by the web servers Scheduled tasks.
The script formats text and checks emails and so on.
Is this a candidate for a web service? if so, how would i write it? Is a web service available from WSH?
We have a C++ DLL that we call from VB6 program. This is how we declare the DLL in VB6: Declare Function RefSearch Lib "csearch32.dll" (ByVal path As String, ByVal findword As String, ByVal CaseSensitive As Integer) As Integer This is how we call the DLL in VB6: hit = RefSearch(path, SearchStr1, ChkValue). Can I call this DLL in ASP and how ?
I have a bummer here. I have 3 sub R. that I need to call from a input button. I set up the following line, but the script just calls them with out having the button pressed. OOOO! Any ideas?
I have a form which checks email addresses. On submitting the form i have some JavaScript checking the format of the email address, once this has been completed successfully I would like my asp function to run. On successful completion of that I would like my form to be submitted to another page. Is this possible?
This may be in the wrong forum, but I'm going to give it a shot anyways. Here goes. I have a conference report that has 24 phone lines that are available for booking. Each call can take between 1-24 lines, you can have any number of calls as long as the number of lines they take up does not go over 24. I graphiclly represent this in a horizontal bar graph that displays the number of lines that are taken up for a particular half hour. Problem is when a meeting takes more than a half an hour, the meeting bar fills up for that whole time without any information on the meeting. What I would like to do is have each meeting when assigned in the DB or through an array be assigned a color and then that color appears on the graph under the time the meeting is. If there are multiple meetings (there almost always are), then the meeting that has been active the longest will be the first color bar on the graph. To make a way too long story short. I want to have a stacked bar chart that moves colors to the front as other's leave every half hour and move new ones to the back. If you want to look at what we have now visit URL.
Ok i'm self taught with regards to ASP so not great etc, so sorry if this is a really basic question..
On the last line here i'm trying to some how get it to call the last ID entry...
ImageID = Request("ID") If (Len(ImageID) = 0) then ImageID = "1" If Not IsNumeric(ImageID) Then ImageID = "1" If ImageID = "0" then ImageID = "1" If ImageID>3 then ImageID = max(Len(ImageID))
This is basically for some max min links for a online comic here's what it links to
My 1st page calls a 2nd that uses same data from a database. What is the best way to get the data in the second: a new call to the database or passing array through session variable?? I seems to me that avoiding a new call will speed up things but my concerne is that I have read many posts with caution messages againts session vars.
I've built an application in VB6 does some processing - it's not really important what it does. The application consists of a single DLL which does all the hard work, and a simple EXE which acts as the front-end. I designed it this way in the hope that I could also build an intranet app that controls the same component (DLL). I'm building the intranet page now, but I get this error when I try to instantiate the component. Rather than fiddle aimlessly with the permissions, I thought I'd post here and find out what I am missing. What permissions do I need to set up and where?
The error occur as "myiframe" is in a.asp and i need to call it in b.asp and i can't find the solution for that too.?anyone know how to pass value from a.asp to b.asp in above?
DLL name: openagent_HTTP.dll Function name: TurnOn
The above coding works fine, i run the above script in button on click, it can pass the value to the dll, but evertime it prompts for each click, because i use the window open,
What i need to do is, instead of calling my dll through Internet explorer,
Is there is any way i call my dll straight and pass the value without window open?, pls help almost struggle for a week...
I have written a very complex web app for intranet use. It allows users to search a large database and then returns formatted results. I am currently employing a method as below: Code:
I have an asp page accepting input from users Lets say this is form A, form A passes data to another form (say form B) to validate the data, if its valid then I want to open up another asp form (say form C) that does some queries based on data sent by form B.
I need help in opening the form without user intervention meaning, users should not have to press any key.
With .asp,how do I call another program?I would like to have my .asp script make a call to a PERL script, wait for the PERL script to finish, and then continue with what is/isn't returned from PERL.
I know in PERL this is simply done: system(theASPprog.asp). No fork is created, so the PERL prog waits for the .asp to finish.How do I do this with ASP?
I want to syndicate some content to other users. (no RSS).Anybody should be able to publish some information from my server/database by placing some javascript like: