SQL To RSS Feed?

Nov 6, 2006

Hi,

Not sure if this is the right board as it could be in the XML one aswell...

I'm fairly ok with ASP2.0 and used it to build a database driven website: www.trailandtrack.co.uk however, I want to create an RSS feed of the trails that are on the site.

The trails are all in a MSSQL2000 database, and are all keyed on a unique ID which is used to retreive the trail info from the database (using querystrings)

 I want to create an automatic RSS feed that gets updated automatically from the database whenever new trails are added. Giving the Title as the Trail Name, Link But using the standard URL: http://www.trailandtrack.co.uk/usertrail.aspx?trailid=123 (if you go this this page you'll see the feidl placeholders)

Only thing is Ive not got a clue how to go about creating an RSS feed to do this, can anyone help?? (I can do a manual one fine, no probs, but automatically - it's a bit out of my debth)

 Thanks

 

 

View 1 Replies


ADVERTISEMENT

XML Feed Into Database

Apr 7, 2006

Hi everyone

I have been tasked on importing an xml feed into a sql server 2005 database. Now I am a network guy so I am completely clueless here.

Could anyone help?

http://www.iafrica.com/content_feeds/business/worldatsix.xml

Need to bring that into a database table (not created yet)

Any help would be appreciated

Thanks

View 3 Replies View Related

What Is Data Feed?

Mar 12, 2004

Hello Friends,

I would like to know what Data Feed means while working as an Administrator on Ms SQL Server 2000?
Also what do you mean by integrating feed of data?
I would appreciate it if anyone could help me out with this queries...
Also I was wondering which would be best book to refer while learning about ms sql server 2000.

View 6 Replies View Related

Create RSS Feed

Sep 4, 2007

Is it possible to create an RSS file from directly MS SQL 2005? I'd like to create a task to produce a file daily and place it on a web server.

Ryan

Ryan Everhart
The New AT&T

View 4 Replies View Related

XML Data Feed

Dec 29, 2005

Hello,I have an XML data feed that I would like to use to create tables inSQL Server. The xml data feed consists of a large amount ofinformation that changes on a regualar basis. Is there a way toautomatically create SQL Server tables using the data feed?ThanksBilly

View 7 Replies View Related

TablesList Feed

Mar 29, 2007

Hi,


if I have one table to transfer I can use the following to amend the tableslist





Imports System.Collections.Specialized

Public Sub Main()

Dim application As Microsoft.SqlServer.Dts.Runtime.Application = New Application()

Dim packagename As Object = Dts.Connections("Tables").AcquireConnection(Nothing)

Dim package As Microsoft.SqlServer.Dts.Runtime.Package = application.LoadPackage(packagename.ToString(), Nothing)

Dim th As TaskHost

th = package.Executables("TablesToMove")

Dim sc As StringCollection = New StringCollection()

sc.Add(Dts.Variables("Tables1").Value.ToString())




th.Properties("TablesList").SetValue(th, sc)

application.SaveToXml(packagename, package, Nothing)

Dts.TaskResult = Dts.Results.Success

End Sub







now if I have a list of tables (as an SSIS object time ) how can amend this script to table the objetc rather than feeding each table





Thanks

View 7 Replies View Related

2 Matrices, Line Feed

Mar 4, 2008

I have two matrices aligned on one line (side by side). When I preview the report in BIS, the output shows the two matrices on the same line.

When I run the report from report manager, the output shows the two matrices with a line feed (the second matrix is on line 2). All of the rest of the report is aligned properly until I put two matrices next to each other. Then it seems to randomly throw in a line feed. The page width for the report layout seems to be more than enough to accomodate the matrices.

Why is this happening?

View 3 Replies View Related

Insert Line Feed In Query

Aug 13, 2007

Hi,
    I want to insert line feed. I have used char(10) and char(13) function. But I could not  insert line feed.    Ex: set error1= 'error description' + char(10)+ 'Employee'
Output must be: error description                Employee
Any suggestions are welcome.

View 8 Replies View Related

Generating RSS Feed From Sql Server 2005

Nov 16, 2007

Hi every one 
I want to generate a RSS Feed from SQL Server 2005.
The scenario is that when a record is entered in the database, the database fire a trigger which generate rss feed for the new record entered in the data base
 Thanx in advance
Take care
Bye

View 5 Replies View Related

Microsoft Neural Network, How Do I Feed It ?

Aug 1, 2006

Hello there,

I'm working with Analysis sevices 2005 developer edition. Looking through the documentation i becomes apperent that the NN algorithm takes 255 input attributes by default. This can be changed to any integer value, OK....

My problem is that I want to feed the network with 40000 input variables. In order to do so, I will have to do a select:

SELECT fld1, fld2, ...... fld39999, fld40000

FROM tblSometable



However, this is not possible, as the books online describes it is only possible to return 4096 columns from a select statement.

Question : How do I populate a NN in AS2005, with nmore than 4096 inputs ?!



View 3 Replies View Related

Need Line Feed In ToolTip Text - How?

Mar 28, 2007

Hello,



I am displaying a complex formula in a column header tool tip. The formula is generated in a stored procedure. (I do not enter the tool tip text directly in the column header expression.)



Within the stored procedure, how do I generate a string that contains a carriage return/line feed?



Thanks,

BCB

View 6 Replies View Related

Specifying Carriage Return/line Feed In An SQL Statement

Oct 19, 2001

Hi there, I hope you can help us.

We're using this statement to import some values into a database:
SQLStatement = "INSERT MyTable (ID, VALUE) VALUES ('" & IDString & "', '" & VALUEString & "')"

The problem is that the strings might contain carriage returns/line feeds, i.e.
VALUEString = "Line 1." & vbCrLf & "Line 2."

It only imports up until the first vbCrLf. We have tried replacing vbCrLf with "", but this doesn't work either. What is the correct format for inserting a value that contains new line characters?

Thanks for your time,
Lasse.

View 3 Replies View Related

Data Feed From DB2/AS400 To SQL Server 2000

Jun 13, 2001

I need to have an automated process to read data from DB2/AS400 and feed it to SQL Server 2000. Has anyone done this before? Any suggestions how it may be done? I know my company doesn't want to spend a lot to do this.

Thanks for your time.

View 2 Replies View Related

Data Feed / Make / Model Catalog

Mar 23, 2007

Does anyone know where to start if I want an exported copy of homeappliances, cars, cell phones etc.I just need to populate my database and I want to get some data feedfrom all the different types of manufactures.I think there are services out there. But I have not seen one.I want a CSV file that has all the make/models for lets say: TVs

View 1 Replies View Related

Feed Stored Procedure With SELECT Resultset

Jul 20, 2005

I have two SQL Server stored procedures, PROC1 and PROC2. PROC1 hasabout 50 input parameters. PROC2 is the main procedure that does somedata modifications and afterwards calls PROC1 using an EXECUTEstatement.The input parameter values for PROC1 are stored in a table in mydatabase. What I like to do is passing those values to PROC1 using aSELECT statement. Currently, all 50 parameters are read and stored ina variable, and afterwards they are passed to PROC1 using:EXEC spPROC1 @var1, @var2, @var3, ... , @var50Since it is a lot of code declaring and assigning 50 variables, I waswondering if there is a possibility to run a statement like:EXEC spPROC1 (SELECT * FROM myTable WHERE id = 2)Any help on this is greatly appreciated!

View 1 Replies View Related

Use Query Results To Feed Data Flow

Sep 24, 2007

Greetings,

I need some help determining the best way to accomplish my task. The workflow starts by generating a list of unique ID's from a local table. Then take that list of unique ID's and query an Oracle table for all matching records.

My thought was to first use an Execute SQL task with the following SQL:

select projectid from projectlist group by projectid

with Result Set configured as follows:

Result Name = projectid
Variable Name = varProjectIDList

Then in the Data Flow Task add a DataReader Source to pull the matching data. Here's where I'm getting hung up. I'd like to pass the result set from the Execute SQL task. I tried the following SQL but it doesn't work.

select * from masterlist where projectid = @[User::varProjectIDList]

I'm open to any suggestion on the best way to take my unique list and use it as input for a query against my Oracle DB.

Thank you for your ideas.

Rob


View 4 Replies View Related

Problem With Mailing Labels And Line Feed

Aug 15, 2007

I am trying to print mailing labels and suppress optional address lines to eliminate white space while maintaining label alignment. This is what I am trying but it does not work.

I create a function that determines the length of a field (i.e. street) and increments a counter if the length is zero. It also takes a second parameter that detremines whether to reset the counter. I then use the function in the visibility each row of the label table. Example iif(Code.LineLen(Fields!Street.Value)=0,True,False). I place this on the visibility of each row except the last as that is City,State,Zip and is required. On this last row the expession I use is

=Fields!city.Value & ", " & Fields!state.Value & " " & Fields!zip.Value & iif(Code.LineCount<5,StrDup(5-Code.LineCount,vbCRLF),""). What this is intended to do is print a carraige return and line feed for every row that did not print. Instead no line feeds occur. I have verified that the Code.LineCount is indeed calculating correctly (I printed the value). I've removed the conditional to make sure it has no issues but again nothing. For clarification the code block I am using is this.

Public LineCount as Integer=0

Function LineLen(byval LineIn as string,byval IsFirst as boolean) as Integer
if IsFirst=True then
LineCount=1
end if
If len(LineIn)>0 then
LineCount=LineCount+1
end if
LineLen=Len(LineIn)
end Function
So if anyone either knows why the line feeds do not occur or a better way to handle this please let me know. Thanks.

View 1 Replies View Related

All I Want To Do Is Feed A Varchar Into A Stored Procedure And Get An Id Back... What Am I Doing Wrong?

Dec 28, 2006

So I have been building stored procedures and things were working fine until I hit something that I am sure is incredibly simple to do; however, i have having a hell of a time with it.  Here is the code:#############################################ALTER PROCEDURE dbo.GetUserIdForUser  @username NVARCHARASBEGINDECLARE @postedbyid UNIQUEIDENTIFIERSET @postedbyid = (SELECT UserIdFROM aspnet_UsersWHERE (UserName = @username))END###Which returns this### Running [dbo].[GetUserIdForUser] ( @username = jason ).No rows affected.(0 row(s) returned)@RETURN_VALUE = 0Finished running [dbo].[GetUserIdForUser].############################################# This is part of a much larger stored procedure, but this is the point of failure in the stored procedure I am trying to build.  If anyone can tell me what I am doing wrong I would appreciate it.  I have tried a few things that have resulted in different failures.  If I remove any references to variables (delete SET @postedbyid = and replace @username with 'jason') I can get it to return a result.  If I put @username in though it doesn't work.  Here are the examples of those:ALTER PROCEDURE dbo.GetUserIdForUser  @username NVARCHARASBEGINSELECT UserIdFROM aspnet_UsersWHERE (UserName = @username)END###Which returns this###Running [dbo].[GetUserIdForUser] ( @username = jason ).UserId                                 -------------------------------------- No rows affected.(0 row(s) returned)@RETURN_VALUE = 0Finished running [dbo].[GetUserIdForUser].  Here is a sanity check to show that the data is in fact in the database:ALTER PROCEDURE dbo.GetUserIdForUserASBEGINSELECT UserIdFROM aspnet_UsersWHERE (UserName = 'jason')END Running [dbo].[GetUserIdForUser].UserId                                 -------------------------------------- No rows affected.(1 row(s) returned)@RETURN_VALUE = 0Finished running [dbo].[GetUserIdForUser]. Anyone have any ideas on what I am doing wrong?   

View 13 Replies View Related

How To Feed Specific Rows From Excel Spreadsheet To OLE DB Destination

Jan 2, 2008

Hi,

I am in a bit of a quandry. I have an Excel spreadsheet source, but I only want certain rows from the spreadsheet, which will be delineated by a header and footer row (Start and End). Here is my script thus far (see below).

My question is, what is the correct way to do this? I guess I am stuck on syntax. i.e.) Do I need to create an OUTPUT BUFFER?

Thanks

==============================

Sample data:
blah
Start
Frank 1234 1234 1234
Sue 2345 2345 2345
End
blah
blah

==============================


Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

Static Section As String


'Set sections

If Row.Name = "Start" Then


Section = "Start"

End If

If Row.Name = "End" Then


Section = "End"

End If


If Section = "Start" Then

'GRAB THESE ROWS AND SEND THROUGH THE PIPELINE
'IGNORE ALL OTHER ROWS!
'What syntax goes here?
'Output buffer?



End If


End Sub

View 9 Replies View Related

Replace Carriage Return And Line Feed In A Text Column?

May 18, 2004

Hi,

I've a text column (text datatype) that contains carriage return and line feed.

Syntax-wise, how can I replace these by a space?

Thanks.

View 1 Replies View Related

SQL 2012 :: Count Records From Each Separate Data Table Corresponding To Feed

Nov 5, 2014

I have 1 table that is just a list of feeds. A, B, C, D etc (15 rows in total) and each feed has other information attached to it such as Full name, location etc etc. I am only interested in the Feed column.

Each feed then has a corresponding data table which contains a list of records. Eg Feed A data is contained in TableA, Feed B data is contains in TableB and so on.

Basically what I need is a combined table that shows the list of Feeds in the 1st Column ( So A, B, C, D…..) and then a second column which counts the records from each separate data table corresponding to that feed.

So the end result would look something like this:

Feed------No of Records
A----------4 (from TableA)
B----------7 (from TableB)
C----------8 (from TableC)
D----------1 (from TableD)

Possible?

View 2 Replies View Related

T-SQL (SS2K8) :: Import Data From XML Feed To Get Daily Exchange Rates

Aug 26, 2015

I'm trying to find a way to import data from this data xml feed to get daily exchange rate. I' tried:

select *
from
openrowset(bulk 'http://www.bankofcanada.ca/stats/assets/xml/fx-noon.xml',single_blob) as x

Which is a feeble attempt at a start; however, am getting this error message:

Cannot bulk load because the file "http://www.bankofcanada.ca/stats/assets/xml/fx-noon.xml" could not be opened. Operating system error code 123(The filename, directory name, or volume label syntax is incorrect.).

How to parse this file using SQL.

View 1 Replies View Related

Remove The Last Carriage Return And Line Feed From Sql Text Field

Jun 12, 2007

I am trying to write a user defined function that will allow me tostrip off the last carriage return and line feed from a text field.We have address fields stored in a text field for our ERP system andsome of them have an extra carriage return and line feed at the end ofthem. This causes havoc when we sync between our ERP system and CRMsystem. If anyone knows a way to solve this problem the help would beappreciated.Examples:Existing Text field with CR:1234 Blah Street<CR>Suite 2345<CR>Corrected Text field:1234 Blah Street<CR>Suitr 2345

View 4 Replies View Related

Dynamic Feed Of Table Name To Transfer SQL Server Object Task

Jan 10, 2007

Hi
I would like to be able to feed the List of tables to the Transfer SQL Server Object Task dynamically.
I have got a foreachloop container which it feeds the table names into a variable @table_name (string).

Transfer SQL Server Object Task is with in foreachloop container

I did add an expression into the property of Transfer SQL Server Object Task and assign the tablelist property to @table_name


I would be grateful if you can give me any hint.
Thanks
S

View 19 Replies View Related

Transact SQL :: FOR XML To Write Data With Carriage Return / Line Feed At End Of Elements?

Sep 30, 2015

I am trying to use FOR XML under SQL Server 2014 to write out a large XML data set. I want it to look like

<CVS_Member_Add_Change>
    <RecordType>3</RecordType>
    <Carrier>1266</Carrier>
    <MultiBirthCode>0000000</MultiBirthCode>
    <MemberType></MemberType>

[Code] ....

That's how it looks when you click on the results of a small subset of the query.  Just what I want.  Unfortunately when you try to right click and save it you get 

<dataroot><CVS_Member_Add_Change><RecordType>3</RecordType><Carrier>1266</Carrier<MultiBirthCode>0000000</MultiBirthCode><MemberType></MemberType<LanguageCode>1</LanguageCode><DURFlag></DURFlag><DURKey></DURKey><SocialSecurityNumber>000000000</SocialSecurityNumber</CVS_Member_Add_Change>

Everything being on one line blows up the translator application that reads the data.

The FOR XML statement copied out of the query is below.

FOR XML RAW ('CVS_Member_Add_Change'), ROOT('dataroot'), ELEMENTS 
GO

Is there a way in the T-SQL to force it to break lines neatly?

Is there a way to force it to a specific file name or directory?

View 3 Replies View Related

Reporting Services :: SSRS Multi-Value Parameter Feed To Table Value Function

Jul 24, 2015

I have an SSRS report with several variables, some of which are multi-valued.  The main query that feeds the report uses some table value functions.  For example, the query looks something like this:

select tv1.a, tv1.b, tv2.x, tv2.y, tbl.m, tbl.n
from tableValueFunction1(@MultiValueParam) as tv1
inner join tableValueFunction2(@MultiValueParam) as tv2 on tv1.xxx = tv2.xxx
inner join regularTable as tbl on tv1.xxx = tbl.xxx

where tbl.abc in (@MultiValueParam).When I try to run this, I get an error saying that I'm feeding the wrong number of parameters into the table value functions.  I've fed multi-valued parameters to stored procedures before and used a splitter function to split out the comma separated values, so I was planning to do the same thing in this scenario.  However, this is different.  When I look at the query in SQL Profiler, it shows discrete values for the multi value parameter.  For example, the same query above looks like this when viewed through the profiler (using 1,2,3 as my multi-value selection):

select tv1.a, tv1.b, tv2.x, tv3.y, tbl.m, tbl.n
from tableValueFunction1(1,2,3) as tv1
inner join tableValueFunction2(1,2,3) as tv2 on tv1.xxx = tv2.xxx
inner join regularTable as tbl on tv1.xxx = tbl.xxx
where tbl.abc in (1,2,3)

In other words, SSRS isn't converting the multi-value parameter to a comma separated string, like it normally does.

View 2 Replies View Related

SSIS Flat File Connection Manager Not Seeing Carriage Return-line Feed

Apr 29, 2006

I have a csv file as follows:

"100,002.01","200,00.01",10.98,aaaaaaa,bbbbbbbbbb
"100,002.01","200,00.01",10.98,aaaaaaa,bbbbbbbbbb
"100,002.01","200,00.01","1,000.98",aaaaaaa,bbbbbbbbbb

Note that the third column in the third line is also qualified by quotes whereas the previous two are not. I think this is because of Excel formatting. Is there any way to import this file correctly?

My main problem is that I never know whether a column will be qualified or not because this depends on the value. I need to loop through and import many of these files so a manual workaround is not a option for me.

View 22 Replies View Related

How Can I Remove The Line Feed/carriage Return In The Last Line Of The Exported Text File ?

Feb 27, 2007

Hi,
for some AP issue, the file I upload must be without the line feed/carriage return in the last line.
for example:

original fixed-length file (exported from SSIS)
line NO DATA
1 AA123456 50 60
2 BB123456 30 40
3 CC123456 80 90
4 <-- with line feed/carriage return in the last line

The file format that AP request. The file only has 3 records, so it should end in the third line.
line NO DATA
1 AA123456 50 60
2 BB123456 30 40
3 CC123456 80 90

Should I use script component to do it ? I am new for VB . Anyone would help me ?

Thank you all.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved