User Name Password Register
DaniWeb IT Discussion Community
Home
Forums
Tutorials
Code Snippets
Blogs
Link Directory
White Papers
All
•
•
•
•
What is DaniWeb IT Discussion Community?
DaniWeb is a massive community of 373,889 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,817 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Join our community!
•
•
•
•
Showing results 1 to 28 of 28
Search took 0.01 seconds. Posts Made By: cfAllie
Save these search results for 24 hours
Forum: MS SQL May 22nd, 2007
Replies: 5
Views: 834
Posted By cfAllie
Re: cross data please heslp

It probably wouldn't. It would give them only
Forum: MS SQL May 21st, 2007
Replies: 5
Views: 834
Posted By cfAllie
Re: cross data please heslp

select t1.*
from theTable t1 join theTable t2
on t1.id2 = t2.id1 and t1.id1 < t2.id1
Forum: ColdFusion May 14th, 2007
Replies: 7
Views: 2,864
Posted By cfAllie
Re: Cfmail problem when sending to yahoo recipients

Google turned up a lot of issues with mailto and Lotus notes, primarily character limitations....
Forum: MySQL May 13th, 2007
Replies: 5
Views: 1,302
Posted By cfAllie
Re: Any help would be appreciated

I think you may posted this question in the wrong forum. Its under MySql db, but it looks like you're using Oracle. Unfortunately, I'm not and don't know Oracle syntax :(
Forum: MS SQL May 13th, 2007
Replies: 1
Views: 2,608
Posted By cfAllie
Re: update two rows in one query

Yes, you need to separate them. The syntax should be more like


UPDATE SomeTable
SET Column1 = SomeValue1,
Column2 = SomeValue2,
Column3 = ....


It doesn't look like you need a...
Forum: MySQL May 13th, 2007
Replies: 5
Views: 1,302
Posted By cfAllie
Re: Any help would be appreciated

That's almost right! It looks like you're using sql server syntax. MySql's DateDiff() function works a little differently.


So it doesn't require the interval ("dd" - for days). Try...
Forum: MySQL May 13th, 2007
Replies: 5
Views: 1,302
Posted By cfAllie
Re: Any help would be appreciated

Start with 1). Can you post your query and a description of what didn't work?
Forum: MS SQL May 12th, 2007
Replies: 2
Views: 1,201
Posted By cfAllie
Re: Query Total Asset

As Midimagic said, you need to sum the previous month(s) too. One way to do this is using a join


SELECT curr.AssetYear, curr.AssetMonth,
SUM(curr.Total + ISNULL(prev.Total, 0)) AS...
Forum: MS SQL May 12th, 2007
Replies: 2
Views: 775
Posted By cfAllie
Re: delete data, then shift its number....

--- delete selected question
delete from Questions
where SurveyID = 140
and QuestionNum = 3

--- decrease subsequent numbers
update Questions
set QuestionNum = QuestionNum...
Forum: MySQL May 12th, 2007
Replies: 1
Views: 1,293
Posted By cfAllie
Re: Static Count vs Dynamic Count (Very advanced, gurus take your shot)

I'll let someone else tackle the issue of expectations, but I did have a few thoughts....

Left joins may be tedious to write, but performance is more important. I could reduce a 10 line query to 1...
Forum: MySQL May 12th, 2007
Replies: 3
Views: 818
Posted By cfAllie
Re: Sql Joins

Welcome !
Forum: MySQL May 12th, 2007
Replies: 3
Views: 818
Posted By cfAllie
Re: Sql Joins

SELECT DISTINCT teacher.teachername, student.studentname, results.grade
FROM teacher LEFT JOIN
(
student INNER JOIN results
ON student.studentname = results.studentname
...
Forum: ColdFusion May 3rd, 2007
Replies: 7
Views: 2,864
Posted By cfAllie
Re: Cfmail problem when sending to yahoo recipients

I didn't test it but I think something like this should work


<cfset blahblah = "whatever site" />
<cfset subjectText = "Look at this information on #blahblah#" />
<cfset linkText =...
Forum: ColdFusion May 2nd, 2007
Replies: 7
Views: 2,864
Posted By cfAllie
Re: Cfmail problem when sending to yahoo recipients

I'm not sure exactly how you're coding it. You might look into the JSStringFormat() function.

Also check google for tips on obscuring/generating mailto: links to prevent harvesting /spamming.
Forum: ColdFusion Apr 28th, 2007
Replies: 7
Views: 2,864
Posted By cfAllie
Re: Cfmail problem when sending to yahoo recipients

What sender address are you using? It sounds like its being rejected, possibly as an anti-spam measure. Though I don't know if its from your mail server or from yahoo. Check their faq's...
Forum: ColdFusion Apr 27th, 2007
Replies: 5
Views: 14,386
Posted By cfAllie
Re: Airline Reservation System

Start by defining what kind of reservation system you want to write and what capabilities the system must have. For example

1. Goal is to design a Hotel Room Reservation System
2. The system must...
Forum: ColdFusion Apr 26th, 2007
Replies: 2
Views: 2,882
Posted By cfAllie
Re: Loop through query to find value

If you order the query by customer_number you can use cfoutput with the group attribute to group the results together.

Sorry for the poor...
Forum: ColdFusion Apr 16th, 2007
Replies: 17
Views: 5,291
Posted By cfAllie
Re: MS Access Error - sometimes

Try adding a captcha image to the form submission. They're not fool-proof but they help minimize spam.

http://lyla.maestropublishing.com/
Forum: ColdFusion Apr 16th, 2007
Replies: 17
Views: 5,291
Posted By cfAllie
Re: MS Access Error - sometimes

Never heard of it. Is it possible you're being spammed?
Forum: ColdFusion Apr 12th, 2007
Replies: 17
Views: 5,291
Posted By cfAllie
Re: MS Access Error - sometimes

I understood what you meant :) That sounds like a good plan. Once you have identified the problematic values you can determine whether the cfinsert can be fixed or if you need to convert it to a...
Forum: ColdFusion Apr 11th, 2007
Replies: 17
Views: 5,291
Posted By cfAllie
Re: MS Access Error - sometimes

Unfortunately, I've never heard of that error occuring except with memo fields.

I don't know. I have full debugging turned on and I can't see the sql statement sent to the database. Do you check...
Forum: ColdFusion Apr 11th, 2007
Replies: 17
Views: 5,291
Posted By cfAllie
Re: MS Access Error - sometimes

Strangely the same values work with a regular insert.

<cfquery name="InsertRow" datasource="AccessUnicodeDSN">
INSERT INTO Table1 (Name, Notes)
VALUES
(
<cfqueryparam...
Forum: ColdFusion Apr 11th, 2007
Replies: 17
Views: 5,291
Posted By cfAllie
Re: MS Access Error - sometimes

Do you have any memo fields? I was able to reproduce the error using a simple table with a memo field like below. I don't remember the limits for the unicode driver.

Table1
ID Autonumber
Name...
Forum: ColdFusion Apr 11th, 2007
Replies: 17
Views: 5,291
Posted By cfAllie
Re: MS Access Error - sometimes

Sorry, I meant which "datasource" type :) Is it Access or Access with Unicode?
Forum: ColdFusion Apr 11th, 2007
Replies: 17
Views: 5,291
Posted By cfAllie
Re: lafalot

I understand. The problem with cfinsert is that when it works, it works well.. but when it doesn't work its a lot tougher to debug. I use regular inserts with optional fields all the time. I prefer...
Forum: ColdFusion Apr 11th, 2007
Replies: 17
Views: 5,291
Posted By cfAllie
Re: MS Access Error - sometimes

I don't know what version you're using but you might look at http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_18952

You might also consider converting the cfinsert to a regular insert...
Forum: ColdFusion Apr 10th, 2007
Replies: 2
Views: 2,567
Posted By cfAllie
Re: Run exe file using Coldfusion

Use cfexecute

http://livedocs.adobe.com/coldfusion/6.1/htmldocs/tags-p25.htm
Forum: ColdFusion Mar 30th, 2007
Replies: 3
Views: 4,240
Posted By cfAllie
Re: finding duration worked between time ranges from login and logout time

Hi Ramesh,

This example might be more complex than what you need, but it should give you a starting point. Caveat - This example only counts the time that fall within @start and @end period. So for...
Showing results 1 to 28 of 28

 
Advertising Opportunities on DaniWeb
Contact Us - Newsletter Archive - Sitemap - Privacy Statement
All times are GMT -4. The time now is 4:20 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC