Hi,
Can anyone recommend a good forum/mailing list or point me to some good
examples for help and advice regarding developing and consuming web
services with java?
The problem I'm specifically having is how to call a web service (in
java) which returns an array of java objects.
TIA,
Alex
Assuming that each recordset you're returning has something that could
uniquely identify it (eg a productID), I would probably return just 1
recordset, with all the data that you were returning via multiple
recordsets combined - just add the ID number. Then when you're
outputting or processing,
Hi,
I'm trying to create some web services (fairly simple stuff for now -
taking an integer as input and returning a string) but am coming up
against a few irritating problems that hopefully someone can help with
(on CF6.1):
1. If I add a new cffunction to an existing component then it doesn't
to use a CFC with the same name as a CFC that
*used* to exist?
3. Not sure here.
-Original Message-
From: A.Little [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 17, 2005 6:00 AM
To: CF-Talk
Subject: Web services caching
Hi,
I'm trying to create some web services (fairly simple stuff
Is each server using the same database? - as it could be because one
database is returning 1/0 and the other true/false for bit fields
AFAIK (and I could well be wrong!) the valuelist() function just takes
whatever is in the column and it doesn't try and interpret the column
types.
If both
Hi,
Does anyone out there know of any tools/services that I can integrate
with out web publishing system that will check the page content (entered
by users) against web accessibility guidelines (WAI/s508/SENDA) before
we allow it to be published to the live site.
I know about the Bobby, LIFT
OK, I must be doing something really dumb here... I run this following
code:
cfinvoke
webservice=http://dev-iet.open.ac.uk/webservices/people.cfc?wsdl;
method=getPeople
returnvariable=testing
cfinvokeargument name=GroupID value=15/
/cfinvoke
cfoutput#testing#/cfoutput
You could, rather than select the whole date field (which will probably
includes the time? hence why the row is shown as not distinct) select
the year(date), month(date), day(date) then the only way you'll get 2
candidate ids is if one candidate id has two entries for one given day.
Or you could
Hi,
I'm playing around with creating a couple of simple web services, but as
soon as I add more than one function to a component, I seem unable to
invoke the second function and get the error message 'Web service
operation myDocTitle with parameters {5024} could not be found. ' but
it works fine
It does return valid wdsl, however the wsdl doesn't appear to have any
of the elements/details for the myDocTitle function, only the
getDocTitle function.
I'll have a go with an even simpler service (as you suggest) and see
what happens.
Alex
-Original Message-
From: Alistair Davidson
You could do it with something like this (this is untested!! - but
you should get the idea shouldn't be too resource intensive)
UPDATE trucks
SET totalmileage = t.totalmileage + r.mileage
FROM trucks t, (SELECT SUM(Mileage) AS mileage, TruckID FROM
ReportingData GROUP BY TruckID) r
WHERE
Hi all,
We're in the process of developing a new site which is very similar to a
previous site we've built, so we copied the webroot and customtags to
new folders and renamed the customtags (and references to them within
the code). Now we've mapped the dev domain name to the webroot, so we
have
?
Are you using CF mappings? If you didn't change those it will include
the files from the previous site when you use them.
Are you using the application and session scope to store info? Be sure
to change the name attribute of cfapplication
Pascal
-Original Message-
From: A.Little [mailto
Hi all,
We're in the process of combining our dept focussed intranet (iet-only)
and institution focussed intranet (iet-ou) into a single intranet
(iet-intranet) and I'm trying to figure out the best way to redirect
users who go to iet-only or iet-ou to the new site (as most of the pages
will be
-
From: A.Little [mailto:[EMAIL PROTECTED]
Sent: dinsdag 23 maart 2004 12:39
To: CF-Talk
Subject: Redirect cferror
Hi all,
We're in the process of combining our dept focussed intranet
(iet-only) and institution focussed intranet (iet-ou) into a single
intranet
(iet-intranet) and I'm
Cheers Mike - that's what I needed ;-)
Alex
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]
Sent: 23 March 2004 12:08
To: CF-Talk
Subject: RE: Redirect cferror
in iis make sure the for .cfm extensions it checks for the existance of
the file, that way it will then
Kelly,
Just out of interest, what have you found to be problematic with eWebWP?
I'm asking because we're looking at using this tool too, but it would be
handy to know the experiences from someone who's used it in 'real life'
;-)
Ta,
Alex
Ps. Feel free to email me off list if it goes a bit OT.
Hi all,
Am I going mad or is there something I'm missing If I run the
following code:
cfloop from=0 to=5 index=i
cfset tempdate=dateadd('d',i,'26-mar-2004')
cfset temp2 = '31-mar-2004'
#i#: #tempdate# to #temp2#: #datediff('d',tempdate,temp2)#br
/cfloop
I get the following output:
0:
Hi,
Not sure if this will help but I noticed in my cfheader/cfcontent code
that I had double quotes around the filename in the value attribute of
the cfheader tageg
value=inline; filename=myfilename.doc
HTH
Alex
| -Original Message-
| From: Shawn Grover [mailto:[EMAIL PROTECTED]
You could set up a scheduled task to run at say 7am, all this task would
do would be to generate the random time between 8 and 10am and then
update the actual task using cfschedule to next run at the time that
has just been generated.
Alex
-Original Message-
From: Phillip B
Yes, we've had that too, the solution we found was to use:
cfqueryparam cfsqltype=...
value=#preservesinglequotes(form.variable)#
Doesn;t help for all those records where theres already a load of single
quotes - but it should be easy enough to write an update query to get
rid of those.
Alex
Hi all,
I'm trying to write a regular _expression_ and am having a little
trouble... What I want to do is replace all instances of '/document.cfm'
in a string with '/public/document.cfm', unless the original substring
is '/public/document.cfm' - ie I don't want to end up with
Your best bet (I think) would be to use the SQL server Data
Transformation Service. This will allow you to export tables/views etc
to access quite easily. Just go into SQL Ent Manager and export the
required tables to Access, and if you need to regularly dump the data
out, you can save the export
Here's another one to help get you started
http://www.w3schools.com/css/default.asp
Alex
-Original Message-
From: John Munyan [mailto:[EMAIL PROTECTED]
Sent: 27 November 2003 19:26
To: CF-Talk
Subject: Learning CSS
I am just realizing the power of CSS, but am also aware
It might to do with the CF templates being compiled. After a template
has been amended (or after CF has been restarted on the server) CF needs
to recompile the template, hence why it can be much slower on the first
'hit' than the subsequent hits.
This was a bit of a problem for doing
Hi all,
We've been approached by a couple of other Universities who are interested
in using one of our applications developed in CF. We would be providing
them, for free, with a non-encrypted copy of our CF code and database schema
script, so they would be able to develop the application and
You could treat the form field as a list delimited by '/', then you'll have
the first 2 list elements will give the protocol and the domain name, and
the remaining list elements would give you the script name and query
string... something like:
cfset domain_part = listgetat(form.myurl,1,'/')
It usually best not to store data like this in one field though, rather
store it in the 3 seperate fields and combine them in the query when you
extract the data from the database or in your application. You may find in
the future that you need to get 'Mr Smith' rather than 'Mr John Smith' from
You ought to be able to get the authenticated user from the cgi vars,
cgi.remote_user or cgi.auth_user, not sure about getting the computer name
using thsi method though.
Alex
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: 29 September 2003 12:53
To: CF-Talk
Subject:
Hi all, We've just upgraded a couple of our development servers from CF5 to CFMX(6.1) and we're having problems getting CFMX to connect to MS SQL2Kdatabases on another server. When we were using CF5 (behind firewall) wecould connect fine to databases on 2 different servers (one behind thefirewall
Yes, we've got SQL server running in mixed mode (we did this when weupgraded on of our other servers to MX) and I;ve checked the passwords a fewtimes ;-) I'm not sure that its a password problem because cf admin usuallytells you it's a login failure, but we're getting timeout errors AlexCheck
Thanks Steve, I'll give that a go, btw we are on win2K server IIS5Alex-Original Message-From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: 26 September 2003 13:55To: CF-TalkSubject: RE: CFMX and SQL Server database connection problemsWe had a similar problem when we got locked
SQL doesn;t really cope with lists very well, there are some articles here(http://www.sqlteam.com/SearchResults.asp?SearchTerms=csvhttp://www.sqlteam.com/SearchResults.asp?SearchTerms=csv ) about passingcsv strings to stored procs in SQL to then process, but as you'll see itstarts to get a little
If you need to track what's been inserted/deleted, then you could (beforeyou do any db inserts/deletes) loop through the old list and find whichvalues aren;t in the new list - to find whats been deleted, then loop thoughthe new list and find which values aren;t in the old list to find what'sbeen
You can use a double # so that CF will recognise that you want to display
the #...so your a tag should be something like this...
a href=listingdetail.cfm?newimage=#PhotoID#ListingID=#ListingID###photo
Alex
-Original Message-
From: Britta Bennett [mailto:[EMAIL PROTECTED]
Sent: 22
SELECT COUNT(id_col), id_col FROM myTable
GROUP BY id_col
HAVING COUNT(id_col) 1
Should do the trick for you,
Alex
-Original Message-
From: Wurst, Keith D. [mailto:[EMAIL PROTECTED]
Sent: 19 August 2003 15:10
To: CF-Talk
Subject: sql question
i would like to write a sql
Hi all,
OK, can anyone tell me what I;m doing wrong here... I have created a very
simple webservice (see code below), which works fine if I try to call it as
a cfc, but as soon as I try to call the method as a webservice, I get the
error 'Web service operation getDocTitle with parameters {5459}
You just need to put in a cfheader tag just before the cfcontent tag...
cfheader name=Content-disposition value=inline;
filename=myfilename.xls
HTH,
Alex
-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: 05 August 2003 15:58
To: CF-Talk
Subject:
I usually use MS Visio - the basic version contains all you'd need to do ER
diagrams and it's not very expensive - though not as cheap as shareware. If
you're using SQL2K (not sure about v7) you can get it to auto generate the
ERD from the existing tables/relationships, but that doesn't help if
You mentioned earlier that 'I've added the database via Data Sources (ODBC)
under the System DSN tab using the SQL Server driver. I did a test and it
passed.'
Have you checked that the data source is working/valid using CF admin?
You could also try to see if it's only that table where the error
Your best bet might be to move to using the Verity K2 spider search, so that
the pages are actually processed, this would then ensure no asp or cfml code
(or php etc) gets returned in the search results.
Alex
-Original Message-
From: Parker, Kevin [mailto:[EMAIL PROTECTED]
Sent: 13
this:
Go to your ColdFusion Administrator. Locate the web service
in question
via Data Services - Web Services. Click on the refresh icon.
Try running your code again.
André
-Original Message-
From: A.Little [mailto:[EMAIL PROTECTED]
Sent: 08 August 2003 10:00
To: CF
I;ve also experienced this (on CFMX), where monthly scheduled tasks end up
running at 'odd' times. I didn;t find out the cause of the problem, but what
I did in the end was to amend to the script template so that it checked for
the current day/date first...eg...
cfif dateformat(now(),'d') eq 1
I think it depends on the datatypes you're using as inputs to the division
calculation, if they are integers then it does have problems, you could try
using:
(CAST(myfield AS float))/(CAST(myfield2 AS float)) if myfield1 and myfield2
are integers
Alex
-Original Message-
From: Joshua
I find the main reason for using identity PKs is that the urls generated are
much shorter and easier for the user, especially if they have to type them
in from a printed url... eg:
http://www.mydomain.com/index.cfm?id=12345
or
Do a backup of the transaction log, and under the 'options' tab in SQL Ent.
Manager select the 'remove inactive entries from transaction log' option.
You'll probably want to have the transaction log backed up regularly (at
least daily) - so when you do the transaction log backup, also select the
You could make the download area password protected and issue a unique
password to the user, who has to enter it to access the download. Then just
ensure that each password can only be used once. One problem you may
encounter is users entering the download area, but not downloading the
software,
Hi all,
We've recently upgraded to CFMX and I'm in the process of changing our
references to cfgraph to cfchart, but I'm finding that cfchart doesn't
always generate a graph, the browser just sits there with the progress bar
stuck. The rest of the pages display fine (including text/data after the
I don;t think the cfoutput is inherited by the cfinclude templates from
the calling template, so you'll need to put cfoutput in each of the
include templates where you want to output a variable.
Don't ask me why it works like this - I have no idea ;-)
Alex
-Original Message-
From:
(syntax for MSSQL2K)...
WHERE Date = getdate()
AND Date = dateadd(d,6,getdate())
should work. That way you don;t need to bother creating and passing the
dates using CF. You might also want to change the name of your column 'date'
as it's a reserved word.
Alex
-Original Message-
You can also use style sheets to determine what gets printed as opposed to
what users view on screen - so just use a media=print stylesheet and make
it blank - or something!
eg:
link href=/css/knstyle.css rel=stylesheet type=text/css
media=screen
link href=/css/knprintstyle.css rel=stylesheet
Hi all,
I'm using cfhttp in CFMX, and according to the docs the 'timeout' attribute
doesn't function with JDK 1.3 (which is what I'm using) so occassionally the
page just hangs indefinitely. Is there some code I could put around the
cfhttp tag which will replace the function of the timeout
You could use listfind() instead in your cfif query - this then won't find
the incorrect matches that you're getting at the moment.
Alex
-Original Message-
From: jeremy [mailto:[EMAIL PROTECTED]
Sent: 03 July 2003 14:16
To: CF-Talk
Subject: Parse formated list
I have a list of
I've come across the same problem - only occassionally though and I can't
reliably reproduce it. I did find though that it only occured when the page
was displayed as a result of submitting a cfform, I couldn't get to
reproduce the error at all if the page was called from a normal html form
HTH
You could try removing the a_items.END_TIME from your select and group by
clauses to see if that does what you need, as if each of the values for
a_items.END_TIME are different the query will create a row in the resultset
for each value.
Does that help?
Alex
-Original Message-
From:
I came across a similar problem and ended up having to change my code so
that it looks like;
cfscript
objDoc = objWord.Documents;
newDoc = objDoc.open(c:\mydocument.doc);
myRevisions = newDoc.Revisions;
MyRevCount = myRevisions.count;
The CF5 Verity can spider (but only licensed to spider 'localhost'), but
only if you set up the K2 Verity server. Otherwise it (as you say) just
indexes the file system with no parsing.
Alex
-Original Message-
From: Hugo Ahlenius [mailto:[EMAIL PROTECTED]
Sent: 07 March 2003 10:19
try http://fbopenforums.sourceforge.net/
Alex
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: 06 February 2003 14:19
To: CF-Talk
Subject: Re: need a bb script
On Wednesday 05 Feb 2003 15:25 pm, Dimo Michailov wrote:
Why not have the link built into the collection? So why you do the indexing
from the db instead of the title being 'xxx' the title is 'a
href=mylinkto.htmxxx/a'?
Then when you're outputting the results when the user has selected all
collections you don;t need to worry about which individual
When you index each collection set custom2 to be some value, eg
'link','download' etc. Then when you come to output the results just do a
cfswitch/case to determine which link the key or title should go to and
display accordingly.
Alex
-Original Message-
From: Ian Vaughan
Yes, not quite as easy as in php though. The logic I've used before goes
something like:
cfparam name=request.included default=false type=boolean
cfif not request.included
cfinclude template=mytemplate.cfm
cfset request.included = true
/cfif
HTH
Alex
-Original
It's still there in DWMX... but you need to use Ctrl+alt+] and Ctrl+alt+[
Alex
-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]]
Sent: 10 December 2002 13:30
To: CF-Talk
Subject: DWMX - Moving blocks of code.
I enjoyed the feature in CF Studio that allowed you to
Depends a bit on what database your using, if your using MSSQL have a look
at http://www.sqlteam.com/item.asp?ItemID=2955 as it looks from your query
as you're trying to create a crosstab/pivot table (where rows in the query
become columns). If you're using MS Access, it's a bit easier as you can
Hi all,
I'm trying to upgrade our dev server from cf5 to cfmx and am having a little
problem... (btw its win2k iis5 sql2k).
The security on our websites depends on an isapi filter which redirects the
user to a secure login page, sets a cookie then allows the user back to the
website. The
I'm not sure that you can tell CF to stop logging 232 errors. But using CF
administrator you can store the log file without having to restart cf. Just
go to the CF admin log files page, the 'store log file' option is the yellow
button under controls.
This will then store your server.log file as
You've got an extra 's' in LoadNewSession on the 3rd line of code.
Alex
-Original Message-
From: Jeffry Houser [mailto:jeff;farcryfly.com]
Sent: 14 November 2002 14:19
To: CF-Talk
Subject: True is False
I must be missing something really obvious.
This is the code ( In the
Hi all,
I'm writing a stored procedure (in SQL Server 2K) in which I need to create
a couple of temporary tables (which are dropped when the sp has completed).
How do I get around the fact that 2 users of the website may run the sp at
(precisely) the same time, creating the possibility that one
Nevermind, I've found I can use the TABLE variable type in my sp so the
table is only created locally to the sp (btw, this is new to SQL2K).
Any advice/experience on the performance of this would still be appreciated,
Alex
I'm writing a stored procedure (in SQL Server 2K) in which I
need
The code you're using to generate a long string will give:
For 1-9 it will produce: 123456789 (making len(str)=9)
but for 1-10 it will give 12345678910 (making len(str)=11) etc
So the string len that you're getting (53799) sounds about right when the
loop goes up to 12981.
Doesn;t explain why
On CF5 (and cf4.4 I think- can't remember exactly) in the CF admin pages and
go to 'logging settings' (under the tools option in the top left). On that
page you can set the server to record pages which take longer that x
seconds.
hth,
Alex
-Original Message-
From: Shahzad.Butt
You don;t need to trim these down to 16 chars as that isn't the max length
you can store in a SQL 'text' field - it's something like up to 2Gb of data
(on SQL2K) - even though the length says 16 on the table design (I think
this was discussed in a thread here 2 or 3 weeks ago) and changing this
Hi,
We've had exactly the same problem with our document management system - the
way we originally got around it was to use 2 verity collections,
DocumentMetaData (a collection of the database entries) and DocumentFile (a
collection of the actual document files). Then when you do the verity
SELECT Month(my_date_fieldname) AS myMonth FROM myTable
-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]]
Sent: 08 October 2002 14:49
To: CF-Talk
Subject: SQL question
Is there a way to use a Select query to get just the month
out of a date in
a SQL
If you are going to use an access data project to connect to the SQL tables,
the SQL table must have a primary key - or access won't let you edit data in
the table (the PK can be composite)
Alex
-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]]
Sent: 07 October 2002 02:44
To:
Don't know for sure, but could it be that the fields where you're adding
27.5 are set up as integer fields? This might not have been a problem in
Access where there's just a 'number' datatype, but could make a difference
in sql with 'int', 'float', 'decimal' etc
If you've auto-upsized your
75 matches
Mail list logo