Windows XP PRO SP2
CTA 100 Software locks on install.
When it gets to 50% it says installing component TFP , Please wait a moment
and then it never finishes
HELLLPPP :P
A column in excel.
I need a date entered in like 2007-01-01
Everytime I type that in, it automatically changes to 01/01/2007.
I reformat to general or number and it changes to 39083!
I cannot find a date format of this sort in the list of date formats.
How do I keep it from doing this, I'm...
Here's the point.
I load a page of all of my products details in my admin section so that my people can adjust product records.
All of the main product info comes from a table "bProducts"
Certain items come from other tables, like Manufacturer or Category or SUB category.
in my newly made...
Can I make this even worse?
I also wanted to infuse the stuff to select.
I defined a constant (maybe this is not the right thing) in my constants file for the selection
Const ProdDisplaySql = "Brand, ProdID, ProdURL, ProdSKU, Category, ThumbImageURL, LinkText, ProdURL, ProdMiniDescription...
The only reason I was trying to get the code into an include file simply for ease of adjustability.
I figure if I put this sql statement on over 100 product pages and then decide I want to add something, I didn't want to have to adjust every single sql select statement.
I need some help.
I have a sql select statement that I would like to place in an include file.
The SQL select statement is fed variables from the page.
For Instance
<%
Dim manuID, CatID
manuID=6
CatID="'part','processor'"
Dim objRS
Set objRs = Server.Createobject("ADODB.Recordset")...
Ive tried these and neither seem to work..
Here is my exact statement
objRs.Open "SELECT ProdID, ProdURL, ProdSKU, Category, ThumbImageURL, LinkText, ProdURL, ProdMiniDescription FROM bproducts WHERE Manufacturer='6' and Category='part' or Category = 'processor'"
and the page gives me this...
Ok, trying to make a sql select statment that will return a record set containg two values for one column.
Like this
Select * from TABLE1 where BRAND='abc' or 'xyz'
I want it to return all of ABC and all of XYZ but not DEF and not GHR
This obviusly doesn't work but I know there is a way, I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.