im trying to output an xml file and having some troubles with this one section
im assuming its because the field may contain html formatted info but i have even tried it with cdata but still i get this error.
Illegal XML character: #x0;.
Illegal XML character: #x0;.
i been up toolong to rack my
btw~ the error is in the content field
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
I have to write some instructions for PHP users to consume a web service
I've made available, but I don't know much about PHP.Certainly not enough
to write the instructions for them to use in their website.
Is there some kind soul who knows about PHP and web services who can help me
with this
I'm getting this error from a form submission (autoid is an integer
column that is set to be the identity column)... having only used
access in the past, I'm not sure how to resolve this. I would think the
autoid column would automatically increment because it is set to
identity . do you have to
I have 6 records in a CVS List.
How can I know which record the loop is in on a cfloop?
ie.. which variable can I output to see which record it is looking at?
JT
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
BTW I am treating the loop as a list.
-Original Message-
From: JT [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 10:16 AM
To: CF-Talk
Subject: How can I know which record the loop is in
I have 6 records in a CVS List.
How can I know which record the loop is in on a cfloop?
Tim,
Make sure that the datatype of the column i set to int. In addition, down in
the column attributes area (assuming you are using enterprise manager) set
the identity attribute to yes and make sure that the Identity Seed and
Identity Increment attributes have a value.. usually 1 and 1 by
The problem you are running into is that #x0; is and illegal XML
character :). If you check a Unicode chart (
http://www.cs.newcastle.edu.au/~c3018900/unicode.html#x )
You'll notice from 0x001F down are control characters (this is the same
as ASCII I believe). Some non-printable control
cfoutput
cfset ListOfSix=Item1,Item2,Item3,Item4,Item5,Item6
cfset Counter=1
cfloop list=#ListOfSix# index=LoopListIndex
#Counter# #LoopListIndex#br
cfset Counter=Counter+1
/cfloop
/cfoutput
-Original Message-
From: JT [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 9:16 AM
Michael... thanks... all of those things are set as you indicated...
interestingly enough, it works on my development box but now on the
ISP's SQL server... I use crystaltech for hosting
-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15,
Just what I was looking for thx a million
-Original Message-
From: B. Patrick Ledwith [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 10:35 AM
To: CF-Talk
Subject: RE: How can I know which record the loop is in
cfoutput
cfset ListOfSix=Item1,Item2,Item3,Item4,Item5,Item6
cfset
Tim, right click on the table and generate the sql script for it... then
post the script to the list.. I'll take another look.
Mike
_
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 12:43 PM
To: CF-Talk
Subject: RE: SQL server question
Michael... thanks...
maybe find some info here
http://www.sephiroth.it/
I have to write some instructions for PHP users to consume a web service
I've made available, but I don't know much about PHP.Certainly not
enough to write the instructions for them to use in their website.
Is there some kind soul who
its just coming out of a db that wasnt made for xml, just trying to redo it.
luckly there isnt awhole lota info in there. I guess I'll go clean it up
ty :)
The problem you are running into is that #x0; is and illegal XML
character :). If you check a Unicode chart (
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[properties]') and OBJECTPROPERTY(id, N'IsUserTable')
= 1)
drop table [dbo].[properties]
GO
CREATE TABLE [dbo].[properties] (
[autoid] [int] IDENTITY (1, 1) NOT NULL ,
[mls_no] [nvarchar] (50) COLLATE
Did you send them a copy of the db or a script? sometimes it just will not
put the IDENTITY value on the column when restoring a db.
And just to be sure, you are not trying to insert anything in the identity
column?
Taco Fleur
Bloghttp://www.tacofleur.com/index/blog/
If you are looping over a query you could use
queryName.currentRow
Taco Fleur
Bloghttp://www.tacofleur.com/index/blog/
http://www.tacofleur.com/index/blog/
Methodology http://www.tacofleur.com/index/methodology/
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
No... not trying to insert anything there I'll check that column on
their server to make sure its identity
-Original Message-
From: Taco Fleur [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 3:27 PM
To: CF-Talk
Subject: RE: SQL server question
Did you send them a copy of
THAT WAS IT !... they didn't have the identity value set... thanks much
-Original Message-
From: Taco Fleur [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 3:27 PM
To: CF-Talk
Subject: RE: SQL server question
Did you send them a copy of the db or a script? sometimes it just
I have a website that doesn't get continuous load sometimes going an
hour between hits.I have noticed that after some time of inactivity
the system seems to go to sleep and when I request comes it takes many
seconds to startup.I could get around this by having the cf scheduler
request a page
I have the feeling that is because you are setting application variables,
that time out after an X period, and the first time your website is hit it
has to recreate the application variables. What variables are you setting?
If this is the case, you could set up a scheduled task to hit the page
Yes, I do use a couple application session variables for display
settings, and login function.I don't understand why this would slow
down the issuance of a page after inactivity as opposed to an additional
request after the website was instantiated.If I do use the cf
scheduler to hit a page the
It all depends on what kind of variables you set, if its something as simple
as application.color = blue; then no, this would not cause a delay, but if
you are copying objects into the application scope, or perform other
resource hogging functions, then yes it would cause a delay. Simply because
!--- First declare the application and manage whitespace ---
cfapplication name=securityf clientmanagement=yes
sessionmanagement=yes setclientcookies=yes
clientstorage=clientVariables
!--- Session Variables to replace the number of columns and total
pictures users may set during a visit ---
Just wondering if any one has some examples of how I can do the following.
I need to do a freetext search on two tables and return the selections by rank - this is what I came up with but of course gets a syntax error (no sql manual around today !) - any suggestions would be much appreciated.
What's the error you are getting?
Did you actually create the full-text catalog on the columns?
Taco Fleur
Bloghttp://www.tacofleur.com/index/blog/
http://www.tacofleur.com/index/blog/
Methodology http://www.tacofleur.com/index/methodology/
Tell me and I will forget
Show me and I will
yep catalogs are created and I can do a freetext search on just one :-
SELECT rank,id,name,instructions
FROM recipes as ft_tbl
INNER JOIN
freetextTABLE (recipes,*,'#class#',100) AS KEY_TBL
ON ft_tbl.ID = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK desc
and it works great but with the code I wrote for
I have not done any full text search like you have, but I did notice
that there is a comma after the first INNER JOIN.I have written many
queries with joins and have not used a comma after an inner join.that
is probably your issue.
SELECT name,
FROM table1 as ft_tbl,
table2 as ft_tbl2
INNER
I don't suppose anyone knows how to get SESConverter working (Fusebox 3
site) on IIS6/CFMX6.1/Win2K3?
I remember the URLSCAN thing, but apparently IIS6 doesn't use AllowDotInPath anymore. I've got check that file exists disabled. URLs like index.cfm?fuseaction=whatever are working fine, but
Way to go kevin ! I didn't see that now at least I get a decent error message - of course I'm now even more confused !
[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'ft_tbl' does not match with a table name or alias name used in the query.
SQL = SELECT
Remove the as from cjprod as ft_tbl and peepers as ft_tbl2
--
marlon
And Bobby you are right, I am being selfish, but the last time I checked,
we don't have a whole lot of songs that feature the cowbell!
-Original Message-
From: admin [mailto:[EMAIL PROTECTED]
Sent: Sunday,
Thanks Marlon, but that still gives me the same error :-
[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'ft_tbl' does not match with a table name or alias name used in the query.
SQL = SELECT name,description,rank,sku,price,IMAGEURL FROM cjprod ft_tbl, peepers ft_tbl2 INNER
I'm presuming you're using SQL Server
Why aren't you using CONTAINS()? It's a lot easier to read than using
the FREETEXTTABLE() function IMO
-Original Message-
From: admin [mailto:[EMAIL PROTECTED]
Sent: 15 February 2004 19:22
To: CF-Talk
Subject: sot: SQL Freetext
Just
I've asked a client for a sample of their database so I can start to get
a handle on the structure before starting a project, and they've handed
my a CD full of BAK files.
Is anybody aware of a utility that would let me open/import SQL Server
BAK files into Access?
I'm not running SQL locally
That sounds more like MS SQL, a backup of the db, you need to restore them
from within MS SQL..
Taco Fleur
Bloghttp://www.tacofleur.com/index/blog/
http://www.tacofleur.com/index/blog/
Methodology http://www.tacofleur.com/index/methodology/
Tell me and I will forget
Show me and I will remember
I would set up SQL Server, then restore the DBs, then use DTS to migrate
the DB to access if you must have it in access.
Or tell the client you need it in access.
Although, if you really want to mirror the production environment, don't
use access at all.There are differences in the SQL syntax
36 matches
Mail list logo
