Some questions(+)

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

Some questions(+)

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> Some questions(+)

Page: [1]

Message

<< Older Topic Newer Topic >>

Some questions(+) - 3 July 2005

Bolzano

Posts: 2
Score: 0
Joined: 1 June 2005
Status: offline

Hi,
1) Is it possible to get with u BTAdapter some query like "SELECT field1 ... fieldN FROM table1 WHERE field1 = 1, field2 is not null and(or) filed2 > 23 etc"?
2) About "Locale"-settings... for example: field type is decimail, in USA locale its represent as "23.2323", but I want to get this field in another locale (for ex: "23,2323").
3) dateTime and date. Is it possible to define output format? I don't want to get fields with datatype "dateTime" and "date" like "1999-05-31T13:20:00.000-05:00":)

Post #: 1

RE: Some questions(+) - 5 July 2005

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

Predicates are currently not supported. We are looking at it, but the biggest stumbling block currently is how to define this within a Map. In other words this will impact Schema Generation. We would recommend that you use a Stored Procedure instead.

With regards to Locale settings. Is this for Oracle?

In order for Schema validation to pass, the Date and DateTime fields need to comply with the XSD format. You can change the data type of the fields to strings and then manipulate it according to your own needs though.

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to Bolzano)

Post #: 2