I think, yes. Basically, I have no way of knowing if it is actually getting the results. I know the service returns them correctly (it's been tested in 3 other languages), so the disconnect must be somewhere in the parsing. If I use:
it will actually dump the correct return content. But I still cannot parse it this way. I have the same problem when get to the $xml->getElementsByTagName("assessment") part.
I'm quite the n00b when it comes to PHP, but as far as I can tell, this looks right (at least close). I'm sure I'm missing something blatently obvious though.
I need to return a class which inherits List(Of ) in a webservice. The consuming application simply views it as an array of the class, not a list. In fact, the Collection class is not even available to derive an object from.
Class Definition:
Public Class TestResultCollection
Inherits List(Of TestResult)
End Class
Consuming App:
Dim TestResults As Gateway.TestResultCollection
TestResults = Gateway.GetTestResultsByRequestIDs(secCode, RequestIDs, sError)
Line 1 above will throw an error: Type Gateway.TestResultCollection is not defined.
I realize that I could just use the array instead, but it's not as easy to work with.
I've found a "solution". It's not perfect, but it works pretty well. If you use SerializeJSON when returning this data from the ColdFusion web service, it will convert it into a properly formatted JSON string. In this case we are actually returning an array of structures, so instead of serializing the entire object, if you serialize each struct as you append it to the array, it gets returned as a impl:ArrayOf_xsd_anyType SOAP type. .NET has no trouble with this at all. Then there's a couple lines to write in .NET to convert that into objects:
Dim objTemp As Object 'This has to be created as an object instead of an array.
objTemp = WebServiceClass.GetData() 'This would be the web service class created by the Web Reference.
Dim serializer As New JavaScriptSerializer()
Dim theClass As New MyClass()
Dim theCollection As New MyClassCollection() 'These are your class objects
Dim index As Integer = 0
'Loop through each entity in the object
For index = 0 To objTemp.length - 1
theClass = serializer.Deserialize(Of MyClass)(objTemp(index)) 'Deserialize the JSON data
theCollection.Add(theClass) ' Add it to the collection
Next
The important thing here is that the Class created in .NET must have properties named exactly the same as the keys of the structure. Otherwise, they will not map properly.
I hope this helps someone else out there. I searched for hours to find a …
I've found a "solution". It's not perfect, but it works pretty well. If you use SerializeJSON, it will convert it into a properly formatted JSON string. In this case we are actually returning an array of structures, so instead of serializing the entire object, if you serialize each struct as you append it to the array, it gets returned as a impl:ArrayOf_xsd_anyType SOAP type. .NET has no trouble with this at all. Then there's a couple lines to write in .NET to convert that into objects:
Dim objTemp As Object 'This has to be created as an object instead of an array.
objTemp = WebServiceClass.GetData() 'This would be the web service class created by the Web Reference.
Dim serializer As New JavaScriptSerializer()
Dim theClass As New MyClass()
Dim theCollection As New MyClassCollection() 'These are your class objects
Dim index As Integer = 0
'Loop through each entity in the object
For index = 0 To objTemp.length - 1
theClass = serializer.Deserialize(Of MyClass)(objTemp(index)) 'Deserialize the JSON data
theCollection.Add(theClass) ' Add it to the collection
Next
The important thing here is that the Class created in .NET must have properties named exactly the same as the keys of the structure. Otherwise, they will not map properly.
I hope this helps someone else out there. I searched for hours to find a solution and found many others having the same problem, …
I am having issues parsing JSON data from a web service. The web service is local on my machine, and I have added it as a Web Reference. Simple data types from the service work perfectly. However, if I call a method that returns a complex structure (such as an array of structures), the object values are Nothing.
For instance,
Dim ClientOffices As New Object
ClientOffices = NTGateway.GetClientOffices()
gives me an object with 31 item objects, all of which are empty.
This is the data that is returned from the web service method:
Has anyone ever tried returning a ColdFusion structure through a web service? The WSDL type CF assigns to this is apachesoap:Map, but when I consume this in VB.NET, the data is null.
I have converted the entire thing into a JSON string, and that seems to work, but it requires a ton of code on the .NET side to handle. We are trying to do this with a minimal amount of work for our customers.
You would probably have to loop through the resultset and assign each row to an array; you can't just split the resultset; it might be easier/faster to just have to queries with their own resultset
I figured that was the case, but wanted to make sure before I gave up.
I'm helping a friend redo his database queries and have run into something that I need some advice on. Let me first say that I am not a PHP developer, so please bear with me.
I have two queries that I can merge together, but I will need to separate the data later. For example, let's say I have a book collection section of my site. It allows users to rate books and optionally write a review. What I would like to do is get all this data in one query (I already have the query for this) and then 'query' the recordset to split the results, those who reviewed the book and those who only rated it.
Is this possible in PHP? I've done it in other languages, but not being a PHP developer, I have no idea where to start.
I recently updated our servers to CF 8.0.1 and now none of my AJAX code works. I checked the XHR response in Firebug and instead of returning the requested data, it returns the HTML code for my site's home page.
All of this was working before the update and I have not changed any code. Has anyone else seen this before?
Here's something to start with. To get the first four characters of the user's name, use the LEFT function. Assuming you have a text box on the form called 'txtName':
<cfset username = LEFT(form.txtName, 4) />
If the name entered in that field was 'mkwebnovice', this would give you 'mkwe'. Next, you can use the MAX function in SQL (provided you are using SQL) to get the highest ID record in your user's table. I am of course assuming that you have a users table with an auto incrementing id field. When you do your insert statement, use this function and combine it with the result of the LEFT function above.
<cfquery datasource="whatever your datasource is" name="qryGetMaxUserID">
DECLARE @userID varchar(10);
SELECT @userID = CAST((SELECT MAX(userID) + 1 AS newUserID FROM users) AS varchar(10));
INSERT
users
(
username
)
VALUES
(
'#username#' + @userID
)
</cfquery>
If you a user table and the last userID is 20, this will result in a username of 'mkwe21'.
Here goes. There's a lot here, so bear with me. This is actually two custom tags. One to set the variables and one to create the links.
Here is the first custom tag:
<!--- pageNumSetup.cfm --->
<cfscript>
// round page number variable up
function roundPageNum(number) {
var x = 0;
x = Int(number);
if(number - x neq 0) {
x = x + 1;
}
return x;
}
</cfscript>
<!--- Set Default values --->
<cfparam name="Caller.startRow" default="1">
<cfparam name="Caller.nextPage" default="">
<cfparam name="Caller.prevPage" default="">
<cfparam name="Caller.numPerPage" default="20">
<cfparam name="Caller.numPages" default="0">
<cfparam name="Caller.curPage" default="1">
<cfparam name="Attributes.queryName" default="">
<!--- Set values for previous and next pages --->
<cfset Caller.nextPage = Caller.startRow + Caller.numPerPage>
<cfset Caller.prevPage = Caller.startRow - Caller.numPerPage>
<!--- Determine the total number of pages for this search --->
<cfset Caller.numPages = Attributes.queryName.RecordCount / Caller.numPerPage >
<cfset Caller.numPages = roundPageNum(Caller.numPages)>
<cfset Caller.curPage = ((Caller.startrow -1) / Caller.numPerPage) + 1>
Now for the navigation links:
<!--- pageNum.cfm --->
<!--- Set Default values --->
<cfparam name="Caller.startRow" default=""> <!--- Numeric --->
<cfparam name="Caller.nextPage" default=""> <!--- Numeric --->
<cfparam name="Caller.prevPage" default=""> <!--- Numeric --->
<cfparam name="Caller.numPerPage" default="20"> <!--- Numeric --->
<cfparam name="Caller.numPages" default=""> <!--- Numeric --->
<cfparam name="Caller.curPage" default=""> <!--- Numeric --->
<cfparam name="Caller.queryName" default=""> <!--- Query --->
<cfparam name="Attributes.forwardImage" default=""> <!--- string --->
<cfparam name="Attributes.backImage" default=""> <!--- string --->
<!--- This variable is used to direct the links to the correct template --->
<cfparam name="Attributes.pageName" default="Index.cfm"> <!--- string --->
<!--- If there is only one page of results, there is no need to show …
Can you give me a little more information about what this particular query is trying to do? You may not need to use UNION, but perhaps different JOINs.
Try using != (not equal) instead of NOT LIKE. LIKE is a little more 'fuzzy' than an explicit equal, which is why you did not get the data you were looking for.
Also, one other thing that might help make your queries easier to read (and type) is using aliases for your tables:
SELECT
r.[Officer ID],
r.[Plate Number],
r.[Violation Commited],
v.[Violation Code],
r.[Street Name],
r.[City of Apprehension],
r.[Vehicle Category],
r.[Vehicle Type],
r.[Vehicle Brand],
r.[Date/Time Apprehended]
FROM
Records r,
Violations v,
DriverInfo di
WHERE
r.[Plate Number] != di.[Plate Number]
and r.[Violation Commited] = v.Violations
SELECT
hourStamp,
NULL AS ActualVisits,
SUM(CASE WHEN datestamp < GETDATE() THEN 1 ELSE 0 END) / @numberofdays as HourAverage,
SUM(CASE WHEN dateStamp BETWEEN DATEADD(d,DATEDIFF(d,0,GETDATE()),0) AND GETDATE() THEN 1 ELSE 0 END) as HourToday
FROM
webstats
GROUP BY
hourStamp
UNION
SELECT
hourstamp,
COUNT(id) AS ActualVisits,
NULL AS HourAverage,
NULL AS HourToday
FROM
webStats
WHERE
id IN
(SELECT ws.id
FROM webStats AS ws INNER JOIN webStatsTrace AS wst ON ws.id = wst.statsid
WHERE (ws.datestamp BETWEEN DATEADD(d, DATEDIFF(d, 0, GETDATE()), 0) AND GETDATE())
GROUP BY ws.id HAVING (COUNT(wst.statsid) > 1))
GROUP BY
hourstamp
ORDER BY
hourstamp
Use aliased NULLs to make the SELECT clauses of the two queries match.
Suppose you have a table with the following structure:
id - int PrimaryKey
name - varchar(50)
description - varchar(MAX)
and the following values:
1 Joe Short for Joseph
2 Dave Short for David
3 Joe Short for Joseph
4 Joe Short for Joseph
5 Chris Short for Christian
6 Rob Short for Robert
Notice that "Joe - Short for Joseph" has three duplicate records. It is true that we can use SELECT DISTINCT to filter these, and for a simple table like this, that's probably the best option. However, sometimes SELECT DISTINCT gets a little hairy when dealing with joins, at least in my experience. So, without having the time to create a complex data structure, or using one I already have that contains confidential data, let's use this simple example.
MSSQL 2005 added a handy new function called ROW_NUMBER(). Learn it, love it (lol). Seriously though, it will make your life easier. What this function does is allow you to get the row number of a record in a returned data table. On the surface, this doesn't sound like much. But, it becomes extremely useful when you realize that you can partition, or group, the records. Let use this on the table shown above:
WITH names AS
(
SELECT
id,
name,
description,
ROW_NUMBER() OVER(PARTITION BY name, description ORDER BY id) AS rowNum
FROM
table_1
)
SELECT
id,
name,
description, …
Go into the ColdFusion Administrator and turn on Robust Debugging. Check the line number and let me know where the error is occurring. I didn't get a chance to actually test this, so I probably missed something.
Strange. You may need to replace it with °, still inside the cdata. I don't remember the ascii codes for the decimal character, but I'm sure that's pretty easy to find.
I'm not aware of any way to get this to work in CF. However, in your SQL query/stored procedure, you could put the data into temp tables, join them there and then return the results to CF. This would eliminate the need for QoQ joins.
Sorry I didn't get this uploaded the other night, the kids have been sick.
Suppose you have a table with the following structure:
id - int PrimaryKey
name - varchar(50)
description - varchar(MAX)
and the following values:
1 Joe Short for Joseph
2 Dave Short for David
3 Joe Short for Joseph
4 Joe Short for Joseph
5 Chris Short for Christian
6 Rob Short for Robert
Notice that "Joe - Short for Joseph" has three duplicate records. It is true that we can use SELECT DISTINCT to filter these, and for a simple table like this, that's probably the best option. However, sometimes SELECT DISTINCT gets a little hairy when dealing with joins, at least in my experience. So, without having the time to create a complex data structure, or using one I already have that contains confidential data, let's use this simple example.
MSSQL 2005 added a handy new function called ROW_NUMBER(). Learn it, love it (lol). Seriously though, it will make your life easier. What this function does is allow you to get the row number of a record in a returned data table. On the surface, this doesn't sound like much. But, it becomes extremely useful when you realize that you can partition, or group, the records. Let use this on the table shown above:
WITH names AS
(
SELECT
id,
name,
description,
ROW_NUMBER() OVER(PARTITION BY name, description ORDER BY id) AS rowNum
FROM
table_1
)
SELECT
id,
name,
description,
rowNum …
I have used the cfmail tag alot but dont get the following to work. I have a form were a system administrator can submit a email to all subscribers informing them of 'something', whatever.
My problem is, the text area field is being used for the body of the mail being send via cfmail query
How do I transform the {NAME} inside the textare to the users real name when the cfmail page process the textarea content.
<textarea name="body" cols="30" rows="4" id="body">Dear {NAME}, welcome to our site.</textarea> <-- This gets pass onto the cfmail page for processing?
You can string replace the {NAME} with the user's name (which I assume is on a form somewhere). For example:
I'm sorry. I'd love to help you with that but I've never used cfexchangemail. Do you know what the special characters are? If so, perhaps you could strip them from the UID before you pass it to the cfexchangemail tag.
Not being able to see the code, I don't have any concrete solutions, but it may be an issue with cookies. If you are able to cancel the second login screen and still get it, that leads me to believe that the authentication page may not be seeing the cookies correctly. I suppose it's possible that it's a mac issue, but I would recommend looking at the cookies first.
If you have a user with Firefox, please have your web programmer install a Firefox addon called WebDeveloper. This will let him get detailed information about the cookies and even set his own for testing. Then he might be able to narrow down the problem.
You don't technically need any version to code for it, it isn't like Visual Studio. You can code in pretty much any text editor.
But to answer your question, if you are going to buy a new copy of Dreamweaver, then CS3 is the latest version available. I believe that any version after 6 supports the new tags added to MX 7, so if you can get an older version cheaper then get CS or CS2.
