Analysis Server Database has errors. Cant delete, can't view

I tried to import a abf file in my Analysis Services using the wizard. It didn't succeed completely as I ran out of disk space. However it left my AS database in inconsistent state. I can't view anything. Can't delete anything. The entire AS is unusable at the moment. I get the following error.

"Errors in metadata manager. The dimension with ID of v_Contract, Name of Contract referenced by 'GPC GL Cube' does not exist......"

Please let me know how to restore my AS so that I can retry importing the database.

Thanks,

Ashish

I was able to remove the database. I had to stop the AS and delete the physical folders. Then restarted the AS and I was able to delete the Databases.

Hope this helps someone else because I spent some time trying to figure this out.

Ashish

An attempt to attach an auto-named database for file failed.

Hi,

I recently installed VS Web Developer Express Ediition and SQL Server Express and I'm doing the How To tutorials and I can't finish the basic data access walkthrough:

http://msdn2.microsoft.com/en-US/library/tw738475.aspx

Because I get an error like this (link for complete error below):

An attempt to attach an auto-named database for file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

http://pastecode.com/6196

When I am setting up the data source for the gridview tool, everything works fine and the test query works fine, but then when I try to actually test the output in the browser with Cntrl+F5 I get this error.

I have been trying for 48 hours to find a solution on my own. I have googled, I have searched everything and I just am at a point where I think I need to ask someone for help.

Please help.

Make sure the file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test.mdf failedis not being used by other process. If it is the data file of some database in the SQL instance, you can't attach it by using AttachDBFileName property in the connection string.|||How do I do make sure it's not being used by an other process?|||

In other words, make sure it has not been attached in any SQL instance, and no other application is using it to create a connection.

|||

Thanks for your help so far.

But, how do I do that? How can I tell if another application is using 'it' to create a connection? I am using Visual Web Developer and SQL Server Management Studio Express and SQL Server Configuration Manager. Also when I hit 'Cntrl+F5' while in Visual Web Developer the page opens up in Firefox (my default browser).

I am not using the database for anything else. I have no idea how to monitor SQL instances. I am just beginning to learn these things and am working with tutorials that aren't working for me.

|||

First of all, you aren't crazy or a no brained soul. This is not you. This is quirkiness in how Microsoft (and I am their biggest fan), in trying to make things easier, has somehow made CHANGES to your SQL environment difficult. I am working on sorting this out and creating some kind of a flow chart to troubleshoot all of this, but here are some insights in the meantime (Gurus - please correct me where I am wrong on any of this):

* ASPNETDB.MDF seems to occur for every ASP.NET application and should appear in the |DataDirectory| - which is normally(?/automatically?) APP_DATA

* I think it gets automatically created the first time you run your app (because it seems to me to not be there, then suddenly appear) but it may be under program control - I don't know

* if you have an instance that has been named ASPNETDB or ASPNETDB.MDF in your Sql database, connecting a new one will fail as a duplicate, so use Sql Management Studio to rename any such instances to something unique, like "c:\Webs\PartnerPortal\Northwind Traders\App_Data\ASPNETDB.MDF" instead of just "ASPNETDB.MDF"

* In my environment I have several named instances of Sql Server, including: "STARTEAM" (a Borland created named instance), "OFFICESERVER" "SQLEXPRESS" "MSSQLSERVER" and "MICROSOFT##SSEE" (Mobile edition). However, none of these are useful to me. I have uninstalled SQLSERVER (SQL 2000) and SQLEXPRESS. The one I NEED does not appear - which is the unnamed instance - SQL Enterprise 2005. To access that all I do is enter the server name, ip or .\

* I was using Microsoft Expression Web to edit the default connection string (and this is identical in Server Explorer in VS 2005 also). It asks you the provider. I was using the defaul and could not enter .\ as my Sql Server. I only had the other useless named instances and could not successfully connect. SOOOO I changed the provider. I had two choices:

"Microsoft Sql Server" and "Microsoft Sql Server Database File" (along with "Sql Server Mobile Editiion", etc).

* I changed my selection FROM "Microsoft Sql Server" TO "Microsoft Sql Server Database File". This allowed me to edit the server to be .\ when I went back to my connection string

* Then I changed the provider BACK and now I had the choice I needed! I think that the choice are coming from the registry and it got out of sync

Anyway, now I can connect. I think that connectionString updates the registry, where the problems lie.

*************************************************
Here is the skinny on troubleshooting connections:
*************************************************

(1) have you run aspnet_regsql from a command prompt at the c:\windows\Microsoft.net Framework v2xxx directory?

(2) did you create a virtual directory for your app and enable Asp?
(I have a separate memory pool for each version of Asp - another matter)

(3) did you change the Asp settings to the right connection string? The important things are: .\SQLEXPRESS or .\ or your named instance. If you do not use SQLEXPRESS then User Instance must be False

(4) are all of your instances of ASPNETDB.mdf named uniquely? (Ie: include a path)

(5) does IIS_WPG have sufficient rights to your web directory (this may not be true if you put your webs in your "My Documents")

(6) In VS2005, did you go to Websited-Asp config?

(7) Do you have the right settings in your Web.config?

(8) You must not have extraneous copies of Web.config on your path - they will be automatically referenced in the project. Ie, creating a backup in a subdir, is trouble.

(9) did you set your Default.aspx as the Startup page? (and the right project as the startup project if you have multiple projects?)

(10) did you use Server Explorer to try a different provider, update the registry choices of servers and to include your unnamed instance, per above?

Does Machine.config figure into this?

What have I missed or misstated?

To be honest, having done all of this, I still seem to have a web that I am still troubleshooting the connection for!

****
If anyone can correct, add or improve on the above, please do. What i would love to see is a Visio flowchart in a .pdf that could be emblazoned here. I can be reached at my gmail account of norisksoftware at gmail . com
AND I am looking for contract work doing almost anything technical (web, C#, consulting, Cobol, EDI..) that pays well. I was out of the country for 2 1/2 years and my business kind of dried up. Go figure.

Bill Ross

|||Hi Bill, by default .NET 2.0 security providers(membership, profile, ect.) use a connection string named LocalSqlServer, to learn more details you can take a look at this article:

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

AMO: Can''t update dsv when delete a column

Hi, friends, please have a look at this:

I am using AMO, and I do this:

1 step: I drop a column from the source table by SQL:

ALTER TABLE TargetTable Drop COLUMN ColumnName

2 step: I try to update the dsv by AMO:

Dim adapter As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter( _
"SELECT * FROM [dbo].[" + tableName + "] WHERE 1=0", connection)
Dim i As Integer

For i = 0 To dsv.Schema.Tables.Count - 1
If dsv.Schema.Tables(i).TableName = "dbo_" & tableName Then
MessageBox.Show("Before dsv.Schema.Tables.Count:" & dsv.Schema.Tables(i).Columns.Count)
Dim dataTable As DataTable = adapter.FillSchema(dsv.Schema.Tables(i), SchemaType.Mapped)
MessageBox.Show("After dsv.Schema.Tables.Count:" & dsv.Schema.Tables(i).Columns.Count)
End If

Next

But, from the first messagebox and the second messagebox, I see the dsv is not updated after I delete the column.

3 step: I save the dsv to the server.

If Mainform.tDatabase.DataSourceViews.Count > 0 Then
Mainform.tDatabase.DataSourceViews(0).Update(Microsoft.AnalysisServices.UpdateOptions.ExpandFull)
End If

Then I check the server, the dsv still include the columnname I have deleted.

Why and how to update the dsv after I delete a column?

Thanks!

ivanchain wrote:

Dim dataTable As DataTable = adapter.FillSchema(dsv.Schema.Tables(i), SchemaType.Mapped)

ivanchain wrote:

But, from the first messagebox and the second messagebox, I see the dsv is not updated after I delete the column

Let's also check if the returned 'dataTable' still contains the column you deleted. If it does contain the column, then we need to double check the table name and its columns in SQL Server.If the returned 'dataTable' doesn't contain the column, it looks like you need to replace the table in the DSV with this returned 'dataTable', but according to documentation at http://msdn2.microsoft.com/en-us/library/152bda9x.aspx, this should not be the case.

The rest of the code looks good, the problem is not in AMO, but in the FillSchema area.

Adrian Dumitrascu

|||

I tried what you said:

Let's also check if the returned 'dataTable' still contains the column you deleted. If it does contain the column, then we need to double check the table name and its columns in SQL Server.

Yes, the returned 'dataTable' still contains the column I deleted. But I don't know what you exactly mean of DOUBLE CHECK the table name and its columns in SQL Server? I need to check what?

Thank you!

|||

The problem is still there.... help!

thanks.

|||

The only ideas that I have are:

- double check that the database name (that you use in the code) is the same with the database on which you removed the column from the table. There might be a concidence that you have 2 databases containing the same table name and column name, you deleted from one, but the code works on the other database by chance (since I don't see in the code where you explicitly chose the database on which to run the SELECT statement)

- double check that the name and the schema, 'dbo', of the table you use in the code are the same as the schema and the name of the table from which you deleted the column

|||

Thanks, Adrian. But, I don't think it's about the NAME of the table. Because my code could update dsv when I add a column into the SQL table in the SQL Server. If the name of the table is wrong, it will also not update when adding, right?

Thanks!

AMO: Can't update dsv when delete a column

Hi, friends, please have a look at this:

I am using AMO, and I do this:

1 step: I drop a column from the source table by SQL:

ALTER TABLE TargetTable Drop COLUMN ColumnName

2 step: I try to update the dsv by AMO:

Dim adapter As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter( _
"SELECT * FROM [dbo].[" + tableName + "] WHERE 1=0", connection)
Dim i As Integer

For i = 0 To dsv.Schema.Tables.Count - 1
If dsv.Schema.Tables(i).TableName = "dbo_" & tableName Then
MessageBox.Show("Before dsv.Schema.Tables.Count:" & dsv.Schema.Tables(i).Columns.Count)
Dim dataTable As DataTable = adapter.FillSchema(dsv.Schema.Tables(i), SchemaType.Mapped)
MessageBox.Show("After dsv.Schema.Tables.Count:" & dsv.Schema.Tables(i).Columns.Count)
End If

Next

But, from the first messagebox and the second messagebox, I see the dsv is not updated after I delete the column.

3 step: I save the dsv to the server.

If Mainform.tDatabase.DataSourceViews.Count > 0 Then
Mainform.tDatabase.DataSourceViews(0).Update(Microsoft.AnalysisServices.UpdateOptions.ExpandFull)
End If

Then I check the server, the dsv still include the columnname I have deleted.

Why and how to update the dsv after I delete a column?

Thanks!

ivanchain wrote:

Dim dataTable As DataTable = adapter.FillSchema(dsv.Schema.Tables(i), SchemaType.Mapped)

ivanchain wrote:

But, from the first messagebox and the second messagebox, I see the dsv is not updated after I delete the column

Let's also check if the returned 'dataTable' still contains the column you deleted. If it does contain the column, then we need to double check the table name and its columns in SQL Server.If the returned 'dataTable' doesn't contain the column, it looks like you need to replace the table in the DSV with this returned 'dataTable', but according to documentation at http://msdn2.microsoft.com/en-us/library/152bda9x.aspx, this should not be the case.

The rest of the code looks good, the problem is not in AMO, but in the FillSchema area.

Adrian Dumitrascu

|||

I tried what you said:

Let's also check if the returned 'dataTable' still contains the column you deleted. If it does contain the column, then we need to double check the table name and its columns in SQL Server.

Yes, the returned 'dataTable' still contains the column I deleted. But I don't know what you exactly mean of DOUBLE CHECK the table name and its columns in SQL Server? I need to check what?

Thank you!

|||

The problem is still there.... help!

thanks.

|||

The only ideas that I have are:

- double check that the database name (that you use in the code) is the same with the database on which you removed the column from the table. There might be a concidence that you have 2 databases containing the same table name and column name, you deleted from one, but the code works on the other database by chance (since I don't see in the code where you explicitly chose the database on which to run the SELECT statement)

- double check that the name and the schema, 'dbo', of the table you use in the code are the same as the schema and the name of the table from which you deleted the column

|||

Thanks, Adrian. But, I don't think it's about the NAME of the table. Because my code could update dsv when I add a column into the SQL table in the SQL Server. If the name of the table is wrong, it will also not update when adding, right?

Thanks!

Always get null, can't return results

Please, Please, Please help. I tried a million different
ways of doing this and I can't get results, I always get
no results or NULL. I just want a node, just one node,
anything.
use telnform
SELECT bidData.query('
declare default element namespace=
"http://www.rfpexpress.com"
for $propCode in /X_NBTA05/PB/PROPCODE
return $propCode
')
FROM tblBidXMLData
USE [TelnForm]
GO
/****** Object: Table [dbo].[tblBidXMLData] Script
Date: 12/20/2004 11:48:10 ******/
SET ANSI_NULLS ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblBidXMLData](
[BidID] [int] NOT NULL,
[bidData] [xml] NULL,
[CorpID] [int] NOT NULL,
[CorpRFPNumber] [varchar](25) COLLATE
SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PropID] [int] NOT NULL,
[AutoSubmit] [bit] NOT NULL,
[ValidationErrors] [int] NULL,
[NamId] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS OFF
- <ns0:X_NBTA05 xmlns:ns0="http://www.rfpexpress.com"
xmlns:ns1="http://www.rfpexpress.com/Global">
- <ns0:PB>
<PROPCODE>34991</PROPCODE>
<PROPNAME>RFP Express Test Property - Product
Development</PROPNAME>
<PROPADD1>8989 Rio San Diego Dr11</PROPADD1>
<PROPADD2 />
<PROPCITY>Ixataville</PROPCITY>
<PROPSTATEPROV>CA</PROPSTATEPROV>
<PROPCOUNTRY>United States</PROPCOUNTRY>
<PROPPOSTCODE>99998</PROPPOSTCODE>
<MAINPHONECOUNTRY />
<MAINPHONECITY>619</MAINPHONECITY>
<MAINPHONE>4008840</MAINPHONE>
<MAINFAXCOUNTRY />
<MAINFAXCITY>619</MAINFAXCITY>
<MAINFAX>4008819</MAINFAX>
<UNITOFMEAS>MI</UNITOFMEAS>
<PROPURL>1</PROPURL>
<FULL_OR_LIM>L</FULL_OR_LIM>
<ES_STAY>Y</ES_STAY>
<MKT_TIER>L</MKT_TIER>
<AAADIAM_RATE>1</AAADIAM_RATE>
<MOBILSTAR_RATE>NA</MOBILSTAR_RATE>
<OHG_CLASS>Tourist</OHG_CLASS>
<YRBUILT>1952</YRBUILT>
<LASTREN>1234</LASTREN>
<NUMROOMS>555</NUMROOMS>
<NUMNOSMK>1</NUMNOSMK>
<NUMFLRS>45</NUMFLRS>
<MGMTCOMPANY>Gene Kaliman</MGMTCOMPANY>
<OWNERCOMPANY>Gene Kaliman</OWNERCOMPANY>
<MIN_OWNED_CERT>Y</MIN_OWNED_CERT>
<WMN_OWNED_CERT>N</WMN_OWNED_CERT>
<ADACOMPLY>N</ADACOMPLY>
<PROP_LOC>T</PROP_LOC>
<PROPOVERVIEW>Luxury hotel located in the heart of
downtown San Diego. Lovely view of the
harbor.</PROPOVERVIEW>
<AMEXCARD>Y</AMEXCARD>
<DINERSCARD>Y</DINERSCARD>
<DISCOVERCARD>Y</DISCOVERCARD>
<JCBCARD>Y</JCBCARD>
<MASTERCARD>Y</MASTERCARD>
<VISACARD>Y</VISACARD>
<AMADEUS_CHAINCODE>67</AMADEUS_CHAINCODE>
<AMADEUS_PROPCODE>555a</AMADEUS_PROPCODE>
<APOLLO_CHAINCODE>12</APOLLO_CHAINCODE>
<APOLLO_PROPCODE />
<SABRE_CHAINCODE>14</SABRE_CHAINCODE>
<SABRE_PROPCODE>15a</SABRE_PROPCODE>
<WORLDSPAN_CHAINCODE>56</WORLDSPAN_CHAINCODE>
<WORLDSPAN_PROPCODE />
<MASTERCHAINCODE>AS</MASTERCHAINCODE>
</ns0:PB>
- <ns0:CS>
<TEMPLATE_NAME>Consortia</TEMPLATE_NAME>
<OFFICENAME />
<OFFICEADD1 />
<RN_TARGET>N</RN_TARGET>
<RATE_CURR>USD</RATE_CURR>
<COMMISIONABLE>N</COMMISIONABLE>
<COMM_PCT_CLIENT />
<COMM_PCT_CONS />
<LOAD_GDS>Y</LOAD_GDS>
<WALK_HOTEL>N</WALK_HOTEL>
<WALK_TAX>N</WALK_TAX>
<WALK_TRANS>N</WALK_TRANS>
<WALK_CALL>N</WALK_CALL>
<CANC_POL>24hr</CANC_POL>
<EARLYCK_FEE>0</EARLYCK_FEE>
<EARLYCK_UOM>F</EARLYCK_UOM>
<EARLYCK_INCLUDE>N</EARLYCK_INCLUDE>
<LODGTX_FEE>13</LODGTX_FEE>
<LODGTX_UOM>P</LODGTX_UOM>
<LODGTX_INCLUDE>N</LODGTX_INCLUDE>
<STATETX_FEE>23</STATETX_FEE>
<STATETX_UOM>P</STATETX_UOM>
<STATETX_INCLUDE>Y</STATETX_INCLUDE>
<CITYTX_FEE>34</CITYTX_FEE>
<CITYTX_UOM>P</CITYTX_UOM>
<CITYTX_INCLUDE>N</CITYTX_INCLUDE>
<VATGST_FEE>45</VATGST_FEE>
<VATGST_UOM>P</VATGST_UOM>
<VATGST_INCLUDE>Y</VATGST_INCLUDE>
<SERVICE_FEE>56</SERVICE_FEE>
<SERVICE_UOM>P</SERVICE_UOM>
<SERVICE_INCLUDE>N</SERVICE_INCLUDE>
<OCC_FEE>76</OCC_FEE>
<OCC_UOM>P</OCC_UOM>
<OCC_INCLUDE>Y</OCC_INCLUDE>
<PARK_FEE>5</PARK_FEE>
<PARK_INCLUDE>N</PARK_INCLUDE>
<BREAK_FEE />
<BREAK_INCLUDE>N</BREAK_INCLUDE>
<FITNESS_FEE_ON>234</FITNESS_FEE_ON>
<FITNESS_INCLUDE_ON>N</FITNESS_INCLUDE_ON>
<FITNESS_FEE_OFF>0</FITNESS_FEE_OFF>
<FITNESS_INCLUDE_OFF>N</FITNESS_INCLUDE_OFF>
<HSIA_FEE>0</HSIA_FEE>
<HSIA_INCLUDE>N</HSIA_INCLUDE>
<WIRELESS_FEE>0</WIRELESS_FEE>
<WIRELESS_INCLUDE>N</WIRELESS_INCLUDE>
<COMP_INFAX>N</COMP_INFAX>
<COMP_OUTFAX>N</COMP_OUTFAX>
<AIRTRANS_FEE>0</AIRTRANS_FEE>
<AIRTRANS_INCLUDE>N</AIRTRANS_INCLUDE>
<OFFTRANS_FEE>0</OFFTRANS_FEE>
<OFFTRANS_INCLUDE>Y</OFFTRANS_INCLUDE>
<RATE_SUBS>N</RATE_SUBS>
<RATE_PERSO>N</RATE_PERSO>
<RATE_CONSU>N</RATE_CONSU>
<RATE_RETIR>N</RATE_RETIR>
<RFP_CONTRACT>Y</RFP_CONTRACT>
<PROPSALESCONT>gene kaliman</PROPSALESCONT>
<PROPSALESTITLE>Director of Programming</PROPSALESTITLE>
<PROPSALESPHONECOUNTRY>1</PROPSALESPHONECOUNTRY>
<PROPSALESPHONECITYCODE>619</PROPSALESPHONECITYCODE>
<PROPSALESPHONE>400-88412</PROPSALESPHONE>
<PROPSALESFAXCOUNTRYCODE />
<PROPSALESFAXCITYCODE>6193</PROPSALESFAXCITYCODE>
<PROPSALESFAX>400-88194</PROPSALESFAX>
<PROPSALESEMAIL>cirquedusoul@.cyberianrealty.net</PROPSALESE
MAIL>
<RFP_NAME>gene kaliman</RFP_NAME>
<RFP_TITLE>Director of Programming</RFP_TITLE>
<RFP_PHONECOUNTRYCODE>1</RFP_PHONECOUNTRYCODE>
<RFP_PHONECITYCODE>619</RFP_PHONECITYCODE>
<RFP_PHONE>400-88412</RFP_PHONE>
<RFP_EMAIL>cirquedusoul@.cyberianrealty.net</RFP_EMAIL>
<RFP_DATESUBMIT>2004-07-13</RFP_DATESUBMIT>
- <ns0:ROOM_TYPES>
<ROOMTYPEDEFINE>Standard</ROOMTYPEDEFINE>
<ROOMTYPENUMBER>0</ROOMTYPENUMBER>
</ns0:ROOM_TYPES>
- <ns0:ROOM_TYPES>
<ROOMTYPEDEFINE>Upgrade</ROOMTYPEDEFINE>
<ROOMTYPENUMBER>0</ROOMTYPENUMBER>
</ns0:ROOM_TYPES>
- <ns0:SEASON_RATES>
<SEASON_START>2002-01-01</SEASON_START>
<SEASON_END>2002-12-31</SEASON_END>
- <ns0:ROOM_RATES>
<ROOM_TYPE_NUM>1</ROOM_TYPE_NUM>
<RACK_SGL />
<RACK_DBL />
<CORP_SGL />
<CORP_DBL />
<LRA_SGL>123</LRA_SGL>
<LRA_DBL>123</LRA_DBL>
<NLRA_SGL />
<NLRA_DBL />
<CONS_SGL />
<CONS_DBL />
<GOVT_SGL />
<GOVT_DBL />
</ns0:ROOM_RATES>
- <ns0:ROOM_RATES>
<ROOM_TYPE_NUM>2</ROOM_TYPE_NUM>
<RACK_SGL />
<RACK_DBL />
<CORP_SGL />
<CORP_DBL />
<LRA_SGL>234</LRA_SGL>
<LRA_DBL>234</LRA_DBL>
<NLRA_SGL />
<NLRA_DBL />
<CONS_SGL />
<CONS_DBL />
<GOVT_SGL />
<GOVT_DBL />
</ns0:ROOM_RATES>
</ns0:SEASON_RATES>
</ns0:CS>
- <ns0:SA>
<REST_ONSITE>Y</REST_ONSITE>
<LOUNGE_BAR>N</LOUNGE_BAR>
<REST_MEALSBK>Y</REST_MEALSBK>
<REST_MEALSLUN>N</REST_MEALSLUN>
<REST_MEALSDIN>Y</REST_MEALSDIN>
<RM_SRV_AVL>N</RM_SRV_AVL>
<RM_SRV_HRS>01:00-08:01</RM_SRV_HRS>
<RECEPTION>N</RECEPTION>
<RECEPT_DAYS>Monday</RECEPT_DAYS>
<GIFT_NEWS>Y</GIFT_NEWS>
<CONVENENCE_FOOD>N</CONVENENCE_FOOD>
<GROCERY_SVC>Y</GROCERY_SVC>
<CASH_ONSITE>N</CASH_ONSITE>
<FITON_CENT>Y</FITON_CENT>
<FITON_TYPE />
<FITOFF_CENT>Y</FITOFF_CENT>
<FITOFF_TYPE>E</FITOFF_TYPE>
<REC_COURT>N</REC_COURT>
<CONC_SERV>N</CONC_SERV>
<BUS_CENTER>Y</BUS_CENTER>
<BUS_SERV>Y</BUS_SERV>
<IN_POOL>N</IN_POOL>
<OUT_POOL>Y</OUT_POOL>
<WHIRLPOOL>Y</WHIRLPOOL>
<SAUNA>Y</SAUNA>
<VIDEO_RENT>N</VIDEO_RENT>
<PARKING>N</PARKING>
<VALET_PARKING>N</VALET_PARKING>
<DAILY_PARK_FEE>5</DAILY_PARK_FEE>
<PARKFEE_MANAGED_HOTEL>N</PARKFEE_MANAGED_HOTEL>
<STORAGE>N</STORAGE>
<STORAGE_FEE />
<SAFEBOX>Y</SAFEBOX>
<LAUN_DRY>Y</LAUN_DRY>
<LAUNDRY_SITE>Y</LAUNDRY_SITE>
<LAUNDRY_HOURS>00:00 - 23:58</LAUNDRY_HOURS>
<IRON_BOARD>N</IRON_BOARD>
<HAIR_DRY>N</HAIR_DRY>
<ALM_CLOCK />
<TV_CABLE>N</TV_CABLE>
<TV_MOVIE>N</TV_MOVIE>
<STEREO>N</STEREO>
<VCR>N</VCR>
<DVD>N</DVD>
<MINI_FRIG>N</MINI_FRIG>
<MICRO>N</MICRO>
<COFF_TEA>N</COFF_TEA>
<MINIBAR>N</MINIBAR>
<PRESS>N</PRESS>
<WORKDESK>N</WORKDESK>
<NEWS_PAP>N</NEWS_PAP>
<BATHROBE>N</BATHROBE>
<SOFA_BED>N</SOFA_BED>
<IN_SAFE>N</IN_SAFE>
<SAFE_CHG>0</SAFE_CHG>
<AIR_CONDITIONED>N</AIR_CONDITIONED>
<IN_SELF_TEMP>N</IN_SELF_TEMP>
<PRIVATE_BATHSA>Y</PRIVATE_BATHSA>
<STOVE>N</STOVE>
<OVEN>N</OVEN>
<TOASTER>N</TOASTER>
<REFRIGERATOR>N</REFRIGERATOR>
<DISHWASHER>N</DISHWASHER>
<DINING_WARE>N</DINING_WARE>
<DISHES>N</DISHES>
<HOUSEKEEPING>W</HOUSEKEEPING>
<HOUSE_FULL_OR_LIM>L</HOUSE_FULL_OR_LIM>
<FRNT_DESK>00:00 - 23:57</FRNT_DESK>
</ns0:SA>
- <ns0:SS>
<ROOMSMKDET>Y</ROOMSMKDET>
<HALLSMKDET>NA</HALLSMKDET>
<PUBSMKDET>N</PUBSMKDET>
<HRDWIREDET>N</HRDWIREDET>
<FIRE_EXTIN>Y</FIRE_EXTIN>
<EMRGCYLITE>N</EMRGCYLITE>
<VENT_STAIR>N</VENT_STAIR>
<EVACPLAN>Y</EVACPLAN>
<FIRELAWS>N</FIRELAWS>
<VIS_ALARM>N</VIS_ALARM>
<HALLVIS_ALARM>NA</HALLVIS_ALARM>
<PUBVIS_ALARM>NA</PUBVIS_ALARM>
<AUD_ALARM>Y</AUD_ALARM>
<HALLAUD_ALARM>NA</HALLAUD_ALARM>
<PUBAUD_ALARM>NA</PUBAUD_ALARM>
<ROOMSPRINK>N</ROOMSPRINK>
<HALLSPRINK>N</HALLSPRINK>
<PUBSPRINK>N</PUBSPRINK>
<EMRGCYINFO>N</EMRGCYINFO>
<FIRE_LINK>N</FIRE_LINK>
<MULT_EXITS>Y</MULT_EXITS>
<AUTO_RECAL>N</AUTO_RECAL>
<DISABACCSS>N</DISABACCSS>
<NUMDISABL>3</NUMDISABL>
<HAND_PARK>Y</HAND_PARK>
<SECURITY>N</SECURITY>
<SECUR_HRS>00:00 - 23:59</SECUR_HRS>
<DEADBOLTS>N</DEADBOLTS>
<PUBADDRESS>Y</PUBADDRESS>
<INT_ACCESS>Y</INT_ACCESS>
<OPEN_WINDOWS>Y</OPEN_WINDOWS>
<SAFE_CODES>N</SAFE_CODES>
<DOORS_CLOSE>Y</DOORS_CLOSE>
<PARKGATES>NA</PARKGATES>
<PARKPATROL>N</PARKPATROL>
<PARKLIGHTS>NA</PARKLIGHTS>
<PUBCAMERA>N</PUBCAMERA>
<PARK_FR_ENT_CAMERA>NA</PARK_FR_ENT_CAMERA>
<CAMERA_REC_24HR>NA</CAMERA_REC_24HR>
<CAMERA_MONT_24HR>NA</CAMERA_MONT_24HR>
<VIEWPORTS>N</VIEWPORTS>
<BACK_UP>N</BACK_UP>
<ALARMS_CONT_MONT>N</ALARMS_CONT_MONT>
<EXT_DOOR_KEY_ACCESS>N</EXT_DOOR_KEY_ACCESS>
<STAFF_AID>Y</STAFF_AID>
<STAFF_CPR_TRAIN>N</STAFF_CPR_TRAIN>
<STAFF_CPR_CERT>N</STAFF_CPR_CERT>
<STAFF_AED>N</STAFF_AED>
<MEDICAL_EQUIP>N</MEDICAL_EQUIP>
<AED_ONSITE>N</AED_ONSITE>
</ns0:SS>
- <ns0:GT>
<TRAIN_NAME>23</TRAIN_NAME>
<DIST_TRAIN>0.10000000000000001</DIST_TRAIN>
<METRO_NAME />
<METRO_DIST>0</METRO_DIST>
<CITYTRANS>N</CITYTRANS>
<CARRENT>N</CARRENT>
<CARRENT_NAME>first</CARRENT_NAME>
- <ns0:AIRPORT>
<AIR_CODE>ANA</AIR_CODE>
<AIR_DIRECT>N</AIR_DIRECT>
<AIR_DIST>.00</AIR_DIST>
<AIR_SHUTTL>N</AIR_SHUTTL>
<AIR_TAXI>0</AIR_TAXI>
<AIR_PUB>N</AIR_PUB>
<DIRECTION />
</ns0:AIRPORT>
</ns0:GT>
- <ns0:CT>
<TWOLINE>Y</TWOLINE>
<VOICEMAIL>N</VOICEMAIL>
<DIRECT_DIAL>Y</DIRECT_DIAL>
<SPEAKPHONE>Y</SPEAKPHONE>
<CORDPHONE>Y</CORDPHONE>
<MOBILE_PH>Y</MOBILE_PH>
<RM_FAX>Y</RM_FAX>
<RM_PRINT>Y</RM_PRINT>
<ELEC_DESK_OUT>Y</ELEC_DESK_OUT>
<TEL_JACK_ADP>Y</TEL_JACK_ADP>
<ELEC_ADP>Y</ELEC_ADP>
<POWER_CONV>Y</POWER_CONV>
<NUM_PHONE>12</NUM_PHONE>
<PHONE_BILL_SEP>N</PHONE_BILL_SEP>
<IN_FAX>0</IN_FAX>
<IN_FAX_ADD>0</IN_FAX_ADD>
<IN_FAX_COMM />
<OUT_FAX>0</OUT_FAX>
<OUT_FAX_ADD>0</OUT_FAX_ADD>
<OUT_FAX_COMM />
<LOCALCALL_FEE />
<CCARD_FEE />
<OPER_FEE />
<TOLL_FEE />
<INTL_FEE />
<CARACC_FEE />
<AN_DATAPORT>Y</AN_DATAPORT>
<AN_DATAPORT_NUM>0</AN_DATAPORT_NUM>
<AN_DATAPORT_CHG>0</AN_DATAPORT_CHG>
<INTER_TV>Y</INTER_TV>
<INTER_TV_NUM>0</INTER_TV_NUM>
<INTER_TV_CHG>0</INTER_TV_CHG>
<HIGHSPEED_INROOM>Y</HIGHSPEED_INROOM>
<HIGHSPEED_INROOM_NUM>0</HIGHSPEED_INROOM_NUM>
<HIGHSPEED_INROOM_CHG>0</HIGHSPEED_INROOM_CHG>
<WIRELESS>Y</WIRELESS>
<WIRELESS_CHG>0</WIRELESS_CHG>
<INROOM_PC>N</INROOM_PC>
<INROOM_PC_CHG />
<AN_DATAPORT_BC>N</AN_DATAPORT_BC>
<AN_DATAPORT_BC_CHG />
<HIGHSPEED_BC>N</HIGHSPEED_BC>
<HIGHSPEED_BC_CHG />
<WIRELESS_BC>N</WIRELESS_BC>
<WIRELESS_BC_CHG />
<PC_BC>N</PC_BC>
<PC_BC_CHG />
<AN_DATAPORT_PA>Y</AN_DATAPORT_PA>
<AN_DATAPORT_PA_CHG />
<HIGHSPEED_PA>N</HIGHSPEED_PA>
<HIGHSPEED_PA_CHG />
<WIRELESS_PA>N</WIRELESS_PA>
<WIRELESS_PA_CHG />
<PC_PA>N</PC_PA>
<PC_PA_CHG />
<INDV_FOLIOS>Y</INDV_FOLIOS>
<FOLIOS_COMPANY>Y</FOLIOS_COMPANY>
</ns0:CT>
- <ns0:ES>
- <ns0:SEASON_RATES_ES>
<SEASON_START_ES>2002-01-01</SEASON_START_ES>
<SEASON_END_ES>2002-12-31</SEASON_END_ES>
- <ns0:LOS_TIER>
<LOS_TIER_NUM>2</LOS_TIER_NUM>
- <ns0:ROOM_RATES_ES>
<ROOM_TYPE_NUM>1</ROOM_TYPE_NUM>
<CORP_ES_SGL />
<CORP_ES_DBL />
<LRA_ES_SGL />
<LRA_ES_DBL />
<NLRA_ES_SGL />
<NLRA_ES_DBL />
<CONS_ES_SGL />
<CONS_ES_DBL />
</ns0:ROOM_RATES_ES>
- <ns0:ROOM_RATES_ES>
<ROOM_TYPE_NUM>2</ROOM_TYPE_NUM>
<CORP_ES_SGL />
<CORP_ES_DBL />
<LRA_ES_SGL />
<LRA_ES_DBL />
<NLRA_ES_SGL />
<NLRA_ES_DBL />
<CONS_ES_SGL />
<CONS_ES_DBL />
</ns0:ROOM_RATES_ES>
</ns0:LOS_TIER>
</ns0:SEASON_RATES_ES>
- <ns0:ADDTL_CHARGE_ES>
<ROOM_TYPE_NUM>1</ROOM_TYPE_NUM>
</ns0:ADDTL_CHARGE_ES>
</ns0:ES>
- <ns0:Errors>
- <ns0:Error1>
<FieldName>SEASON 1 SINGLE ROOM</FieldName>
<Description>Rack is empty or not an number; Corp is
empty or not an number; LRA is empty or not an number;
Consortia is empty or not an number;</Description>
</ns0:Error1>
- <ns0:Error2>
<FieldName>SEASON 1 DOUBLE ROOM</FieldName>
<Description>Rack is empty or not an number; Corp is
empty or not an number; LRA is empty or not an number;
Consortia is empty or not an number;</Description>
</ns0:Error2>
</ns0:Errors>
</ns0:X_NBTA05>The reason is that you set the default element namespace, but PROPCODE is
not in a namespace:
<PB xmlns="http://www.rfpexpress.com">
<PROPCODE xmlns="">34991</PROPCODE>
Try the following query (note I updated the syntax so it will work with
Beta3 and replaced your FLWR with a normal path expression since they are
equivalent):
SELECT bidData.query('
declare namespace r = "http://www.rfpexpress.com";
/r:X_NBTA05/r:PB/PROPCODE
')
FROM tblBidXMLData
HTH
Michael
"Bryan Murtha" <anonymous@.discussions.microsoft.com> wrote in message
news:160801c4e6cd$17c1d680$a401280a@.phx.gbl...
> Please, Please, Please help. I tried a million different
> ways of doing this and I can't get results, I always get
> no results or NULL. I just want a node, just one node,
> anything.
> use telnform
> SELECT bidData.query('
> declare default element namespace=
> "http://www.rfpexpress.com"
> for $propCode in /X_NBTA05/PB/PROPCODE
> return $propCode
> ')
> FROM tblBidXMLData
> USE [TelnForm]
> GO
> /****** Object: Table [dbo].[tblBidXMLData] Script
> Date: 12/20/2004 11:48:10 ******/
> SET ANSI_NULLS ON
> GO
> SET ANSI_PADDING ON
> GO
> CREATE TABLE [dbo].[tblBidXMLData](
> [BidID] [int] NOT NULL,
> [bidData] [xml] NULL,
> [CorpID] [int] NOT NULL,
> [CorpRFPNumber] [varchar](25) COLLATE
> SQL_Latin1_General_CP1_CI_AS NOT NULL,
> [PropID] [int] NOT NULL,
> [AutoSubmit] [bit] NOT NULL,
> [ValidationErrors] [int] NULL,
> [NamId] [int] NULL
> ) ON [PRIMARY]
> GO
> SET ANSI_PADDING OFF
> GO
> SET ANSI_NULLS OFF
> - <ns0:X_NBTA05 xmlns:ns0="http://www.rfpexpress.com"
> xmlns:ns1="http://www.rfpexpress.com/Global">
> - <ns0:PB>
> <PROPCODE>34991</PROPCODE>
> <PROPNAME>RFP Express Test Property - Product
> Development</PROPNAME>
> <PROPADD1>8989 Rio San Diego Dr11</PROPADD1>
> <PROPADD2 />
> <PROPCITY>Ixataville</PROPCITY>
> <PROPSTATEPROV>CA</PROPSTATEPROV>
> <PROPCOUNTRY>United States</PROPCOUNTRY>
> <PROPPOSTCODE>99998</PROPPOSTCODE>
> <MAINPHONECOUNTRY />
> <MAINPHONECITY>619</MAINPHONECITY>
> <MAINPHONE>4008840</MAINPHONE>
> <MAINFAXCOUNTRY />
> <MAINFAXCITY>619</MAINFAXCITY>
> <MAINFAX>4008819</MAINFAX>
> <UNITOFMEAS>MI</UNITOFMEAS>
> <PROPURL>1</PROPURL>
> <FULL_OR_LIM>L</FULL_OR_LIM>
> <ES_STAY>Y</ES_STAY>
> <MKT_TIER>L</MKT_TIER>
> <AAADIAM_RATE>1</AAADIAM_RATE>
> <MOBILSTAR_RATE>NA</MOBILSTAR_RATE>
> <OHG_CLASS>Tourist</OHG_CLASS>
> <YRBUILT>1952</YRBUILT>
> <LASTREN>1234</LASTREN>
> <NUMROOMS>555</NUMROOMS>
> <NUMNOSMK>1</NUMNOSMK>
> <NUMFLRS>45</NUMFLRS>
> <MGMTCOMPANY>Gene Kaliman</MGMTCOMPANY>
> <OWNERCOMPANY>Gene Kaliman</OWNERCOMPANY>
> <MIN_OWNED_CERT>Y</MIN_OWNED_CERT>
> <WMN_OWNED_CERT>N</WMN_OWNED_CERT>
> <ADACOMPLY>N</ADACOMPLY>
> <PROP_LOC>T</PROP_LOC>
> <PROPOVERVIEW>Luxury hotel located in the heart of
> downtown San Diego. Lovely view of the
> harbor.</PROPOVERVIEW>
> <AMEXCARD>Y</AMEXCARD>
> <DINERSCARD>Y</DINERSCARD>
> <DISCOVERCARD>Y</DISCOVERCARD>
> <JCBCARD>Y</JCBCARD>
> <MASTERCARD>Y</MASTERCARD>
> <VISACARD>Y</VISACARD>
> <AMADEUS_CHAINCODE>67</AMADEUS_CHAINCODE>
> <AMADEUS_PROPCODE>555a</AMADEUS_PROPCODE>
> <APOLLO_CHAINCODE>12</APOLLO_CHAINCODE>
> <APOLLO_PROPCODE />
> <SABRE_CHAINCODE>14</SABRE_CHAINCODE>
> <SABRE_PROPCODE>15a</SABRE_PROPCODE>
> <WORLDSPAN_CHAINCODE>56</WORLDSPAN_CHAINCODE>
> <WORLDSPAN_PROPCODE />
> <MASTERCHAINCODE>AS</MASTERCHAINCODE>
> </ns0:PB>
> - <ns0:CS>
> <TEMPLATE_NAME>Consortia</TEMPLATE_NAME>
> <OFFICENAME />
> <OFFICEADD1 />
> <RN_TARGET>N</RN_TARGET>
> <RATE_CURR>USD</RATE_CURR>
> <COMMISIONABLE>N</COMMISIONABLE>
> <COMM_PCT_CLIENT />
> <COMM_PCT_CONS />
> <LOAD_GDS>Y</LOAD_GDS>
> <WALK_HOTEL>N</WALK_HOTEL>
> <WALK_TAX>N</WALK_TAX>
> <WALK_TRANS>N</WALK_TRANS>
> <WALK_CALL>N</WALK_CALL>
> <CANC_POL>24hr</CANC_POL>
> <EARLYCK_FEE>0</EARLYCK_FEE>
> <EARLYCK_UOM>F</EARLYCK_UOM>
> <EARLYCK_INCLUDE>N</EARLYCK_INCLUDE>
> <LODGTX_FEE>13</LODGTX_FEE>
> <LODGTX_UOM>P</LODGTX_UOM>
> <LODGTX_INCLUDE>N</LODGTX_INCLUDE>
> <STATETX_FEE>23</STATETX_FEE>
> <STATETX_UOM>P</STATETX_UOM>
> <STATETX_INCLUDE>Y</STATETX_INCLUDE>
> <CITYTX_FEE>34</CITYTX_FEE>
> <CITYTX_UOM>P</CITYTX_UOM>
> <CITYTX_INCLUDE>N</CITYTX_INCLUDE>
> <VATGST_FEE>45</VATGST_FEE>
> <VATGST_UOM>P</VATGST_UOM>
> <VATGST_INCLUDE>Y</VATGST_INCLUDE>
> <SERVICE_FEE>56</SERVICE_FEE>
> <SERVICE_UOM>P</SERVICE_UOM>
> <SERVICE_INCLUDE>N</SERVICE_INCLUDE>
> <OCC_FEE>76</OCC_FEE>
> <OCC_UOM>P</OCC_UOM>
> <OCC_INCLUDE>Y</OCC_INCLUDE>
> <PARK_FEE>5</PARK_FEE>
> <PARK_INCLUDE>N</PARK_INCLUDE>
> <BREAK_FEE />
> <BREAK_INCLUDE>N</BREAK_INCLUDE>
> <FITNESS_FEE_ON>234</FITNESS_FEE_ON>
> <FITNESS_INCLUDE_ON>N</FITNESS_INCLUDE_ON>
> <FITNESS_FEE_OFF>0</FITNESS_FEE_OFF>
> <FITNESS_INCLUDE_OFF>N</FITNESS_INCLUDE_OFF>
> <HSIA_FEE>0</HSIA_FEE>
> <HSIA_INCLUDE>N</HSIA_INCLUDE>
> <WIRELESS_FEE>0</WIRELESS_FEE>
> <WIRELESS_INCLUDE>N</WIRELESS_INCLUDE>
> <COMP_INFAX>N</COMP_INFAX>
> <COMP_OUTFAX>N</COMP_OUTFAX>
> <AIRTRANS_FEE>0</AIRTRANS_FEE>
> <AIRTRANS_INCLUDE>N</AIRTRANS_INCLUDE>
> <OFFTRANS_FEE>0</OFFTRANS_FEE>
> <OFFTRANS_INCLUDE>Y</OFFTRANS_INCLUDE>
> <RATE_SUBS>N</RATE_SUBS>
> <RATE_PERSO>N</RATE_PERSO>
> <RATE_CONSU>N</RATE_CONSU>
> <RATE_RETIR>N</RATE_RETIR>
> <RFP_CONTRACT>Y</RFP_CONTRACT>
> <PROPSALESCONT>gene kaliman</PROPSALESCONT>
> <PROPSALESTITLE>Director of Programming</PROPSALESTITLE>
> <PROPSALESPHONECOUNTRY>1</PROPSALESPHONECOUNTRY>
> <PROPSALESPHONECITYCODE>619</PROPSALESPHONECITYCODE>
> <PROPSALESPHONE>400-88412</PROPSALESPHONE>
> <PROPSALESFAXCOUNTRYCODE />
> <PROPSALESFAXCITYCODE>6193</PROPSALESFAXCITYCODE>
> <PROPSALESFAX>400-88194</PROPSALESFAX>
> <PROPSALESEMAIL>cirquedusoul@.cyberianrealty.net</PROPSALESE
> MAIL>
> <RFP_NAME>gene kaliman</RFP_NAME>
> <RFP_TITLE>Director of Programming</RFP_TITLE>
> <RFP_PHONECOUNTRYCODE>1</RFP_PHONECOUNTRYCODE>
> <RFP_PHONECITYCODE>619</RFP_PHONECITYCODE>
> <RFP_PHONE>400-88412</RFP_PHONE>
> <RFP_EMAIL>cirquedusoul@.cyberianrealty.net</RFP_EMAIL>
> <RFP_DATESUBMIT>2004-07-13</RFP_DATESUBMIT>
> - <ns0:ROOM_TYPES>
> <ROOMTYPEDEFINE>Standard</ROOMTYPEDEFINE>
> <ROOMTYPENUMBER>0</ROOMTYPENUMBER>
> </ns0:ROOM_TYPES>
> - <ns0:ROOM_TYPES>
> <ROOMTYPEDEFINE>Upgrade</ROOMTYPEDEFINE>
> <ROOMTYPENUMBER>0</ROOMTYPENUMBER>
> </ns0:ROOM_TYPES>
> - <ns0:SEASON_RATES>
> <SEASON_START>2002-01-01</SEASON_START>
> <SEASON_END>2002-12-31</SEASON_END>
> - <ns0:ROOM_RATES>
> <ROOM_TYPE_NUM>1</ROOM_TYPE_NUM>
> <RACK_SGL />
> <RACK_DBL />
> <CORP_SGL />
> <CORP_DBL />
> <LRA_SGL>123</LRA_SGL>
> <LRA_DBL>123</LRA_DBL>
> <NLRA_SGL />
> <NLRA_DBL />
> <CONS_SGL />
> <CONS_DBL />
> <GOVT_SGL />
> <GOVT_DBL />
> </ns0:ROOM_RATES>
> - <ns0:ROOM_RATES>
> <ROOM_TYPE_NUM>2</ROOM_TYPE_NUM>
> <RACK_SGL />
> <RACK_DBL />
> <CORP_SGL />
> <CORP_DBL />
> <LRA_SGL>234</LRA_SGL>
> <LRA_DBL>234</LRA_DBL>
> <NLRA_SGL />
> <NLRA_DBL />
> <CONS_SGL />
> <CONS_DBL />
> <GOVT_SGL />
> <GOVT_DBL />
> </ns0:ROOM_RATES>
> </ns0:SEASON_RATES>
> </ns0:CS>
> - <ns0:SA>
> <REST_ONSITE>Y</REST_ONSITE>
> <LOUNGE_BAR>N</LOUNGE_BAR>
> <REST_MEALSBK>Y</REST_MEALSBK>
> <REST_MEALSLUN>N</REST_MEALSLUN>
> <REST_MEALSDIN>Y</REST_MEALSDIN>
> <RM_SRV_AVL>N</RM_SRV_AVL>
> <RM_SRV_HRS>01:00-08:01</RM_SRV_HRS>
> <RECEPTION>N</RECEPTION>
> <RECEPT_DAYS>Monday</RECEPT_DAYS>
> <GIFT_NEWS>Y</GIFT_NEWS>
> <CONVENENCE_FOOD>N</CONVENENCE_FOOD>
> <GROCERY_SVC>Y</GROCERY_SVC>
> <CASH_ONSITE>N</CASH_ONSITE>
> <FITON_CENT>Y</FITON_CENT>
> <FITON_TYPE />
> <FITOFF_CENT>Y</FITOFF_CENT>
> <FITOFF_TYPE>E</FITOFF_TYPE>
> <REC_COURT>N</REC_COURT>
> <CONC_SERV>N</CONC_SERV>
> <BUS_CENTER>Y</BUS_CENTER>
> <BUS_SERV>Y</BUS_SERV>
> <IN_POOL>N</IN_POOL>
> <OUT_POOL>Y</OUT_POOL>
> <WHIRLPOOL>Y</WHIRLPOOL>
> <SAUNA>Y</SAUNA>
> <VIDEO_RENT>N</VIDEO_RENT>
> <PARKING>N</PARKING>
> <VALET_PARKING>N</VALET_PARKING>
> <DAILY_PARK_FEE>5</DAILY_PARK_FEE>
> <PARKFEE_MANAGED_HOTEL>N</PARKFEE_MANAGED_HOTEL>
> <STORAGE>N</STORAGE>
> <STORAGE_FEE />
> <SAFEBOX>Y</SAFEBOX>
> <LAUN_DRY>Y</LAUN_DRY>
> <LAUNDRY_SITE>Y</LAUNDRY_SITE>
> <LAUNDRY_HOURS>00:00 - 23:58</LAUNDRY_HOURS>
> <IRON_BOARD>N</IRON_BOARD>
> <HAIR_DRY>N</HAIR_DRY>
> <ALM_CLOCK />
> <TV_CABLE>N</TV_CABLE>
> <TV_MOVIE>N</TV_MOVIE>
> <STEREO>N</STEREO>
> <VCR>N</VCR>
> <DVD>N</DVD>
> <MINI_FRIG>N</MINI_FRIG>
> <MICRO>N</MICRO>
> <COFF_TEA>N</COFF_TEA>
> <MINIBAR>N</MINIBAR>
> <PRESS>N</PRESS>
> <WORKDESK>N</WORKDESK>
> <NEWS_PAP>N</NEWS_PAP>
> <BATHROBE>N</BATHROBE>
> <SOFA_BED>N</SOFA_BED>
> <IN_SAFE>N</IN_SAFE>
> <SAFE_CHG>0</SAFE_CHG>
> <AIR_CONDITIONED>N</AIR_CONDITIONED>
> <IN_SELF_TEMP>N</IN_SELF_TEMP>
> <PRIVATE_BATHSA>Y</PRIVATE_BATHSA>
> <STOVE>N</STOVE>
> <OVEN>N</OVEN>
> <TOASTER>N</TOASTER>
> <REFRIGERATOR>N</REFRIGERATOR>
> <DISHWASHER>N</DISHWASHER>
> <DINING_WARE>N</DINING_WARE>
> <DISHES>N</DISHES>
> <HOUSEKEEPING>W</HOUSEKEEPING>
> <HOUSE_FULL_OR_LIM>L</HOUSE_FULL_OR_LIM>
> <FRNT_DESK>00:00 - 23:57</FRNT_DESK>
> </ns0:SA>
> - <ns0:SS>
> <ROOMSMKDET>Y</ROOMSMKDET>
> <HALLSMKDET>NA</HALLSMKDET>
> <PUBSMKDET>N</PUBSMKDET>
> <HRDWIREDET>N</HRDWIREDET>
> <FIRE_EXTIN>Y</FIRE_EXTIN>
> <EMRGCYLITE>N</EMRGCYLITE>
> <VENT_STAIR>N</VENT_STAIR>
> <EVACPLAN>Y</EVACPLAN>
> <FIRELAWS>N</FIRELAWS>
> <VIS_ALARM>N</VIS_ALARM>
> <HALLVIS_ALARM>NA</HALLVIS_ALARM>
> <PUBVIS_ALARM>NA</PUBVIS_ALARM>
> <AUD_ALARM>Y</AUD_ALARM>
> <HALLAUD_ALARM>NA</HALLAUD_ALARM>
> <PUBAUD_ALARM>NA</PUBAUD_ALARM>
> <ROOMSPRINK>N</ROOMSPRINK>
> <HALLSPRINK>N</HALLSPRINK>
> <PUBSPRINK>N</PUBSPRINK>
> <EMRGCYINFO>N</EMRGCYINFO>
> <FIRE_LINK>N</FIRE_LINK>
> <MULT_EXITS>Y</MULT_EXITS>
> <AUTO_RECAL>N</AUTO_RECAL>
> <DISABACCSS>N</DISABACCSS>
> <NUMDISABL>3</NUMDISABL>
> <HAND_PARK>Y</HAND_PARK>
> <SECURITY>N</SECURITY>
> <SECUR_HRS>00:00 - 23:59</SECUR_HRS>
> <DEADBOLTS>N</DEADBOLTS>
> <PUBADDRESS>Y</PUBADDRESS>
> <INT_ACCESS>Y</INT_ACCESS>
> <OPEN_WINDOWS>Y</OPEN_WINDOWS>
> <SAFE_CODES>N</SAFE_CODES>
> <DOORS_CLOSE>Y</DOORS_CLOSE>
> <PARKGATES>NA</PARKGATES>
> <PARKPATROL>N</PARKPATROL>
> <PARKLIGHTS>NA</PARKLIGHTS>
> <PUBCAMERA>N</PUBCAMERA>
> <PARK_FR_ENT_CAMERA>NA</PARK_FR_ENT_CAMERA>
> <CAMERA_REC_24HR>NA</CAMERA_REC_24HR>
> <CAMERA_MONT_24HR>NA</CAMERA_MONT_24HR>
> <VIEWPORTS>N</VIEWPORTS>
> <BACK_UP>N</BACK_UP>
> <ALARMS_CONT_MONT>N</ALARMS_CONT_MONT>
> <EXT_DOOR_KEY_ACCESS>N</EXT_DOOR_KEY_ACCESS>
> <STAFF_AID>Y</STAFF_AID>
> <STAFF_CPR_TRAIN>N</STAFF_CPR_TRAIN>
> <STAFF_CPR_CERT>N</STAFF_CPR_CERT>
> <STAFF_AED>N</STAFF_AED>
> <MEDICAL_EQUIP>N</MEDICAL_EQUIP>
> <AED_ONSITE>N</AED_ONSITE>
> </ns0:SS>
> - <ns0:GT>
> <TRAIN_NAME>23</TRAIN_NAME>
> <DIST_TRAIN>0.10000000000000001</DIST_TRAIN>
> <METRO_NAME />
> <METRO_DIST>0</METRO_DIST>
> <CITYTRANS>N</CITYTRANS>
> <CARRENT>N</CARRENT>
> <CARRENT_NAME>first</CARRENT_NAME>
> - <ns0:AIRPORT>
> <AIR_CODE>ANA</AIR_CODE>
> <AIR_DIRECT>N</AIR_DIRECT>
> <AIR_DIST>.00</AIR_DIST>
> <AIR_SHUTTL>N</AIR_SHUTTL>
> <AIR_TAXI>0</AIR_TAXI>
> <AIR_PUB>N</AIR_PUB>
> <DIRECTION />
> </ns0:AIRPORT>
> </ns0:GT>
> - <ns0:CT>
> <TWOLINE>Y</TWOLINE>
> <VOICEMAIL>N</VOICEMAIL>
> <DIRECT_DIAL>Y</DIRECT_DIAL>
> <SPEAKPHONE>Y</SPEAKPHONE>
> <CORDPHONE>Y</CORDPHONE>
> <MOBILE_PH>Y</MOBILE_PH>
> <RM_FAX>Y</RM_FAX>
> <RM_PRINT>Y</RM_PRINT>
> <ELEC_DESK_OUT>Y</ELEC_DESK_OUT>
> <TEL_JACK_ADP>Y</TEL_JACK_ADP>
> <ELEC_ADP>Y</ELEC_ADP>
> <POWER_CONV>Y</POWER_CONV>
> <NUM_PHONE>12</NUM_PHONE>
> <PHONE_BILL_SEP>N</PHONE_BILL_SEP>
> <IN_FAX>0</IN_FAX>
> <IN_FAX_ADD>0</IN_FAX_ADD>
> <IN_FAX_COMM />
> <OUT_FAX>0</OUT_FAX>
> <OUT_FAX_ADD>0</OUT_FAX_ADD>
> <OUT_FAX_COMM />
> <LOCALCALL_FEE />
> <CCARD_FEE />
> <OPER_FEE />
> <TOLL_FEE />
> <INTL_FEE />
> <CARACC_FEE />
> <AN_DATAPORT>Y</AN_DATAPORT>
> <AN_DATAPORT_NUM>0</AN_DATAPORT_NUM>
> <AN_DATAPORT_CHG>0</AN_DATAPORT_CHG>
> <INTER_TV>Y</INTER_TV>
> <INTER_TV_NUM>0</INTER_TV_NUM>
> <INTER_TV_CHG>0</INTER_TV_CHG>
> <HIGHSPEED_INROOM>Y</HIGHSPEED_INROOM>
> <HIGHSPEED_INROOM_NUM>0</HIGHSPEED_INROOM_NUM>
> <HIGHSPEED_INROOM_CHG>0</HIGHSPEED_INROOM_CHG>
> <WIRELESS>Y</WIRELESS>
> <WIRELESS_CHG>0</WIRELESS_CHG>
> <INROOM_PC>N</INROOM_PC>
> <INROOM_PC_CHG />
> <AN_DATAPORT_BC>N</AN_DATAPORT_BC>
> <AN_DATAPORT_BC_CHG />
> <HIGHSPEED_BC>N</HIGHSPEED_BC>
> <HIGHSPEED_BC_CHG />
> <WIRELESS_BC>N</WIRELESS_BC>
> <WIRELESS_BC_CHG />
> <PC_BC>N</PC_BC>
> <PC_BC_CHG />
> <AN_DATAPORT_PA>Y</AN_DATAPORT_PA>
> <AN_DATAPORT_PA_CHG />
> <HIGHSPEED_PA>N</HIGHSPEED_PA>
> <HIGHSPEED_PA_CHG />
> <WIRELESS_PA>N</WIRELESS_PA>
> <WIRELESS_PA_CHG />
> <PC_PA>N</PC_PA>
> <PC_PA_CHG />
> <INDV_FOLIOS>Y</INDV_FOLIOS>
> <FOLIOS_COMPANY>Y</FOLIOS_COMPANY>
> </ns0:CT>
> - <ns0:ES>
> - <ns0:SEASON_RATES_ES>
> <SEASON_START_ES>2002-01-01</SEASON_START_ES>
> <SEASON_END_ES>2002-12-31</SEASON_END_ES>
> - <ns0:LOS_TIER>
> <LOS_TIER_NUM>2</LOS_TIER_NUM>
> - <ns0:ROOM_RATES_ES>
> <ROOM_TYPE_NUM>1</ROOM_TYPE_NUM>
> <CORP_ES_SGL />
> <CORP_ES_DBL />
> <LRA_ES_SGL />
> <LRA_ES_DBL />
> <NLRA_ES_SGL />
> <NLRA_ES_DBL />
> <CONS_ES_SGL />
> <CONS_ES_DBL />
> </ns0:ROOM_RATES_ES>
> - <ns0:ROOM_RATES_ES>
> <ROOM_TYPE_NUM>2</ROOM_TYPE_NUM>
> <CORP_ES_SGL />
> <CORP_ES_DBL />
> <LRA_ES_SGL />
> <LRA_ES_DBL />
> <NLRA_ES_SGL />
> <NLRA_ES_DBL />
> <CONS_ES_SGL />
> <CONS_ES_DBL />
> </ns0:ROOM_RATES_ES>
> </ns0:LOS_TIER>
> </ns0:SEASON_RATES_ES>
> - <ns0:ADDTL_CHARGE_ES>
> <ROOM_TYPE_NUM>1</ROOM_TYPE_NUM>
> </ns0:ADDTL_CHARGE_ES>
> </ns0:ES>
> - <ns0:Errors>
> - <ns0:Error1>
> <FieldName>SEASON 1 SINGLE ROOM</FieldName>
> <Description>Rack is empty or not an number; Corp is
> empty or not an number; LRA is empty or not an number;
> Consortia is empty or not an number;</Description>
> </ns0:Error1>
> - <ns0:Error2>
> <FieldName>SEASON 1 DOUBLE ROOM</FieldName>
> <Description>Rack is empty or not an number; Corp is
> empty or not an number; LRA is empty or not an number;
> Consortia is empty or not an number;</Description>
> </ns0:Error2>
> </ns0:Errors>
> </ns0:X_NBTA05>

Always get null, can't return results

Please, Please, Please help. I tried a million different
ways of doing this and I can't get results, I always get
no results or NULL. I just want a node, just one node,
anything.
use telnform
SELECT bidData.query('
declare default element namespace=
"http://www.rfpexpress.com"
for $propCode in /X_NBTA05/PB/PROPCODE
return $propCode
')
FROM tblBidXMLData
USE [TelnForm]
GO
/****** Object: Table [dbo].[tblBidXMLData] Script
Date: 12/20/2004 11:48:10 ******/
SET ANSI_NULLS ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblBidXMLData](
[BidID] [int] NOT NULL,
[bidData] [xml] NULL,
[CorpID] [int] NOT NULL,
[CorpRFPNumber] [varchar](25) COLLATE
SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PropID] [int] NOT NULL,
[AutoSubmit] [bit] NOT NULL,
[ValidationErrors] [int] NULL,
[NamId] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS OFF
- <ns0:X_NBTA05 xmlns:ns0="http://www.rfpexpress.com"
xmlns:ns1="http://www.rfpexpress.com/Global">
- <ns0:PB>
<PROPCODE>34991</PROPCODE>
<PROPNAME>RFP Express Test Property - Product
Development</PROPNAME>
<PROPADD1>8989 Rio San Diego Dr11</PROPADD1>
<PROPADD2 />
<PROPCITY>Ixataville</PROPCITY>
<PROPSTATEPROV>CA</PROPSTATEPROV>
<PROPCOUNTRY>United States</PROPCOUNTRY>
<PROPPOSTCODE>99998</PROPPOSTCODE>
<MAINPHONECOUNTRY />
<MAINPHONECITY>619</MAINPHONECITY>
<MAINPHONE>4008840</MAINPHONE>
<MAINFAXCOUNTRY />
<MAINFAXCITY>619</MAINFAXCITY>
<MAINFAX>4008819</MAINFAX>
<UNITOFMEAS>MI</UNITOFMEAS>
<PROPURL>1</PROPURL>
<FULL_OR_LIM>L</FULL_OR_LIM>
<ES_STAY>Y</ES_STAY>
<MKT_TIER>L</MKT_TIER>
<AAADIAM_RATE>1</AAADIAM_RATE>
<MOBILSTAR_RATE>NA</MOBILSTAR_RATE>
<OHG_CLASS>Tourist</OHG_CLASS>
<YRBUILT>1952</YRBUILT>
<LASTREN>1234</LASTREN>
<NUMROOMS>555</NUMROOMS>
<NUMNOSMK>1</NUMNOSMK>
<NUMFLRS>45</NUMFLRS>
<MGMTCOMPANY>Gene Kaliman</MGMTCOMPANY>
<OWNERCOMPANY>Gene Kaliman</OWNERCOMPANY>
<MIN_OWNED_CERT>Y</MIN_OWNED_CERT>
<WMN_OWNED_CERT>N</WMN_OWNED_CERT>
<ADACOMPLY>N</ADACOMPLY>
<PROP_LOC>T</PROP_LOC>
<PROPOVERVIEW>Luxury hotel located in the heart of
downtown San Diego. Lovely view of the
harbor.</PROPOVERVIEW>
<AMEXCARD>Y</AMEXCARD>
<DINERSCARD>Y</DINERSCARD>
<DISCOVERCARD>Y</DISCOVERCARD>
<JCBCARD>Y</JCBCARD>
<MASTERCARD>Y</MASTERCARD>
<VISACARD>Y</VISACARD>
<AMADEUS_CHAINCODE>67</AMADEUS_CHAINCODE>
<AMADEUS_PROPCODE>555a</AMADEUS_PROPCODE>
<APOLLO_CHAINCODE>12</APOLLO_CHAINCODE>
<APOLLO_PROPCODE />
<SABRE_CHAINCODE>14</SABRE_CHAINCODE>
<SABRE_PROPCODE>15a</SABRE_PROPCODE>
<WORLDSPAN_CHAINCODE>56</WORLDSPAN_CHAINCODE>
<WORLDSPAN_PROPCODE />
<MASTERCHAINCODE>AS</MASTERCHAINCODE>
</ns0:PB>
- <ns0:CS>
<TEMPLATE_NAME>Consortia</TEMPLATE_NAME>
<OFFICENAME />
<OFFICEADD1 />
<RN_TARGET>N</RN_TARGET>
<RATE_CURR>USD</RATE_CURR>
<COMMISIONABLE>N</COMMISIONABLE>
<COMM_PCT_CLIENT />
<COMM_PCT_CONS />
<LOAD_GDS>Y</LOAD_GDS>
<WALK_HOTEL>N</WALK_HOTEL>
<WALK_TAX>N</WALK_TAX>
<WALK_TRANS>N</WALK_TRANS>
<WALK_CALL>N</WALK_CALL>
<CANC_POL>24hr</CANC_POL>
<EARLYCK_FEE>0</EARLYCK_FEE>
<EARLYCK_UOM>F</EARLYCK_UOM>
<EARLYCK_INCLUDE>N</EARLYCK_INCLUDE>
<LODGTX_FEE>13</LODGTX_FEE>
<LODGTX_UOM>P</LODGTX_UOM>
<LODGTX_INCLUDE>N</LODGTX_INCLUDE>
<STATETX_FEE>23</STATETX_FEE>
<STATETX_UOM>P</STATETX_UOM>
<STATETX_INCLUDE>Y</STATETX_INCLUDE>
<CITYTX_FEE>34</CITYTX_FEE>
<CITYTX_UOM>P</CITYTX_UOM>
<CITYTX_INCLUDE>N</CITYTX_INCLUDE>
<VATGST_FEE>45</VATGST_FEE>
<VATGST_UOM>P</VATGST_UOM>
<VATGST_INCLUDE>Y</VATGST_INCLUDE>
<SERVICE_FEE>56</SERVICE_FEE>
<SERVICE_UOM>P</SERVICE_UOM>
<SERVICE_INCLUDE>N</SERVICE_INCLUDE>
<OCC_FEE>76</OCC_FEE>
<OCC_UOM>P</OCC_UOM>
<OCC_INCLUDE>Y</OCC_INCLUDE>
<PARK_FEE>5</PARK_FEE>
<PARK_INCLUDE>N</PARK_INCLUDE>
<BREAK_FEE />
<BREAK_INCLUDE>N</BREAK_INCLUDE>
<FITNESS_FEE_ON>234</FITNESS_FEE_ON>
<FITNESS_INCLUDE_ON>N</FITNESS_INCLUDE_ON>
<FITNESS_FEE_OFF>0</FITNESS_FEE_OFF>
<FITNESS_INCLUDE_OFF>N</FITNESS_INCLUDE_OFF>
<HSIA_FEE>0</HSIA_FEE>
<HSIA_INCLUDE>N</HSIA_INCLUDE>
<WIRELESS_FEE>0</WIRELESS_FEE>
<WIRELESS_INCLUDE>N</WIRELESS_INCLUDE>
<COMP_INFAX>N</COMP_INFAX>
<COMP_OUTFAX>N</COMP_OUTFAX>
<AIRTRANS_FEE>0</AIRTRANS_FEE>
<AIRTRANS_INCLUDE>N</AIRTRANS_INCLUDE>
<OFFTRANS_FEE>0</OFFTRANS_FEE>
<OFFTRANS_INCLUDE>Y</OFFTRANS_INCLUDE>
<RATE_SUBS>N</RATE_SUBS>
<RATE_PERSO>N</RATE_PERSO>
<RATE_CONSU>N</RATE_CONSU>
<RATE_RETIR>N</RATE_RETIR>
<RFP_CONTRACT>Y</RFP_CONTRACT>
<PROPSALESCONT>gene kaliman</PROPSALESCONT>
<PROPSALESTITLE>Director of Programming</PROPSALESTITLE>
<PROPSALESPHONECOUNTRY>1</PROPSALESPHONECOUNTRY>
<PROPSALESPHONECITYCODE>619</PROPSALESPHONECITYCODE>
<PROPSALESPHONE>400-88412</PROPSALESPHONE>
<PROPSALESFAXCOUNTRYCODE />
<PROPSALESFAXCITYCODE>6193</PROPSALESFAXCITYCODE>
<PROPSALESFAX>400-88194</PROPSALESFAX>
<PROPSALESEMAIL>cirquedusoul@.cyberianrealty.net< /PROPSALESE
MAIL>
<RFP_NAME>gene kaliman</RFP_NAME>
<RFP_TITLE>Director of Programming</RFP_TITLE>
<RFP_PHONECOUNTRYCODE>1</RFP_PHONECOUNTRYCODE>
<RFP_PHONECITYCODE>619</RFP_PHONECITYCODE>
<RFP_PHONE>400-88412</RFP_PHONE>
<RFP_EMAIL>cirquedusoul@.cyberianrealty.net</RFP_EMAIL>
<RFP_DATESUBMIT>2004-07-13</RFP_DATESUBMIT>
- <ns0:ROOM_TYPES>
<ROOMTYPEDEFINE>Standard</ROOMTYPEDEFINE>
<ROOMTYPENUMBER>0</ROOMTYPENUMBER>
</ns0:ROOM_TYPES>
- <ns0:ROOM_TYPES>
<ROOMTYPEDEFINE>Upgrade</ROOMTYPEDEFINE>
<ROOMTYPENUMBER>0</ROOMTYPENUMBER>
</ns0:ROOM_TYPES>
- <ns0:SEASON_RATES>
<SEASON_START>2002-01-01</SEASON_START>
<SEASON_END>2002-12-31</SEASON_END>
- <ns0:ROOM_RATES>
<ROOM_TYPE_NUM>1</ROOM_TYPE_NUM>
<RACK_SGL />
<RACK_DBL />
<CORP_SGL />
<CORP_DBL />
<LRA_SGL>123</LRA_SGL>
<LRA_DBL>123</LRA_DBL>
<NLRA_SGL />
<NLRA_DBL />
<CONS_SGL />
<CONS_DBL />
<GOVT_SGL />
<GOVT_DBL />
</ns0:ROOM_RATES>
- <ns0:ROOM_RATES>
<ROOM_TYPE_NUM>2</ROOM_TYPE_NUM>
<RACK_SGL />
<RACK_DBL />
<CORP_SGL />
<CORP_DBL />
<LRA_SGL>234</LRA_SGL>
<LRA_DBL>234</LRA_DBL>
<NLRA_SGL />
<NLRA_DBL />
<CONS_SGL />
<CONS_DBL />
<GOVT_SGL />
<GOVT_DBL />
</ns0:ROOM_RATES>
</ns0:SEASON_RATES>
</ns0:CS>
- <ns0:SA>
<REST_ONSITE>Y</REST_ONSITE>
<LOUNGE_BAR>N</LOUNGE_BAR>
<REST_MEALSBK>Y</REST_MEALSBK>
<REST_MEALSLUN>N</REST_MEALSLUN>
<REST_MEALSDIN>Y</REST_MEALSDIN>
<RM_SRV_AVL>N</RM_SRV_AVL>
<RM_SRV_HRS>01:00-08:01</RM_SRV_HRS>
<RECEPTION>N</RECEPTION>
<RECEPT_DAYS>Monday</RECEPT_DAYS>
<GIFT_NEWS>Y</GIFT_NEWS>
<CONVENENCE_FOOD>N</CONVENENCE_FOOD>
<GROCERY_SVC>Y</GROCERY_SVC>
<CASH_ONSITE>N</CASH_ONSITE>
<FITON_CENT>Y</FITON_CENT>
<FITON_TYPE />
<FITOFF_CENT>Y</FITOFF_CENT>
<FITOFF_TYPE>E</FITOFF_TYPE>
<REC_COURT>N</REC_COURT>
<CONC_SERV>N</CONC_SERV>
<BUS_CENTER>Y</BUS_CENTER>
<BUS_SERV>Y</BUS_SERV>
<IN_POOL>N</IN_POOL>
<OUT_POOL>Y</OUT_POOL>
<WHIRLPOOL>Y</WHIRLPOOL>
<SAUNA>Y</SAUNA>
<VIDEO_RENT>N</VIDEO_RENT>
<PARKING>N</PARKING>
<VALET_PARKING>N</VALET_PARKING>
<DAILY_PARK_FEE>5</DAILY_PARK_FEE>
<PARKFEE_MANAGED_HOTEL>N</PARKFEE_MANAGED_HOTEL>
<STORAGE>N</STORAGE>
<STORAGE_FEE />
<SAFEBOX>Y</SAFEBOX>
<LAUN_DRY>Y</LAUN_DRY>
<LAUNDRY_SITE>Y</LAUNDRY_SITE>
<LAUNDRY_HOURS>00:00 - 23:58</LAUNDRY_HOURS>
<IRON_BOARD>N</IRON_BOARD>
<HAIR_DRY>N</HAIR_DRY>
<ALM_CLOCK />
<TV_CABLE>N</TV_CABLE>
<TV_MOVIE>N</TV_MOVIE>
<STEREO>N</STEREO>
<VCR>N</VCR>
<DVD>N</DVD>
<MINI_FRIG>N</MINI_FRIG>
<MICRO>N</MICRO>
<COFF_TEA>N</COFF_TEA>
<MINIBAR>N</MINIBAR>
<PRESS>N</PRESS>
<WORKDESK>N</WORKDESK>
<NEWS_PAP>N</NEWS_PAP>
<BATHROBE>N</BATHROBE>
<SOFA_BED>N</SOFA_BED>
<IN_SAFE>N</IN_SAFE>
<SAFE_CHG>0</SAFE_CHG>
<AIR_CONDITIONED>N</AIR_CONDITIONED>
<IN_SELF_TEMP>N</IN_SELF_TEMP>
<PRIVATE_BATHSA>Y</PRIVATE_BATHSA>
<STOVE>N</STOVE>
<OVEN>N</OVEN>
<TOASTER>N</TOASTER>
<REFRIGERATOR>N</REFRIGERATOR>
<DISHWASHER>N</DISHWASHER>
<DINING_WARE>N</DINING_WARE>
<DISHES>N</DISHES>
<HOUSEKEEPING>W</HOUSEKEEPING>
<HOUSE_FULL_OR_LIM>L</HOUSE_FULL_OR_LIM>
<FRNT_DESK>00:00 - 23:57</FRNT_DESK>
</ns0:SA>
- <ns0:SS>
<ROOMSMKDET>Y</ROOMSMKDET>
<HALLSMKDET>NA</HALLSMKDET>
<PUBSMKDET>N</PUBSMKDET>
<HRDWIREDET>N</HRDWIREDET>
<FIRE_EXTIN>Y</FIRE_EXTIN>
<EMRGCYLITE>N</EMRGCYLITE>
<VENT_STAIR>N</VENT_STAIR>
<EVACPLAN>Y</EVACPLAN>
<FIRELAWS>N</FIRELAWS>
<VIS_ALARM>N</VIS_ALARM>
<HALLVIS_ALARM>NA</HALLVIS_ALARM>
<PUBVIS_ALARM>NA</PUBVIS_ALARM>
<AUD_ALARM>Y</AUD_ALARM>
<HALLAUD_ALARM>NA</HALLAUD_ALARM>
<PUBAUD_ALARM>NA</PUBAUD_ALARM>
<ROOMSPRINK>N</ROOMSPRINK>
<HALLSPRINK>N</HALLSPRINK>
<PUBSPRINK>N</PUBSPRINK>
<EMRGCYINFO>N</EMRGCYINFO>
<FIRE_LINK>N</FIRE_LINK>
<MULT_EXITS>Y</MULT_EXITS>
<AUTO_RECAL>N</AUTO_RECAL>
<DISABACCSS>N</DISABACCSS>
<NUMDISABL>3</NUMDISABL>
<HAND_PARK>Y</HAND_PARK>
<SECURITY>N</SECURITY>
<SECUR_HRS>00:00 - 23:59</SECUR_HRS>
<DEADBOLTS>N</DEADBOLTS>
<PUBADDRESS>Y</PUBADDRESS>
<INT_ACCESS>Y</INT_ACCESS>
<OPEN_WINDOWS>Y</OPEN_WINDOWS>
<SAFE_CODES>N</SAFE_CODES>
<DOORS_CLOSE>Y</DOORS_CLOSE>
<PARKGATES>NA</PARKGATES>
<PARKPATROL>N</PARKPATROL>
<PARKLIGHTS>NA</PARKLIGHTS>
<PUBCAMERA>N</PUBCAMERA>
<PARK_FR_ENT_CAMERA>NA</PARK_FR_ENT_CAMERA>
<CAMERA_REC_24HR>NA</CAMERA_REC_24HR>
<CAMERA_MONT_24HR>NA</CAMERA_MONT_24HR>
<VIEWPORTS>N</VIEWPORTS>
<BACK_UP>N</BACK_UP>
<ALARMS_CONT_MONT>N</ALARMS_CONT_MONT>
<EXT_DOOR_KEY_ACCESS>N</EXT_DOOR_KEY_ACCESS>
<STAFF_AID>Y</STAFF_AID>
<STAFF_CPR_TRAIN>N</STAFF_CPR_TRAIN>
<STAFF_CPR_CERT>N</STAFF_CPR_CERT>
<STAFF_AED>N</STAFF_AED>
<MEDICAL_EQUIP>N</MEDICAL_EQUIP>
<AED_ONSITE>N</AED_ONSITE>
</ns0:SS>
- <ns0:GT>
<TRAIN_NAME>23</TRAIN_NAME>
<DIST_TRAIN>0.10000000000000001</DIST_TRAIN>
<METRO_NAME />
<METRO_DIST>0</METRO_DIST>
<CITYTRANS>N</CITYTRANS>
<CARRENT>N</CARRENT>
<CARRENT_NAME>first</CARRENT_NAME>
- <ns0:AIRPORT>
<AIR_CODE>ANA</AIR_CODE>
<AIR_DIRECT>N</AIR_DIRECT>
<AIR_DIST>.00</AIR_DIST>
<AIR_SHUTTL>N</AIR_SHUTTL>
<AIR_TAXI>0</AIR_TAXI>
<AIR_PUB>N</AIR_PUB>
<DIRECTION />
</ns0:AIRPORT>
</ns0:GT>
- <ns0:CT>
<TWOLINE>Y</TWOLINE>
<VOICEMAIL>N</VOICEMAIL>
<DIRECT_DIAL>Y</DIRECT_DIAL>
<SPEAKPHONE>Y</SPEAKPHONE>
<CORDPHONE>Y</CORDPHONE>
<MOBILE_PH>Y</MOBILE_PH>
<RM_FAX>Y</RM_FAX>
<RM_PRINT>Y</RM_PRINT>
<ELEC_DESK_OUT>Y</ELEC_DESK_OUT>
<TEL_JACK_ADP>Y</TEL_JACK_ADP>
<ELEC_ADP>Y</ELEC_ADP>
<POWER_CONV>Y</POWER_CONV>
<NUM_PHONE>12</NUM_PHONE>
<PHONE_BILL_SEP>N</PHONE_BILL_SEP>
<IN_FAX>0</IN_FAX>
<IN_FAX_ADD>0</IN_FAX_ADD>
<IN_FAX_COMM />
<OUT_FAX>0</OUT_FAX>
<OUT_FAX_ADD>0</OUT_FAX_ADD>
<OUT_FAX_COMM />
<LOCALCALL_FEE />
<CCARD_FEE />
<OPER_FEE />
<TOLL_FEE />
<INTL_FEE />
<CARACC_FEE />
<AN_DATAPORT>Y</AN_DATAPORT>
<AN_DATAPORT_NUM>0</AN_DATAPORT_NUM>
<AN_DATAPORT_CHG>0</AN_DATAPORT_CHG>
<INTER_TV>Y</INTER_TV>
<INTER_TV_NUM>0</INTER_TV_NUM>
<INTER_TV_CHG>0</INTER_TV_CHG>
<HIGHSPEED_INROOM>Y</HIGHSPEED_INROOM>
<HIGHSPEED_INROOM_NUM>0</HIGHSPEED_INROOM_NUM>
<HIGHSPEED_INROOM_CHG>0</HIGHSPEED_INROOM_CHG>
<WIRELESS>Y</WIRELESS>
<WIRELESS_CHG>0</WIRELESS_CHG>
<INROOM_PC>N</INROOM_PC>
<INROOM_PC_CHG />
<AN_DATAPORT_BC>N</AN_DATAPORT_BC>
<AN_DATAPORT_BC_CHG />
<HIGHSPEED_BC>N</HIGHSPEED_BC>
<HIGHSPEED_BC_CHG />
<WIRELESS_BC>N</WIRELESS_BC>
<WIRELESS_BC_CHG />
<PC_BC>N</PC_BC>
<PC_BC_CHG />
<AN_DATAPORT_PA>Y</AN_DATAPORT_PA>
<AN_DATAPORT_PA_CHG />
<HIGHSPEED_PA>N</HIGHSPEED_PA>
<HIGHSPEED_PA_CHG />
<WIRELESS_PA>N</WIRELESS_PA>
<WIRELESS_PA_CHG />
<PC_PA>N</PC_PA>
<PC_PA_CHG />
<INDV_FOLIOS>Y</INDV_FOLIOS>
<FOLIOS_COMPANY>Y</FOLIOS_COMPANY>
</ns0:CT>
- <ns0:ES>
- <ns0:SEASON_RATES_ES>
<SEASON_START_ES>2002-01-01</SEASON_START_ES>
<SEASON_END_ES>2002-12-31</SEASON_END_ES>
- <ns0:LOS_TIER>
<LOS_TIER_NUM>2</LOS_TIER_NUM>
- <ns0:ROOM_RATES_ES>
<ROOM_TYPE_NUM>1</ROOM_TYPE_NUM>
<CORP_ES_SGL />
<CORP_ES_DBL />
<LRA_ES_SGL />
<LRA_ES_DBL />
<NLRA_ES_SGL />
<NLRA_ES_DBL />
<CONS_ES_SGL />
<CONS_ES_DBL />
</ns0:ROOM_RATES_ES>
- <ns0:ROOM_RATES_ES>
<ROOM_TYPE_NUM>2</ROOM_TYPE_NUM>
<CORP_ES_SGL />
<CORP_ES_DBL />
<LRA_ES_SGL />
<LRA_ES_DBL />
<NLRA_ES_SGL />
<NLRA_ES_DBL />
<CONS_ES_SGL />
<CONS_ES_DBL />
</ns0:ROOM_RATES_ES>
</ns0:LOS_TIER>
</ns0:SEASON_RATES_ES>
- <ns0:ADDTL_CHARGE_ES>
<ROOM_TYPE_NUM>1</ROOM_TYPE_NUM>
</ns0:ADDTL_CHARGE_ES>
</ns0:ES>
- <ns0:Errors>
- <ns0:Error1>
<FieldName>SEASON 1 SINGLE ROOM</FieldName>
<Description>Rack is empty or not an number; Corp is
empty or not an number; LRA is empty or not an number;
Consortia is empty or not an number;</Description>
</ns0:Error1>
- <ns0:Error2>
<FieldName>SEASON 1 DOUBLE ROOM</FieldName>
<Description>Rack is empty or not an number; Corp is
empty or not an number; LRA is empty or not an number;
Consortia is empty or not an number;</Description>
</ns0:Error2>
</ns0:Errors>
</ns0:X_NBTA05>
The reason is that you set the default element namespace, but PROPCODE is
not in a namespace:
<PB xmlns="http://www.rfpexpress.com">
<PROPCODE xmlns="">34991</PROPCODE>
Try the following query (note I updated the syntax so it will work with
Beta3 and replaced your FLWR with a normal path expression since they are
equivalent):
SELECT bidData.query('
declare namespace r = "http://www.rfpexpress.com";
/r:X_NBTA05/r:PB/PROPCODE
')
FROM tblBidXMLData
HTH
Michael
"Bryan Murtha" <anonymous@.discussions.microsoft.com> wrote in message
news:160801c4e6cd$17c1d680$a401280a@.phx.gbl...
> Please, Please, Please help. I tried a million different
> ways of doing this and I can't get results, I always get
> no results or NULL. I just want a node, just one node,
> anything.
> use telnform
> SELECT bidData.query('
> declare default element namespace=
> "http://www.rfpexpress.com"
> for $propCode in /X_NBTA05/PB/PROPCODE
> return $propCode
> ')
> FROM tblBidXMLData
> USE [TelnForm]
> GO
> /****** Object: Table [dbo].[tblBidXMLData] Script
> Date: 12/20/2004 11:48:10 ******/
> SET ANSI_NULLS ON
> GO
> SET ANSI_PADDING ON
> GO
> CREATE TABLE [dbo].[tblBidXMLData](
> [BidID] [int] NOT NULL,
> [bidData] [xml] NULL,
> [CorpID] [int] NOT NULL,
> [CorpRFPNumber] [varchar](25) COLLATE
> SQL_Latin1_General_CP1_CI_AS NOT NULL,
> [PropID] [int] NOT NULL,
> [AutoSubmit] [bit] NOT NULL,
> [ValidationErrors] [int] NULL,
> [NamId] [int] NULL
> ) ON [PRIMARY]
> GO
> SET ANSI_PADDING OFF
> GO
> SET ANSI_NULLS OFF
> - <ns0:X_NBTA05 xmlns:ns0="http://www.rfpexpress.com"
> xmlns:ns1="http://www.rfpexpress.com/Global">
> - <ns0:PB>
> <PROPCODE>34991</PROPCODE>
> <PROPNAME>RFP Express Test Property - Product
> Development</PROPNAME>
> <PROPADD1>8989 Rio San Diego Dr11</PROPADD1>
> <PROPADD2 />
> <PROPCITY>Ixataville</PROPCITY>
> <PROPSTATEPROV>CA</PROPSTATEPROV>
> <PROPCOUNTRY>United States</PROPCOUNTRY>
> <PROPPOSTCODE>99998</PROPPOSTCODE>
> <MAINPHONECOUNTRY />
> <MAINPHONECITY>619</MAINPHONECITY>
> <MAINPHONE>4008840</MAINPHONE>
> <MAINFAXCOUNTRY />
> <MAINFAXCITY>619</MAINFAXCITY>
> <MAINFAX>4008819</MAINFAX>
> <UNITOFMEAS>MI</UNITOFMEAS>
> <PROPURL>1</PROPURL>
> <FULL_OR_LIM>L</FULL_OR_LIM>
> <ES_STAY>Y</ES_STAY>
> <MKT_TIER>L</MKT_TIER>
> <AAADIAM_RATE>1</AAADIAM_RATE>
> <MOBILSTAR_RATE>NA</MOBILSTAR_RATE>
> <OHG_CLASS>Tourist</OHG_CLASS>
> <YRBUILT>1952</YRBUILT>
> <LASTREN>1234</LASTREN>
> <NUMROOMS>555</NUMROOMS>
> <NUMNOSMK>1</NUMNOSMK>
> <NUMFLRS>45</NUMFLRS>
> <MGMTCOMPANY>Gene Kaliman</MGMTCOMPANY>
> <OWNERCOMPANY>Gene Kaliman</OWNERCOMPANY>
> <MIN_OWNED_CERT>Y</MIN_OWNED_CERT>
> <WMN_OWNED_CERT>N</WMN_OWNED_CERT>
> <ADACOMPLY>N</ADACOMPLY>
> <PROP_LOC>T</PROP_LOC>
> <PROPOVERVIEW>Luxury hotel located in the heart of
> downtown San Diego. Lovely view of the
> harbor.</PROPOVERVIEW>
> <AMEXCARD>Y</AMEXCARD>
> <DINERSCARD>Y</DINERSCARD>
> <DISCOVERCARD>Y</DISCOVERCARD>
> <JCBCARD>Y</JCBCARD>
> <MASTERCARD>Y</MASTERCARD>
> <VISACARD>Y</VISACARD>
> <AMADEUS_CHAINCODE>67</AMADEUS_CHAINCODE>
> <AMADEUS_PROPCODE>555a</AMADEUS_PROPCODE>
> <APOLLO_CHAINCODE>12</APOLLO_CHAINCODE>
> <APOLLO_PROPCODE />
> <SABRE_CHAINCODE>14</SABRE_CHAINCODE>
> <SABRE_PROPCODE>15a</SABRE_PROPCODE>
> <WORLDSPAN_CHAINCODE>56</WORLDSPAN_CHAINCODE>
> <WORLDSPAN_PROPCODE />
> <MASTERCHAINCODE>AS</MASTERCHAINCODE>
> </ns0:PB>
> - <ns0:CS>
> <TEMPLATE_NAME>Consortia</TEMPLATE_NAME>
> <OFFICENAME />
> <OFFICEADD1 />
> <RN_TARGET>N</RN_TARGET>
> <RATE_CURR>USD</RATE_CURR>
> <COMMISIONABLE>N</COMMISIONABLE>
> <COMM_PCT_CLIENT />
> <COMM_PCT_CONS />
> <LOAD_GDS>Y</LOAD_GDS>
> <WALK_HOTEL>N</WALK_HOTEL>
> <WALK_TAX>N</WALK_TAX>
> <WALK_TRANS>N</WALK_TRANS>
> <WALK_CALL>N</WALK_CALL>
> <CANC_POL>24hr</CANC_POL>
> <EARLYCK_FEE>0</EARLYCK_FEE>
> <EARLYCK_UOM>F</EARLYCK_UOM>
> <EARLYCK_INCLUDE>N</EARLYCK_INCLUDE>
> <LODGTX_FEE>13</LODGTX_FEE>
> <LODGTX_UOM>P</LODGTX_UOM>
> <LODGTX_INCLUDE>N</LODGTX_INCLUDE>
> <STATETX_FEE>23</STATETX_FEE>
> <STATETX_UOM>P</STATETX_UOM>
> <STATETX_INCLUDE>Y</STATETX_INCLUDE>
> <CITYTX_FEE>34</CITYTX_FEE>
> <CITYTX_UOM>P</CITYTX_UOM>
> <CITYTX_INCLUDE>N</CITYTX_INCLUDE>
> <VATGST_FEE>45</VATGST_FEE>
> <VATGST_UOM>P</VATGST_UOM>
> <VATGST_INCLUDE>Y</VATGST_INCLUDE>
> <SERVICE_FEE>56</SERVICE_FEE>
> <SERVICE_UOM>P</SERVICE_UOM>
> <SERVICE_INCLUDE>N</SERVICE_INCLUDE>
> <OCC_FEE>76</OCC_FEE>
> <OCC_UOM>P</OCC_UOM>
> <OCC_INCLUDE>Y</OCC_INCLUDE>
> <PARK_FEE>5</PARK_FEE>
> <PARK_INCLUDE>N</PARK_INCLUDE>
> <BREAK_FEE />
> <BREAK_INCLUDE>N</BREAK_INCLUDE>
> <FITNESS_FEE_ON>234</FITNESS_FEE_ON>
> <FITNESS_INCLUDE_ON>N</FITNESS_INCLUDE_ON>
> <FITNESS_FEE_OFF>0</FITNESS_FEE_OFF>
> <FITNESS_INCLUDE_OFF>N</FITNESS_INCLUDE_OFF>
> <HSIA_FEE>0</HSIA_FEE>
> <HSIA_INCLUDE>N</HSIA_INCLUDE>
> <WIRELESS_FEE>0</WIRELESS_FEE>
> <WIRELESS_INCLUDE>N</WIRELESS_INCLUDE>
> <COMP_INFAX>N</COMP_INFAX>
> <COMP_OUTFAX>N</COMP_OUTFAX>
> <AIRTRANS_FEE>0</AIRTRANS_FEE>
> <AIRTRANS_INCLUDE>N</AIRTRANS_INCLUDE>
> <OFFTRANS_FEE>0</OFFTRANS_FEE>
> <OFFTRANS_INCLUDE>Y</OFFTRANS_INCLUDE>
> <RATE_SUBS>N</RATE_SUBS>
> <RATE_PERSO>N</RATE_PERSO>
> <RATE_CONSU>N</RATE_CONSU>
> <RATE_RETIR>N</RATE_RETIR>
> <RFP_CONTRACT>Y</RFP_CONTRACT>
> <PROPSALESCONT>gene kaliman</PROPSALESCONT>
> <PROPSALESTITLE>Director of Programming</PROPSALESTITLE>
> <PROPSALESPHONECOUNTRY>1</PROPSALESPHONECOUNTRY>
> <PROPSALESPHONECITYCODE>619</PROPSALESPHONECITYCODE>
> <PROPSALESPHONE>400-88412</PROPSALESPHONE>
> <PROPSALESFAXCOUNTRYCODE />
> <PROPSALESFAXCITYCODE>6193</PROPSALESFAXCITYCODE>
> <PROPSALESFAX>400-88194</PROPSALESFAX>
> <PROPSALESEMAIL>cirquedusoul@.cyberianrealty.net< /PROPSALESE
> MAIL>
> <RFP_NAME>gene kaliman</RFP_NAME>
> <RFP_TITLE>Director of Programming</RFP_TITLE>
> <RFP_PHONECOUNTRYCODE>1</RFP_PHONECOUNTRYCODE>
> <RFP_PHONECITYCODE>619</RFP_PHONECITYCODE>
> <RFP_PHONE>400-88412</RFP_PHONE>
> <RFP_EMAIL>cirquedusoul@.cyberianrealty.net</RFP_EMAIL>
> <RFP_DATESUBMIT>2004-07-13</RFP_DATESUBMIT>
> - <ns0:ROOM_TYPES>
> <ROOMTYPEDEFINE>Standard</ROOMTYPEDEFINE>
> <ROOMTYPENUMBER>0</ROOMTYPENUMBER>
> </ns0:ROOM_TYPES>
> - <ns0:ROOM_TYPES>
> <ROOMTYPEDEFINE>Upgrade</ROOMTYPEDEFINE>
> <ROOMTYPENUMBER>0</ROOMTYPENUMBER>
> </ns0:ROOM_TYPES>
> - <ns0:SEASON_RATES>
> <SEASON_START>2002-01-01</SEASON_START>
> <SEASON_END>2002-12-31</SEASON_END>
> - <ns0:ROOM_RATES>
> <ROOM_TYPE_NUM>1</ROOM_TYPE_NUM>
> <RACK_SGL />
> <RACK_DBL />
> <CORP_SGL />
> <CORP_DBL />
> <LRA_SGL>123</LRA_SGL>
> <LRA_DBL>123</LRA_DBL>
> <NLRA_SGL />
> <NLRA_DBL />
> <CONS_SGL />
> <CONS_DBL />
> <GOVT_SGL />
> <GOVT_DBL />
> </ns0:ROOM_RATES>
> - <ns0:ROOM_RATES>
> <ROOM_TYPE_NUM>2</ROOM_TYPE_NUM>
> <RACK_SGL />
> <RACK_DBL />
> <CORP_SGL />
> <CORP_DBL />
> <LRA_SGL>234</LRA_SGL>
> <LRA_DBL>234</LRA_DBL>
> <NLRA_SGL />
> <NLRA_DBL />
> <CONS_SGL />
> <CONS_DBL />
> <GOVT_SGL />
> <GOVT_DBL />
> </ns0:ROOM_RATES>
> </ns0:SEASON_RATES>
> </ns0:CS>
> - <ns0:SA>
> <REST_ONSITE>Y</REST_ONSITE>
> <LOUNGE_BAR>N</LOUNGE_BAR>
> <REST_MEALSBK>Y</REST_MEALSBK>
> <REST_MEALSLUN>N</REST_MEALSLUN>
> <REST_MEALSDIN>Y</REST_MEALSDIN>
> <RM_SRV_AVL>N</RM_SRV_AVL>
> <RM_SRV_HRS>01:00-08:01</RM_SRV_HRS>
> <RECEPTION>N</RECEPTION>
> <RECEPT_DAYS>Monday</RECEPT_DAYS>
> <GIFT_NEWS>Y</GIFT_NEWS>
> <CONVENENCE_FOOD>N</CONVENENCE_FOOD>
> <GROCERY_SVC>Y</GROCERY_SVC>
> <CASH_ONSITE>N</CASH_ONSITE>
> <FITON_CENT>Y</FITON_CENT>
> <FITON_TYPE />
> <FITOFF_CENT>Y</FITOFF_CENT>
> <FITOFF_TYPE>E</FITOFF_TYPE>
> <REC_COURT>N</REC_COURT>
> <CONC_SERV>N</CONC_SERV>
> <BUS_CENTER>Y</BUS_CENTER>
> <BUS_SERV>Y</BUS_SERV>
> <IN_POOL>N</IN_POOL>
> <OUT_POOL>Y</OUT_POOL>
> <WHIRLPOOL>Y</WHIRLPOOL>
> <SAUNA>Y</SAUNA>
> <VIDEO_RENT>N</VIDEO_RENT>
> <PARKING>N</PARKING>
> <VALET_PARKING>N</VALET_PARKING>
> <DAILY_PARK_FEE>5</DAILY_PARK_FEE>
> <PARKFEE_MANAGED_HOTEL>N</PARKFEE_MANAGED_HOTEL>
> <STORAGE>N</STORAGE>
> <STORAGE_FEE />
> <SAFEBOX>Y</SAFEBOX>
> <LAUN_DRY>Y</LAUN_DRY>
> <LAUNDRY_SITE>Y</LAUNDRY_SITE>
> <LAUNDRY_HOURS>00:00 - 23:58</LAUNDRY_HOURS>
> <IRON_BOARD>N</IRON_BOARD>
> <HAIR_DRY>N</HAIR_DRY>
> <ALM_CLOCK />
> <TV_CABLE>N</TV_CABLE>
> <TV_MOVIE>N</TV_MOVIE>
> <STEREO>N</STEREO>
> <VCR>N</VCR>
> <DVD>N</DVD>
> <MINI_FRIG>N</MINI_FRIG>
> <MICRO>N</MICRO>
> <COFF_TEA>N</COFF_TEA>
> <MINIBAR>N</MINIBAR>
> <PRESS>N</PRESS>
> <WORKDESK>N</WORKDESK>
> <NEWS_PAP>N</NEWS_PAP>
> <BATHROBE>N</BATHROBE>
> <SOFA_BED>N</SOFA_BED>
> <IN_SAFE>N</IN_SAFE>
> <SAFE_CHG>0</SAFE_CHG>
> <AIR_CONDITIONED>N</AIR_CONDITIONED>
> <IN_SELF_TEMP>N</IN_SELF_TEMP>
> <PRIVATE_BATHSA>Y</PRIVATE_BATHSA>
> <STOVE>N</STOVE>
> <OVEN>N</OVEN>
> <TOASTER>N</TOASTER>
> <REFRIGERATOR>N</REFRIGERATOR>
> <DISHWASHER>N</DISHWASHER>
> <DINING_WARE>N</DINING_WARE>
> <DISHES>N</DISHES>
> <HOUSEKEEPING>W</HOUSEKEEPING>
> <HOUSE_FULL_OR_LIM>L</HOUSE_FULL_OR_LIM>
> <FRNT_DESK>00:00 - 23:57</FRNT_DESK>
> </ns0:SA>
> - <ns0:SS>
> <ROOMSMKDET>Y</ROOMSMKDET>
> <HALLSMKDET>NA</HALLSMKDET>
> <PUBSMKDET>N</PUBSMKDET>
> <HRDWIREDET>N</HRDWIREDET>
> <FIRE_EXTIN>Y</FIRE_EXTIN>
> <EMRGCYLITE>N</EMRGCYLITE>
> <VENT_STAIR>N</VENT_STAIR>
> <EVACPLAN>Y</EVACPLAN>
> <FIRELAWS>N</FIRELAWS>
> <VIS_ALARM>N</VIS_ALARM>
> <HALLVIS_ALARM>NA</HALLVIS_ALARM>
> <PUBVIS_ALARM>NA</PUBVIS_ALARM>
> <AUD_ALARM>Y</AUD_ALARM>
> <HALLAUD_ALARM>NA</HALLAUD_ALARM>
> <PUBAUD_ALARM>NA</PUBAUD_ALARM>
> <ROOMSPRINK>N</ROOMSPRINK>
> <HALLSPRINK>N</HALLSPRINK>
> <PUBSPRINK>N</PUBSPRINK>
> <EMRGCYINFO>N</EMRGCYINFO>
> <FIRE_LINK>N</FIRE_LINK>
> <MULT_EXITS>Y</MULT_EXITS>
> <AUTO_RECAL>N</AUTO_RECAL>
> <DISABACCSS>N</DISABACCSS>
> <NUMDISABL>3</NUMDISABL>
> <HAND_PARK>Y</HAND_PARK>
> <SECURITY>N</SECURITY>
> <SECUR_HRS>00:00 - 23:59</SECUR_HRS>
> <DEADBOLTS>N</DEADBOLTS>
> <PUBADDRESS>Y</PUBADDRESS>
> <INT_ACCESS>Y</INT_ACCESS>
> <OPEN_WINDOWS>Y</OPEN_WINDOWS>
> <SAFE_CODES>N</SAFE_CODES>
> <DOORS_CLOSE>Y</DOORS_CLOSE>
> <PARKGATES>NA</PARKGATES>
> <PARKPATROL>N</PARKPATROL>
> <PARKLIGHTS>NA</PARKLIGHTS>
> <PUBCAMERA>N</PUBCAMERA>
> <PARK_FR_ENT_CAMERA>NA</PARK_FR_ENT_CAMERA>
> <CAMERA_REC_24HR>NA</CAMERA_REC_24HR>
> <CAMERA_MONT_24HR>NA</CAMERA_MONT_24HR>
> <VIEWPORTS>N</VIEWPORTS>
> <BACK_UP>N</BACK_UP>
> <ALARMS_CONT_MONT>N</ALARMS_CONT_MONT>
> <EXT_DOOR_KEY_ACCESS>N</EXT_DOOR_KEY_ACCESS>
> <STAFF_AID>Y</STAFF_AID>
> <STAFF_CPR_TRAIN>N</STAFF_CPR_TRAIN>
> <STAFF_CPR_CERT>N</STAFF_CPR_CERT>
> <STAFF_AED>N</STAFF_AED>
> <MEDICAL_EQUIP>N</MEDICAL_EQUIP>
> <AED_ONSITE>N</AED_ONSITE>
> </ns0:SS>
> - <ns0:GT>
> <TRAIN_NAME>23</TRAIN_NAME>
> <DIST_TRAIN>0.10000000000000001</DIST_TRAIN>
> <METRO_NAME />
> <METRO_DIST>0</METRO_DIST>
> <CITYTRANS>N</CITYTRANS>
> <CARRENT>N</CARRENT>
> <CARRENT_NAME>first</CARRENT_NAME>
> - <ns0:AIRPORT>
> <AIR_CODE>ANA</AIR_CODE>
> <AIR_DIRECT>N</AIR_DIRECT>
> <AIR_DIST>.00</AIR_DIST>
> <AIR_SHUTTL>N</AIR_SHUTTL>
> <AIR_TAXI>0</AIR_TAXI>
> <AIR_PUB>N</AIR_PUB>
> <DIRECTION />
> </ns0:AIRPORT>
> </ns0:GT>
> - <ns0:CT>
> <TWOLINE>Y</TWOLINE>
> <VOICEMAIL>N</VOICEMAIL>
> <DIRECT_DIAL>Y</DIRECT_DIAL>
> <SPEAKPHONE>Y</SPEAKPHONE>
> <CORDPHONE>Y</CORDPHONE>
> <MOBILE_PH>Y</MOBILE_PH>
> <RM_FAX>Y</RM_FAX>
> <RM_PRINT>Y</RM_PRINT>
> <ELEC_DESK_OUT>Y</ELEC_DESK_OUT>
> <TEL_JACK_ADP>Y</TEL_JACK_ADP>
> <ELEC_ADP>Y</ELEC_ADP>
> <POWER_CONV>Y</POWER_CONV>
> <NUM_PHONE>12</NUM_PHONE>
> <PHONE_BILL_SEP>N</PHONE_BILL_SEP>
> <IN_FAX>0</IN_FAX>
> <IN_FAX_ADD>0</IN_FAX_ADD>
> <IN_FAX_COMM />
> <OUT_FAX>0</OUT_FAX>
> <OUT_FAX_ADD>0</OUT_FAX_ADD>
> <OUT_FAX_COMM />
> <LOCALCALL_FEE />
> <CCARD_FEE />
> <OPER_FEE />
> <TOLL_FEE />
> <INTL_FEE />
> <CARACC_FEE />
> <AN_DATAPORT>Y</AN_DATAPORT>
> <AN_DATAPORT_NUM>0</AN_DATAPORT_NUM>
> <AN_DATAPORT_CHG>0</AN_DATAPORT_CHG>
> <INTER_TV>Y</INTER_TV>
> <INTER_TV_NUM>0</INTER_TV_NUM>
> <INTER_TV_CHG>0</INTER_TV_CHG>
> <HIGHSPEED_INROOM>Y</HIGHSPEED_INROOM>
> <HIGHSPEED_INROOM_NUM>0</HIGHSPEED_INROOM_NUM>
> <HIGHSPEED_INROOM_CHG>0</HIGHSPEED_INROOM_CHG>
> <WIRELESS>Y</WIRELESS>
> <WIRELESS_CHG>0</WIRELESS_CHG>
> <INROOM_PC>N</INROOM_PC>
> <INROOM_PC_CHG />
> <AN_DATAPORT_BC>N</AN_DATAPORT_BC>
> <AN_DATAPORT_BC_CHG />
> <HIGHSPEED_BC>N</HIGHSPEED_BC>
> <HIGHSPEED_BC_CHG />
> <WIRELESS_BC>N</WIRELESS_BC>
> <WIRELESS_BC_CHG />
> <PC_BC>N</PC_BC>
> <PC_BC_CHG />
> <AN_DATAPORT_PA>Y</AN_DATAPORT_PA>
> <AN_DATAPORT_PA_CHG />
> <HIGHSPEED_PA>N</HIGHSPEED_PA>
> <HIGHSPEED_PA_CHG />
> <WIRELESS_PA>N</WIRELESS_PA>
> <WIRELESS_PA_CHG />
> <PC_PA>N</PC_PA>
> <PC_PA_CHG />
> <INDV_FOLIOS>Y</INDV_FOLIOS>
> <FOLIOS_COMPANY>Y</FOLIOS_COMPANY>
> </ns0:CT>
> - <ns0:ES>
> - <ns0:SEASON_RATES_ES>
> <SEASON_START_ES>2002-01-01</SEASON_START_ES>
> <SEASON_END_ES>2002-12-31</SEASON_END_ES>
> - <ns0:LOS_TIER>
> <LOS_TIER_NUM>2</LOS_TIER_NUM>
> - <ns0:ROOM_RATES_ES>
> <ROOM_TYPE_NUM>1</ROOM_TYPE_NUM>
> <CORP_ES_SGL />
> <CORP_ES_DBL />
> <LRA_ES_SGL />
> <LRA_ES_DBL />
> <NLRA_ES_SGL />
> <NLRA_ES_DBL />
> <CONS_ES_SGL />
> <CONS_ES_DBL />
> </ns0:ROOM_RATES_ES>
> - <ns0:ROOM_RATES_ES>
> <ROOM_TYPE_NUM>2</ROOM_TYPE_NUM>
> <CORP_ES_SGL />
> <CORP_ES_DBL />
> <LRA_ES_SGL />
> <LRA_ES_DBL />
> <NLRA_ES_SGL />
> <NLRA_ES_DBL />
> <CONS_ES_SGL />
> <CONS_ES_DBL />
> </ns0:ROOM_RATES_ES>
> </ns0:LOS_TIER>
> </ns0:SEASON_RATES_ES>
> - <ns0:ADDTL_CHARGE_ES>
> <ROOM_TYPE_NUM>1</ROOM_TYPE_NUM>
> </ns0:ADDTL_CHARGE_ES>
> </ns0:ES>
> - <ns0:Errors>
> - <ns0:Error1>
> <FieldName>SEASON 1 SINGLE ROOM</FieldName>
> <Description>Rack is empty or not an number; Corp is
> empty or not an number; LRA is empty or not an number;
> Consortia is empty or not an number;</Description>
> </ns0:Error1>
> - <ns0:Error2>
> <FieldName>SEASON 1 DOUBLE ROOM</FieldName>
> <Description>Rack is empty or not an number; Corp is
> empty or not an number; LRA is empty or not an number;
> Consortia is empty or not an number;</Description>
> </ns0:Error2>
> </ns0:Errors>
> </ns0:X_NBTA05>

Alternative to Microsoft?

I have to implement a simple Merge-Replication, using the MSDE.
That means, I cant using Enterprice-Manager.
I dont want using SQLDMO because of redistribution-problems.
Using T-SQL, it is quite difficult to implement Merge-Replication.
Are the thrid-pary-products, ActiveX-Controls, Libraries, assembly,
etc. that manage SQL-Server-Replication very well?
What do you think about writing your own merge-replication tool? I
just wrote a prototyp, and it seems to be very easy.
pro:
- no limitations on changing data strukturs while publishing tables
!!!
- using a connection in ONE direction (no re-connect from subscriber
to distritubor necessary, ideal for replication into internet !! )
- high level of transparency, you can debug each step, you can log
each SQL-Statement
- if you want to use a single-sided replication (like transactional
replication) the subscriber database need not implement anything (no
table, no trigger, nothing!!)
- few overhead: just adding 3 triggers per table (like
MS-merge-replication does) and 2 or 3 system-tables
- very simple code to switch on replication (just adding the 3
triggers to each table, independent on data strukture)
contra:
- replication-process itself is not tested, each possible event have
to be implemented and well tested
I would be happy if someone would like to diskuss this with me, or if
someone has just written a tool like this, or have another good idea.
Andreas Lauffer, Germany
answers in line.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Andreas Lauffer" <al@.lauffers.de> wrote in message
news:6e97e7d4.0502210327.44c6f52f@.posting.google.c om...
> I have to implement a simple Merge-Replication, using the MSDE.
> That means, I cant using Enterprice-Manager.
> I dont want using SQLDMO because of redistribution-problems.
SQLDMO uses stored procedures under the covers, so I would advise you to use
the replication stored procedures - or possibly the replication activeX
controls.

> Using T-SQL, it is quite difficult to implement Merge-Replication.
> Are the thrid-pary-products, ActiveX-Controls, Libraries, assembly,
> etc. that manage SQL-Server-Replication very well?
The only product out there that I know of which handles bi-directional
replication is DataMirror - and in my experience if you are having problems
with merge replication you will also have problems with Data Mirror.

> What do you think about writing your own merge-replication tool? I
> just wrote a prototyp, and it seems to be very easy.
>
It is possible, however merge replication has been designed to handle
conflicts and has 6 or more years of research, customer experience behind
it.

> pro:
> - no limitations on changing data strukturs while publishing tables
> !!!
bi-directional transactional replication does not require changes to data
structures either.

> - using a connection in ONE direction (no re-connect from subscriber
> to distritubor necessary, ideal for replication into internet !! )
replication only requires a connection inbound or outbound, not both ways as
well.

> - high level of transparency, you can debug each step, you can log
> each SQL-Statement
> - if you want to use a single-sided replication (like transactional
> replication) the subscriber database need not implement anything (no
> table, no trigger, nothing!!)
Transactional replication has an option to replicate using pure SQL
statements as well - however there is a severe performance penalty to pay
for doing this on larger tables.
> - few overhead: just adding 3 triggers per table (like
> MS-merge-replication does) and 2 or 3 system-tables
> - very simple code to switch on replication (just adding the 3
> triggers to each table, independent on data strukture)
>
Watch out for triggers - there is a performance impact for doing this,
especially if you are replicating over a network.

> contra:
> - replication-process itself is not tested, each possible event have
> to be implemented and well tested
> I would be happy if someone would like to diskuss this with me, or if
> someone has just written a tool like this, or have another good idea.
> Andreas Lauffer, Germany
|||"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message news:<OHWyUIBGFHA.3824@.TK2MSFTNGP10.phx.gbl>...

> It is possible, however merge replication has been designed to handle
> conflicts and has 6 or more years of research, customer experience behind
> it.
OK, this is the most substantial argument agains my idea.

>
> bi-directional transactional replication does not require changes to data
> structures either.
I mentioned the problem, that you cannot change any application data
structure if there are publications and articles on your database.

>
> replication only requires a connection inbound or outbound, not both ways as
> well.
Please look in the thread
"Push-Replication with Internet-Connection" within this group.
http://groups.google.de/groups?hl=de...%26start%3D125
I tried to discuss this topic there. A subscriber definitly wants to
connect to the distributor. This could be a huge problem behind a
firewall.

> Transactional replication has an option to replicate using pure SQL
> statements as well - however there is a severe performance penalty to pay
Could a transactional replication replace a merge replication?
Another point is the fact, that transactional replication cannot be
used with MSDE.

> Watch out for triggers - there is a performance impact for doing this,
> especially if you are replicating over a network.
MS Merge Replication also implement 3 triggers per table for
replication.
Andreas Lauffer, Germany
|||Answer's inline.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Andreas Lauffer" <al@.lauffers.de> wrote in message
news:6e97e7d4.0502220205.3a6c23e8@.posting.google.c om...
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:<OHWyUIBGFHA.3824@.TK2MSFTNGP10.phx.gbl>...[vbcol=seagreen]
behind
> OK, this is the most substantial argument agains my idea.

[vbcol=seagreen]
data
> I mentioned the problem, that you cannot change any application data
> structure if there are publications and articles on your database.
Let's back up here. Merge, Queued and Immediate make schema changes to your
tables - bi-directional transactional does not.
[vbcol=seagreen]
ways as
> Please look in the thread
> "Push-Replication with Internet-Connection" within this group.
>
http://groups.google.de/groups?hl=de...%26start%3D125
> I tried to discuss this topic there. A subscriber definitly wants to
> connect to the distributor. This could be a huge problem behind a
> firewall.
>
Are you sure this is the correct thread - this is a thread you and I were
involved in some time ago. To continue that thread, if the publisher and the
distributor are on the same machine you don't have a problem. When the
publisher and subscriber are on different machines you will need to map a
drive to the distributor to push the snapshot. Locally no problem, if it a
pull it can be problematic, unless the subscriber can map a drive to the
snapshot share on the publisher or subscriber.
If there is a firewall, firewalls can be configured to allow inbound or to
allow outbound or both. Most security admins will lock down ports and only
open certain ports for inbound, outbound, or both. This means that if port
1433 is open for outbound traffic a subscriber accross the internet will be
unable to create an inbound connection to the publisher/distributor. If port
1433 is open for inbound traffic, then the subscriber can. Communication
after the session is established will be bi-directional. The blocking is
only done on the initiating session.
So, for a pull subscriber if ports 1433 and 21 are open for inbound you will
not have a problem with a pull.
[vbcol=seagreen]
pay
> Could a transactional replication replace a merge replication?
> Another point is the fact, that transactional replication cannot be
> used with MSDE.
It could in some limited circumstances. 1) few nodes, 2) well connected, 3)
perfectly partitioned to minimize conflicts or transactions only occur on
one node at a time.
>
> MS Merge Replication also implement 3 triggers per table for
> replication.
Yes, this is true - merge replication does not offer the performance of
transactional replication for this and other reasons. However, for
frequently disconnected clients, or when a large part of your changes are
updates, merge can offer better performance. For instance if you have a
stock market application when stock prices vary all over the place thousands
of times per day, and you only replicate data a few times per day, merge
will offer much better performance as only the changes are going accross the
wire. Also if your data changes are small merge is better. So if you have a
sales force and the sales agents don't generate a significant amount of
sales compared to the volumn of data, merge will offer better performance.
> Andreas Lauffer, Germany
Hilary Cotter, USA