Thanks, that worked!
You may or maynot have noticed but I was trying to run a Microsoft T-SQL query. Obviously, the syntax is different with ANSI-SQL. Do you have suggestions for reference material?
Also when you say that I should run the concatenation when retreiving the data rather than...
I am trying to run the following SQL query on an AS400:
update cdbtstd_aa16nt
set cdbtstd_aa16nt.aa1qa = (aa1aqa + ' ' + aa1ara + ' ' + aa1asa)
from istestlib_psr0104 inner join cdbtstd_aa16nt
on cdbtstd_aa16nt.aaefa = istestlib_psr0104.aaefa
and cdbtstd_aa16nt.aaama = istestlib_psr0104.aaama...
I am trying to run the following SQL query on an AS400:
update cdbtstd_aa16nt
set cdbtstd_aa16nt.aa1qa = (aa1aqa + ' ' + aa1ara + ' ' + aa1asa)
from istestlib_psr0104 inner join cdbtstd_aa16nt
on cdbtstd_aa16nt.aaefa = istestlib_psr0104.aaefa
and cdbtstd_aa16nt.aaama = istestlib_psr0104.aaama...
I am trying to accomplish basically the same thing. I have this script working by now i am having a problem with the length of the directory in the cd command. Here is the script i am trying to run:
open lrs035r1.rr1.stilt.mo.us
tboston
tb0716
prompt
type binary
cd...
Hey M,
Thanks for the suggestions. With your response i looked at all of the things you've mentioned and determined that the problem must be in the registration of the component. When going into the componenet services to view that particular component's methods folder contained within the...
I have an asp page that is using com objects creating in Visual Fox Pro. The ASP page is returning the following error:
Microsoft Active Server Pages Error '80020009'
User-interface operation not allowed at this time
/ebatch/confirm.asp, line 65
The line of code that is being referenced is...
Does anyone know if there is a quick way to obtain a list of all ID's, permissions, shares, etc that are in an existing database without having to look at each and every one in enterprise manager?
TIA
Yes, i believe that is exactly what is happening. Here is what we did in response to previous:
if len(request("x")) > 0 then
response.write x
response.end
else
end if
and then submit to the same page:
<form name=submitpdf method=post action=create_public_letter.asp>
<a href ="...
I am using ActivePDF toolkit to generate a pdf document with form fields containing information obtained from a database. The code i have basically comes straight from their product documentation and looks like this:
set toolkit = CreateObject("APToolkit.Object")
r =...
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.