I think GaryC123 was suggesting that you need to include the underscores for the field Atty_ID or is the field called AttyID? Either way, it won't like Atty ID with a space, unless you use the square bracket notation [Atty ID]
SELECT Atty2CaseNew.Firm , TblUniqueAttorneys.Attorney FROM...
Thank you both emblewembl and Tarwn, this sounds like something I need to go and explore, looks promising though :-) ...
I'll let you know how I get on.
Hi,
Can anyone help me? I am using query string to pass parameters, from a page called getlist.asp, to an .asp page, something like this;
http://system.company.com/query.asp?username=peter&pwd=password&command=list
I get a page of html returned something like this;
<HTML>
<HEAD>
<TITLE>Page...
Hi,
Can anyone help me? I am using query string to pass parameters, from a page called getlist.asp, to an .asp page, something like this;
http://system.company.com/query.asp?username=peter?pwd=password?command=list
I get a page of html returned something like this;
<HTML>
<HEAD>
<TITLE>Page...
Hi,
Does anyone have any code samples I could reference for implementing the use of a COM component when accessing a SQL 7.0 database from an ASP page.
I want to prevent multiple connections whenever possible. I want to install a component in MTS and hopefully reduce the number of user...
Hi,
I have an English web server servicing a global network of clients. The code is fine for most users, however those clients running Spanish client installs are experiencing problems when trying to evaluate boolean values. For example, the web server may return 'True' but the client code is...
Hi,
I am trying to install a web application on an Windows 2000 server. My problem arises when the asp.dll processes asp pages and then returns, for example, boolean values. The web app was written in English, however the server has been configured in Spanish. So, rather than returning the...
It's OK thanks, I found it;
upper() for changing to upper case and lower() for changing to lower case.
pretty intuitive I suppose... "Let us not condemn ignorance, let us condemn the reluctance to share"
Hi,
Is there an equivalent of the VB function 'Ucase' in TSQL? I want to perform an update to certain fields, making all entries upper case. At the moment there is a mixture of lower and upper case.
Thanks in advance. "Let us not condemn ignorance, let us condemn the reluctance to...
Hi,
I am trying to disabled an 'A' object with an HREF. I am doing something simple like this;
<A HREF="broadcast.asp" DISABLED>broadcast</A>
However, when I render the asp the HREF would appear disabled (i.e. the color changes), however the link still responds to mouse clicks. I...
Thanks CCTC1, that's exactly what I was trying to do. It's amaing how simple it looks when someone shows you. "Let us not condemn ignorance, let us condemn the reluctance to share"
HI,
I am trying to do something like this within a stored procedure using MS SQL7.0;
SELECT field1, field2, field3 INTO @var1, @var2, @var3 FROM table_name WHERE field1 = @passedinarg
However, without much joy. Is there a way of doing this or do I need to the long winded version;
SET @var1 =...
Using VBScript, ASP, SQL Server 7.0
I am trying to display a countdown on screen to the users in the format of "10:34:44 remaining" however, I would like to change this every second (a bit like you see on the auction sites, with times counting down). Can anyone offer suggestions for...
How can I determine what the last key press was in an INPUT type=text using VBScript. I basically want to capture the user pressing the enter key so that I can fire the submit button.
Any help would be appreciated,
TIA,
Yogi
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.