p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

Go Back   p2p.wrox.com Forums > XML > XSLT
Reload this Page Database insertion (blob object) through XSLT script
I forgot my password Register Now
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
XSLT General questions and answers about XSLT. For issues strictly specific to the book XSLT 1.1 Programmers Reference, please post to that forum instead.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the XSLT section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.

Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old May 26th, 2009, 01:30 PM
Registered User
Points: 19, Level: 1
Points: 19, Level: 1 Points: 19, Level: 1 Points: 19, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2009
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database insertion (blob object) through XSLT script
Hi Folks,
I have an xml response, which I want to store into the database (mysql) through XSLT script.

For basic data types, I can just prepare a simple insert statement through xslt script which further passed to java for further execution.

Code:
<xsl:template match="ota:OTA_TT_HotelResRS">insert into booking 
	(createdBy, bookingNumber, created, modified, start, end, bookingType, hotelName, duration, numberOfPassengers, surname, status, touroperator, agency_code, departure3LC, arrival3LC, travelCode, totalPrice) 
	values (
	"<xsl:value-of select="$profileNode/ota:OTA_TT_ProfileReadRS/ota:Profiles/ota:ProfileInfo/ota:UniqueID/@ID"/>",
	"<xsl:value-of select="ota:HotelReservations/ota:HotelReservation/ota:ResGlobalInfo/ota:HotelReservationIDs/ota:HotelReservationID/@ResID_Value"/>", 
	NULL, 
	NULL, 
..
..
)  
	</xsl:template>
But now I have got an additional column where I want to store the entire xml response as blob object as well. That in addition to the few columns (shown above), I want to store the same entire response as in the last column 'bookXMLDoc' of this book table.

Code:
	<xsl:template match="ota:OTA_TT_HotelResRS">insert into booking 
	(createdBy, bookingNumber, created, modified, start, end, bookingType, hotelName, duration, numberOfPassengers, surname, status, touroperator, agency_code, departure3LC, arrival3LC, travelCode, totalPrice, bookXmlDoc) 
	values (
..
So I have no idea how to do this? One approach could be to use java prepared statement inside the xslt script and finally executing it inside the xslt that is opening, creation, execution of database connection everything inside the xslt script.

Also please tell how to access the java object from xml response and store it as blob through the xslt script?

I hope i have explained the problem correctly.

Basic example would be very good.

Awaiting replies.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
  #2 (permalink)  
Old May 26th, 2009, 01:40 PM
Friend of Wrox
Points: 2,934, Level: 22
Points: 2,934, Level: 22 Points: 2,934, Level: 22 Points: 2,934, Level: 22
Activity: 94%
Activity: 94% Activity: 94% Activity: 94%
 
Join Date: Nov 2007
Location: Germany
Posts: 626
Thanks: 0
Thanked 88 Times in 88 Posts
Default
Which XSLT processor do you use? If you want to store the XML of a node you could use an extension function like saxon:serialize http://www.saxonica.com/documentatio...serialize.html to serialize your node.
__________________
Martin Honnen
Microsoft MVP - XML
My blog
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
  #3 (permalink)  
Old May 26th, 2009, 01:45 PM
joefawcett's Avatar
Wrox Author
Points: 8,994, Level: 40
Points: 8,994, Level: 40 Points: 8,994, Level: 40 Points: 8,994, Level: 40
Activity: 11%
Activity: 11% Activity: 11% Activity: 11%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 2,922
Thanks: 0
Thanked 13 Times in 12 Posts
Default
I don't understand. Why can't you just use
Code:
<xsl:value-of select="/" >
to supply the whole document? One problem maybe dealing with quotation marks, but that would also affect other values you wish to insert.
__________________
--

Joe
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
  #4 (permalink)  
Old May 26th, 2009, 01:49 PM
mhkay's Avatar
Wrox Author
Points: 12,642, Level: 48
Points: 12,642, Level: 48 Points: 12,642, Level: 48 Points: 12,642, Level: 48
Activity: 97%
Activity: 97% Activity: 97% Activity: 97%
 
Join Date: Apr 2004
Location: Reading, Berks, United Kingdom.
Posts: 3,900
Thanks: 0
Thanked 80 Times in 78 Posts
Default
I think it would help if you showed us exactly what the input to your transformation looks like, and exactly what you want the output to look like.

Are you using method="xml" or method="text" for serializing the results?
__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
  #5 (permalink)  
Old May 26th, 2009, 01:50 PM
Registered User
Points: 19, Level: 1
Points: 19, Level: 1 Points: 19, Level: 1 Points: 19, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2009
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default
I'm using the following to parse my xslt script.

Code:
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.transform.Result;
import javax.xml.transform.Transformer;
import javax.xml.transform.stream.StreamResult;
import javax.xml.transform.stream.StreamSource;
Could you please provide me with basic example (xslt script inserting a blob object into the database).
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
  #6 (permalink)  
Old May 26th, 2009, 01:56 PM
Registered User
Points: 19, Level: 1
Points: 19, Level: 1 Points: 19, Level: 1 Points: 19, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2009
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default
This is my entire script:

Code:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.2" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:ota="http://www.opentravel.org/OTA/2003/05" xmlns:exslt="http://exslt.org/common">
	<xsl:output omit-xml-declaration="yes"/>
	<xsl:param name="profile"/>
	<xsl:variable name="profileNode" select="exslt:node-set($profile)"/>
	<xsl:template match="/">
	
		<xsl:apply-templates select="ota:OTA_TT_HotelResRS"/>
		<xsl:apply-templates select="ota:OTA_TT_CancelRS"/>
		<xsl:apply-templates select="ota:OTA_TT_HotelResModifyRS"/>
		
		<!-- *****************************************************************************************************-->

	<xsl:template match="ota:OTA_TT_HotelResRS">insert into booking 
	(createdBy, bookingNumber, created, modified, start, end, bookingType, hotelName, duration, numberOfPassengers, surname, status, touroperator, agency_code, departure3LC, arrival3LC, travelCode, totalPrice, bookXmlDoc) 
	values (
	"<xsl:value-of select="$profileNode/ota:OTA_TT_ProfileReadRS/ota:Profiles/ota:ProfileInfo/ota:UniqueID/@ID"/>",
	"<xsl:value-of select="ota:HotelReservations/ota:HotelReservation/ota:ResGlobalInfo/ota:HotelReservationIDs/ota:HotelReservationID/@ResID_Value"/>", 
	NULL, 
	NULL, 
	"<xsl:value-of select="ota:HotelReservations/ota:HotelReservation/ota:RoomStays/ota:RoomStay/ota:TimeSpan/@Start"/>", 
	"<xsl:value-of select="ota:HotelReservations/ota:HotelReservation/ota:RoomStays/ota:RoomStay/ota:TimeSpan/@End"/>", 
	"<xsl:value-of select="ota:HotelReservations/ota:HotelReservation/ota:ResGlobalInfo/ota:HotelReservationIDs/ota:HotelReservationID/@ResID_Type"/>",
	 "<xsl:value-of select="ota:HotelReservations/ota:HotelReservation/ota:RoomStays/ota:RoomStay/ota:BasicPropertyInfo/@HotelName"/>", 
	 "<xsl:value-of select="ota:HotelReservations/ota:HotelReservation/ota:RoomStays/ota:RoomStay/ota:TimeSpan/@Duration"/>", 
	"<xsl:value-of select="sum(ota:HotelReservations/ota:HotelReservation/ota:RoomStays/ota:RoomStay/ota:GuestCounts/ota:GuestCount/@Count)"/>", 
    "<xsl:value-of select="ota:HotelReservations/ota:HotelReservation/ota:ResGuests/ota:ResGuest/ota:Profiles/ota:ProfileInfo/ota:Profile/ota:Customer/ota:PersonName/ota:Surname"/>", 
	"<xsl:value-of select="@ResResponseType"/>", 
	"H4U",
	"<xsl:value-of select="$profileNode/ota:OTA_TT_ProfileReadRS/ota:Profiles/ota:ProfileInfo/ota:Profile/ota:CompanyInfo/ota:CompanyName/@Code"/>", <!-- **** -->
	NULL, <!-- dep unknown -->
	 "<xsl:value-of select="ota:HotelReservations/ota:HotelReservation/ota:RoomStays/ota:RoomStay/ota:BasicPropertyInfo/ota:Address/ota:CountryName"/>", <!-- arrival Hotel Country-->
	NULL, <!-- unknown -->
	 "<xsl:value-of select="ota:HotelReservations/ota:HotelReservation/ota:RoomStays/ota:RoomStay/ota:RoomRates/ota:RoomRate/ota:Rates/ota:Rate/ota:Total/@AmountAfterTax "/>" <!-- currency ?? -->
	)  
	</xsl:template>
	
		
	<!-- ############################################## -->
	<!-- ########    TEMPLATE FOR CANCELATION  ####### -->
	<!-- ############################################## -->
	<xsl:template match="ota:OTA_TT_CancelRS">
		<xsl:choose>
			<xsl:when test="count(ota:UniqueID) > 0">
				<xsl:call-template name="cancellation_general"/>
			</xsl:when>
			<xsl:when test="count(ota:CancelInfoRS/ota:UniqueID) > 0">
				<xsl:call-template name="cancellation_h4u"/>
			</xsl:when>
		</xsl:choose>
	</xsl:template>
	
   <xsl:template name="cancellation_h4u">update booking set
	 status="<xsl:value-of select="@Status"/>",
	 modified = NOW(),
	 created = created
	 where bookingNumber = "<xsl:value-of select="ota:CancelInfoRS/ota:UniqueID/@ID"/>"
	 and agency_code="999999"
	</xsl:template>	
	
	<xsl:template name="cancellation_general">update booking set
	 status="<xsl:value-of select="@Status"/>",
	 modified = NOW(),
	 created = created
	 where bookingNumber = "<xsl:value-of select="ota:UniqueID/@ID"/>"
	 and agency_code="<xsl:value-of select="$profileNode/ota:OTA_TT_ProfileReadRS/ota:Profiles/ota:ProfileInfo/ota:Profile/ota:CompanyInfo/ota:CompanyName/@Code"/>"
	</xsl:template>
	
	
	
	
</xsl:stylesheet>
And this is my input file:

Code:
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
	<soap:Body>
		<OTA_HotelResRS xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" TimeStamp="2008-05-27T10:09:09" Target="Production" Version="1" ResResponseType="Pending" xmlns="http://www.opentravel.org/OTA/2003/05">
			<Success/>
			<HotelReservations>
				<HotelReservation>
					<RoomStays>
						<RoomStay IsAlternate="false">
							<RoomTypes>
								<RoomType RoomTypeCode="144HB" NumberOfUnits="1">
									<RoomDescription>
										<Text>Twin Side Seaview - Half board</Text>
									</RoomDescription>
								</RoomType>
							</RoomTypes>
							<RoomRates>
								<RoomRate RoomTypeCode="144HB" NumberOfUnits="1">
									<Rates>
										<Rate>
											<Total AmountAfterTax="232.82" CurrencyCode="GBP"/>
										</Rate>
									</Rates>
								</RoomRate>
							</RoomRates>
							<GuestCounts IsPerRoom="true">
								<GuestCount AgeQualifyingCode="10" Count="2"/>
								<GuestCount AgeQualifyingCode="8" Count="1"/>
								<GuestCount AgeQualifyingCode="7" Count="1"/>
							</GuestCounts>
							<TimeSpan Start="2008-10-12" Duration="P3N"/>
							<BasicPropertyInfo HotelCode="6568" HotelName="Kapetanios Bay Hotel">
								<VendorMessages>
									<VendorMessage InfoType="4">
										<SubSection>
											<Paragraph>
												<Text>Please collect your keys from reception</Text>
											</Paragraph>
										</SubSection>
									</VendorMessage>
								</VendorMessages>
								<Address FormattedInd="false" DefaultInd="false">
									<AddressLine>POBox 33142</AddressLine>
									<AddressLine>Paralimni</AddressLine>
									<PostalCode>5311</PostalCode>
									<CountryName>Cyprus</CountryName>
								</Address>
								<ContactNumbers>
									<ContactNumber PhoneLocationType="4" PhoneTechType="1" PhoneNumber="00357 23 831 170" FormattedInd="false" DefaultInd="false"/>
								</ContactNumbers>
							</BasicPropertyInfo>
						</RoomStay>
					</RoomStays>
					<ResGuests>
						<ResGuest>
							<Profiles>
								<ProfileInfo>
									<Profile ShareAllSynchInd="No" ShareAllMarketInd="No">
										<Customer>
											<PersonName>
												<GivenName>A</GivenName>
												<Surname>Test</Surname>
												<NameTitle>MR</NameTitle>
											</PersonName>
											<Address FormattedInd="false" DefaultInd="false">
												<AddressLine>Test Street</AddressLine>
												<CityName>Test City</CityName>
												<PostalCode>TE5 T11</PostalCode>
											</Address>
										</Customer>
									</Profile>
								</ProfileInfo>
							</Profiles>
						</ResGuest>
					</ResGuests>
					<ResGlobalInfo>
						<HotelReservationIDs>
							<HotelReservationID ResID_Type="23" ResID_Value="WS25"/>
						</HotelReservationIDs>
					</ResGlobalInfo>
				</HotelReservation>
			</HotelReservations>
		</OTA_HotelResRS>
	</soap:Body>
</soap:Envelope>
I'm extractign few fields from teh above file and also WANT to store the entire xml tree as an object into the database (mysql).

Thanks
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
  #7 (permalink)  
Old May 26th, 2009, 02:01 PM
Registered User
Points: 19, Level: 1
Points: 19, Level: 1 Points: 19, Level: 1 Points: 19, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2009
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default
Sorry the above input file is not 100% correct. Following is the one, I'm using as input:

Code:
<?xml version="1.0" encoding="UTF-8"?>
<OTA_TT_HotelResRS xmlns="http://www.opentravel.org/OTA/2003/05" TimeStamp="2008-05-27T10:09:09" Target="Production" Version="1" ResResponseType="">
	<Success/>
	<HotelReservations>
		<HotelReservation>
			<RoomStays>
				<RoomStay>
					<RoomTypes>
						<RoomType RoomTypeCode="144HB" NumberOfUnits="1">
							<RoomDescription>
								<Text>Twin Side Seaview - Half board</Text>
							</RoomDescription>
						</RoomType>
					</RoomTypes>
					<RoomRates>
						<RoomRate RoomTypeCode="144HB" NumberOfUnits="1">
							<Rates>
								<Rate>
									<Total AmountAfterTax="232.82" CurrencyCode="GBP"/>
								</Rate>
							</Rates>
						</RoomRate>
					</RoomRates>
					<GuestCounts IsPerRoom="true">
						<GuestCount AgeQualifyingCode="10" Count="2"/>
						<GuestCount AgeQualifyingCode="8" Count="1"/>
						<GuestCount AgeQualifyingCode="7" Count="1"/>
					</GuestCounts>
					<TimeSpan Start="2008-10-12" Duration="P3N" End="2008-10-15"/>
					<BasicPropertyInfo HotelCode="6568" HotelName="Kapetanios Bay Hotel">
						<VendorMessages>
							<VendorMessage InfoType="4">
								<SubSection>
									<Paragraph>
										<Text>Please collect your keys from reception</Text>
									</Paragraph>
								</SubSection>
							</VendorMessage>
						</VendorMessages>
						<Address FormattedInd="false" DefaultInd="false">
							<AddressLine>POBox 33142</AddressLine>
							<AddressLine>Paralimni</AddressLine>
							<PostalCode>5311</PostalCode>
							<CountryName>Cyprus</CountryName>
						</Address>
						<ContactNumbers>
							<ContactNumber PhoneLocationType="4" PhoneTechType="1" PhoneNumber="00357 23 831 170" FormattedInd="false" DefaultInd="false"/>
						</ContactNumbers>
					</BasicPropertyInfo>
				</RoomStay>
			</RoomStays>
			<ResGuests>
				<ResGuest>
					<Profiles>
						<ProfileInfo>
							<Profile ShareAllSynchInd="No" ShareAllMarketInd="No">
								<Customer>
									<PersonName>
										<GivenName>A</GivenName>
										<Surname>Test</Surname>
										<NameTitle>MR</NameTitle>
									</PersonName>
									<Address FormattedInd="false" DefaultInd="false">
										<AddressLine>Test Street</AddressLine>
										<CityName>Test City</CityName>
										<PostalCode>TE5 T11</PostalCode>
									</Address>
								</Customer>
							</Profile>
						</ProfileInfo>
					</Profiles>
				</ResGuest>
			</ResGuests>
			<ResGlobalInfo>
				<HotelReservationIDs>
					<HotelReservationID ResID_Type="23" ResID_Value=""/>
				</HotelReservationIDs>
			</ResGlobalInfo>
		</HotelReservation>
	</HotelReservations>
</OTA_TT_HotelResRS>
Transformation script is mainly responsible for generating an insert script, which requires some change to handle blob object as well. I think the script should generate the query execution code as well..through java statement as part of xslt script, but i'm not 100% sure how.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
  #8 (permalink)  
Old May 26th, 2009, 02:36 PM
Registered User
Points: 19, Level: 1
Points: 19, Level: 1 Points: 19, Level: 1 Points: 19, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2009
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default
I have changed my script the following:

Code:
..
..

	 "<xsl:value-of select="ota:HotelReservations/ota:HotelReservation/ota:RoomStays/ota:RoomStay/ota:RoomRates/ota:RoomRate/ota:Rates/ota:Rate/ota:Total/@AmountAfterTax "/>", <!-- currency ?? -->


		<xsl:element name="{local-name()}">
			<xsl:apply-templates select="@*|*|text()"/>
		</xsl:element>
	)  
	</xsl:template>
 
	
<xsl:template match="ota:*">
		<xsl:element name="{local-name()}">
			<xsl:apply-templates select="@*|*|text()"/>
		</xsl:element>
	</xsl:template>
	<xsl:template match="@*">
		<xsl:copy-of select="."/>
	</xsl:template>
Which yields this output:

Code:
insert into booking 
	(createdBy, bookingNumber, created, modified, start, end, bookingType, hotelName, duration, numberOfPassengers, surname, status, touroperator, agency_code, departure3LC, arrival3LC, travelCode, totalPrice, bookXmlDoc) 
	values (
	"",
	"", 
	NULL, 
	NULL, 
	"2008-10-12", 
	"2008-10-15", 
	"23",
	 "Kapetanios Bay Hotel", 
	 "P3N", 
	"4", 
    "Test", 
	"", 
	"H4U",
	"", 
	NULL, 
	 "Cyprus", 
	NULL, 
	 "232.82", 


		<OTA_TT_HotelResRS TimeStamp="2008-05-27T10:09:09" Target="Production" Version="1" ResResponseType="">
	<Success/>
	<HotelReservations>
		<HotelReservation>
			<RoomStays>
				<RoomStay>
					<RoomTypes>
						<RoomType RoomTypeCode="144HB" NumberOfUnits="1">
							<RoomDescription>
								<Text>Twin Side Seaview - Half board</Text>
							</RoomDescription>
						</RoomType>
					</RoomTypes>
					<RoomRates>
						<RoomRate RoomTypeCode="144HB" NumberOfUnits="1">
							<Rates>
								<Rate>
									<Total AmountAfterTax="232.82" CurrencyCode="GBP"/>
								</Rate>
							</Rates>
						</RoomRate>
					</RoomRates>
					<GuestCounts IsPerRoom="true">
						<GuestCount AgeQualifyingCode="10" Count="2"/>
						<GuestCount AgeQualifyingCode="8" Count="1"/>
						<GuestCount AgeQualifyingCode="7" Count="1"/>
					</GuestCounts>
					<TimeSpan Start="2008-10-12" Duration="P3N" End="2008-10-15"/>
					<BasicPropertyInfo HotelCode="6568" HotelName="Kapetanios Bay Hotel">
						<VendorMessages>
							<VendorMessage InfoType="4">
								<SubSection>
									<Paragraph>
										<Text>Please collect your keys from reception</Text>
									</Paragraph>
								</SubSection>
							</VendorMessage>
						</VendorMessages>
						<Address FormattedInd="false" DefaultInd="false">
							<AddressLine>POBox 33142</AddressLine>
							<AddressLine>Paralimni</AddressLine>
							<PostalCode>5311</PostalCode>
							<CountryName>Cyprus</CountryName>
						</Address>
						<ContactNumbers>
							<ContactNumber PhoneLocationType="4" PhoneTechType="1" PhoneNumber="00357 23 831 170" FormattedInd="false" DefaultInd="false"/>
						</ContactNumbers>
					</BasicPropertyInfo>
				</RoomStay>
			</RoomStays>
			<ResGuests>
				<ResGuest>
					<Profiles>
						<ProfileInfo>
							<Profile ShareAllSynchInd="No" ShareAllMarketInd="No">
								<Customer>
									<PersonName>
										<GivenName>A</GivenName>
										<Surname>Test</Surname>
										<NameTitle>MR</NameTitle>
									</PersonName>
									<Address FormattedInd="false" DefaultInd="false">
										<AddressLine>Test Street</AddressLine>
										<CityName>Test City</CityName>
										<PostalCode>TE5 T11</PostalCode>
									</Address>
								</Customer>
							</Profile>
						</ProfileInfo>
					</Profiles>
				</ResGuest>
			</ResGuests>
			<ResGlobalInfo>
				<HotelReservationIDs>
					<HotelReservationID ResID_Type="23" ResID_Value=""/>
				</HotelReservationIDs>
			</ResGlobalInfo>
		</HotelReservation>
	</HotelReservations>
</OTA_TT_HotelResRS>
	)

How can I make the last xml column as just simple text, just like other columns?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
Reply

« Previous Thread | Next Thread »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
BLOB: file is empty after retrieving blob data thr taraprasad Pro JSP 0 May 22nd, 2008 11:02 AM
ole object insertion vinodkselpy Crystal Reports 0 March 1st, 2007 07:31 AM
insertion of records in database MunishBhatia SQL Server 2005 1 December 12th, 2006 09:25 PM
BLOB - Uploading images into a database jcivitello PHP Databases 1 March 10th, 2006 09:02 PM
Datagrid update, dropdownlist database insertion herman ASP.NET 1.0 and 1.1 Professional 2 October 11th, 2003 02:31 AM



All times are GMT -4. The time now is 01:22 PM.

Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
© 2008 Wiley Publishing, Inc