Adobe Community : All Content - All Communities

SQL LIKE statement to text field fomr CF MX 6.1

forums_noreply@adobe.com — Tue, 15 Apr 2008 00:37:25 GMT

Hi.

Here's my scenario. I am running SQL Server 2000 SP4 on a Windows 2003 Server running IIS 6. Using ColdFusion MX 6.1 Updater version.

I am storing HTML page code (some complete, some just clips) in a text type field.

I need to check to see if someone has already saved that exact code already before. So I do the following query:

<cfquery name="checkforexisting" datasource="mydatasource">
SELECT smallfieldtogetareturn
FROM MyTable
WHERE MyTextField LIKE '%#mystringoflongdata#%'
</cfquery>

Then to see if it posted:

<cfif checkforexisting.RecordCount GT 0>
do the don't clip optional processing
</cfif>

What is killing me is that it finds the match SOMETIMES. Just not ALL the time. I have tried no percent signs when passing the ColdFusion variable, only one on the right (which has solved these types of problems before).

If I pull the record back OUT of the database in a page by itself (retrieving it by key field), it finds every other copy of the code EVERY time.

I have put this into a stored procedure, which seemed to help (?).

I even have resorted to creating a temp table first with the clip, then running a query to retrieve the record that was just put in, and comparing THAT to my primary table (both have text type fields). The reason for this, is that if I write a single page that has just the retrieval of the temp record, and that compare is run, it finds EVERY copy of it in the primary table. I also thought that maybe there was a strong problem (I had tried HTMLEditFormat, HTMLCodeFormat, JavaCast since it was coming from a java program on the browser end).

I am not terribly familiar with using large text fields, or dealing with these large pieces of HTML code as something to compare!

- Mike

Max JVM Heap Size

forums_noreply@adobe.com — Wed, 18 Jul 2007 15:07:51 GMT

I upgraded the memory in my server today from 1GB to 4GB.

Went to set max heap size to 2GB instead of 512MB, and CF wouldn't restart.

Manually edited config file and went back down to 1Gb (still a doubling in size) and everything is fine.

Tried manually editing to anything higher than 1GB, and CF server wouldn't restart.

I have done alot of searching on this, and found conflicting info, etc.

Is BKBK, Adam C., or anyone out there who knows the suggested/best/reasoning for the setting?

CF MX 6.1 updated; IIS 6, Windows 2003 server, SQL 2003 sp 4.

Thanks,

Mike

Optimum Max JVM Heap Size Question

forums_noreply@adobe.com — Thu, 15 Feb 2007 18:26:43 GMT

I saw Ken running around, so I figured this would be a good time to post.

I am running CF 6.1, Windows 2003 Server, IIS 6.0, SQL2003; all are on the same machine.

This machine is a web-server that runs this particular ColdFusion application ONLY. Nothing else.

I have looked through a decent amount (although I'm sure not all) of the white papers on this setting. I have left it at 512MB, but since I have 2GB on the server, I thought about increasing it, but didn't know how much CF would really use, if it would increase garbage collection times, etc.

So once my brain finally said "I don't know", I thought I'd post on it.

Thanks,

Mike

Scheduled Tasks Seems To Have Gone Haywire

forums_noreply@adobe.com — Wed, 21 Feb 2007 23:36:26 GMT

My configuration:

MX 6.1, Windows Server 2003, SQL Server w/ SP4.

Scheduled tasks have suddenly gone.. well, goofy! I have scheduled tasks (setup from within the CF Admin) running for months just fine.

Today, if I pick just 1 tasks to run "manually" (i.e. - by user request), around 1/2 of the OTHER scheduled tasks run as well!

The only odd thing in the logs is under the "schduled tasks" log (which I have turned on in CF Admin). For every scheduled task that runs, there is a SECOND one, listing the name followed by "Activating2", which is NOT part of any of the names of my tasks, etc.

I have searched the forums, and the Adobe CF Support for this, and have found nothing.

I have rebooted, restarted, archived the log files.

I will be back at 8:30PM EST - anybody want to help out and mull it over?

I would REALLY appreciated any insight - I'm stumped.

- Mike