Search results for query: *

I have a page which calls a recordset image. When you click the image the link is set to <%=(Recordset1.Fields.Item("image1").Value)%> so it opens up in a new window bigger. I want to know if there is way to attach to the link a java script which will add a close window behavior? Thanks. Steve

Hi and thanks in advance. I have a query, the works, and it basically shows the order information from a typical e-commerce database. Now when I run this query, and for this example lets say I am the customer and I order 3 distinct items in various quantity. Now when I run the query it shows all...

I want this query to show the unique orders per persons firstname, which in this case happens to be the full name I have 3 tables Users, Orders, OrderDetails. SELECT DISTINCT DetailOrderID, UserID, OrderUserID, DetailProductName, DetailQuantity, DetailPrice, OrderShipping, OrderTotal...

What am I missing here? SELECT OrderID, DetailOrderID, OrderUserID, DetailProductName, DetailQuantity, DetailPrice, OrderShipping, OrderTotal, OrderDate, Firstname FROM Orders AS o, OrderDetails AS d, Users AS u where o.OrderID = d.DetailOrderID and o.OrderUserID = u.UserID

I have an online web database IIS server, with and access e-commerece db. I wanted to know if I could connect to this database via excel to extract data as need be? It is a web server so read permissions are off for the database so New Web Query will not work unless there is something I missed...

I have an online web database IIS server, with and access e-commerece db. I wanted to know if I could connect to this database via excel to extract data as need be? thanks for any help with this. Steve

I have a e-commerce relational access database. I have to create a query that uses 3 tables Orders: OrderDetails: Users: The orders table has a one to many relationship with the ordersdetails tables as such: orders 'OrderReferenceID' & orderdetails 'DetailOrderID' And the users table has a...

I have to create a view that uses 3 tables Orders: OrderDetails: Users: The orders table has a one to many relationship with the ordersdetails tables as such: orders 'OrderReferenceID' & orderdetails 'DetailOrderID' And the users table has a one to many relationship with the orders table as...

I am using an access database, and when I run my query I get the following error but cannot figure out where the snytax error is. [Microsoft][ODBC Microsoft Access Driver]Syntax error (missing operator) in query expression dbo.OrderDetails.DetailOrderID = dbo.Orders.OrderReferenceID INNER JOIN...

How can I give a name to the column where this statement displays its results? SELECT *, case srctable_cah when 'dbo.activity' then 'Activities at 689' when 'dbo.goal' then 'Goals' when 'dbo.technician' then 'Technicians Report' when 'dbo.marketintell' then...

I have a table with serveral fields. One of the fields is called srctable or source table for short. This field stored the information about which table the record came from. It saves that information as 'dbo.activity', dbo.goals, etc. Is there a way that I can query the table so that the...

How would I write a select to exclude both NULLs and records from a table where there is absolutly nothing in there not even the word <NULL>? Select * from Table WHERE table.record1 <> ??? Thanks

CREATE TRIGGER tr_insertact ON technician FOR INSERT AS DECLARE @tid int, @eventdate datetime @artist varchar(255) @category varchar(10) @reasonvisit varchar(255) @postpriority varchar(20) @activitytype varchar (50) --get details of inserted row SELECT @tid = tid, @eventdate = datetime...

I need to create a trigger that will insert a record into another table, here is the criteria. I want so that everytime a new technician report is added it gets also recorded in teh activity table as a aritist visit guest book item: technician (table source) activity(table destination)...

I have a recordset, or sql statement that searches through a table based on the value of a request.query string. I want the results to exclude the actual direct hit find. For example searching for John Alexander Interview, could show John Alexander Interview John Alexander Photos A Day with...

I have a table which contains information from 4 other tables, and one of the feilds called srctable_cah or source table contains the name dbo.activities for example of where the record is from. Is there a way so that I select that feild that is shows up as simply Activities? Remember that...

My SQL looks like this: SELECT * FROM dbo.table WHERE name LIKE '%MMColParam%' Variables: Name: MMColParam Default valuer: 1 Run-time value: Request.QueryString("txt_name") Lets say there are 4 records in the table 1. Jack Black 2. Jack Black wins the gold 3. Jack Black Interview 4. Welcome...

I have a recordset in dreamweaver, I know! SELECT * FROM dbo.activityout WHERE activityname LIKE '%MMColParam%' The variable is set to filter by url parameter id which is assigned to MMColParam through a variable. Lets say I have a record of John O'Conor And I search for John O'Conor at...

Is it possible to pass 2 url parameters? activities_details.asp?id=<%= rssecondaract.Fields.Item("aid").Value %>activityname=<%= rssecondaract.Fields.Item("activityname").Value %> Steve

I have a really complicated issue. I have four tables. No relationship outside of the possibility that they "may" have the same name. So I have setup two test pages test.asp and test1.asp I want so that if a person clicks a link on test.asp the results will show up on test1.asp and query the...