Posts by e3computer

i need to send fax to fax machine. is it possible by using this tag?
<CF_eFax

The short answer is no. It does not look like the tag works with the new email-to-fax format supported by eFax.

From the looks of the eFax site the 2002 version of cf_efax may no longer work unless and updated version is available.

It looks like you can use cfmail to send faxes if you have a paid subscription to eFax. They layout the details on their site:
http://www.efax.com/en/efax/twa/page/howItWorks

You should be able to do a CFMAIL to the fax number from the email address you used to sign up at eFax.

Your cfmail tag would look something like this where you had a file with text named test_for_email_to_fax.txt on the root of your C drive.

<cfmail to="1231234567@efaxsend.com" from="you@yourdomain.com"
subject="test">
<cfmailparam file = "c:\test_for_email_to_fax.txt" type="text/plain">
</cfmail>

Other attachments are also acceptable:
http://www.efax.com/en/efax/twa/page/supportedFileTypeshttp://www.efax.com/en/efax/twa/page/supportedFileTypes
More on the cfmail tag:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-pta.htm#wp2355015
More on the cfmailparam tag:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-pb2.htm

I hope this helps.

i have site in which wheN people fill the form all rhe information get faxed and i should recive it.i registered with efax.can i code using CF_eFax. any body help me

I have not used eFax specifically but I have integrated with systems that send email by using the cfpop features of ColdFusion. This works best if you have an email address that is dedicated to getting faxes. cfpop will allow you to check the email in that account. You can then download the attachments as needed. cfschedule will allow you to check the email at an interval that keeps you up to date as needed.

more on cfpop:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b14.htm

Just checked out your website too. Awesome :)

Oh and It just occurred to me to tell you that the database the file is pulling from is an MS Access database.

Thank you! I appreciate that!

Would you export the data as xml or txt for me? There is something about your data that I am sure will be obvious by seeing the raw data. Either that or make a page that does a CFDUMP of the data so that I can see it that way. I am guessing the 'type' column is being used for new vs returning.?. If that is the case a few mods are in order. Luckily ColdFusion is quick and easy to modify.

I see now, the number_students is a calculation, not a column. Here is the query modified to include the calculation. Hopefully this works for you. The 'AS' clause will not work for all database types. You may need to fit the SQL for your database type.

<!---	get the unique data to display,
		, subselect the count of duplicate rows
		  which will be used to determine enrollment
		  (I think) --->
<cfquery name="get_sites" datasource="books">
	SELECT DISTINCT	a.site
						, a.sess
						, a.type
						, a.majr
		, ( SELECT count(id) AS number_students
			FROM	enr_report	b
			GROUP BY	b.site
						, b.sess
						, b.type
						, b.majr
			HAVING 	b.site = a.site
						AND b.sess = a.sess
						AND b.type = a.type
						AND b.majr = a.majr
			) AS number_students			
	FROM	enr_report	a
	ORDER BY	a.site
				, a.sess
				, a.type
				, a.majr
</cfquery>
<!---	/get the unique data to display,
		, subselect the count of duplicate rows
		  which will be used to determine enrollment
		  (I think) --->

What kind of database are you using. All databases have some table or function available that allow you to query table names, field names, etc. If you provide the database type that will help to simplify the response.

Here is a simple cfswitch that uses a default title but easily handles custom titles for pages where you want a different title. The second snippet seems more organized. Your call how you would like to do this. The key is to pull the name of the file form the cgi variable script_name. You may want the whole variable including the path but this example uses just the page name.

<cfset strPage = listLast( cgi.script_name, "/" )>
<cfset strTitle = "Untitled">
<cfswitch expression="#strpage#">
	<cfcase value="index.cfm">
		<cfset strTitle = "Welcome to the Home page">
	</cfcase>
	<cfdefaultcase>
		<cfset strTitle = "Standard Title is here">	
	</cfdefaultcase>
</cfswitch>
<title><cfoutput>#strTitle#</cfoutput></title>

Here is a slightly different vesion that uses a structure (associative array) to hold the data.

<cfset strPage = listLast( cgi.script_name, "/" )>
<cfset strTitle = "Untitled">
<cfset struct_titles = structNew()>
<cfset struct_titles["default"]="Welcome to the basic title page">
<cfset struct_titles["index.cfm"]="Welcome to the Home page">
<cfset struct_titles["other.cfm"]="The other title">

<cfif structKeyExists( struct_titles, strPage )>
	<cfset strTitle = struct_titles[ strpage ]>
<cfelse>
	<cfset strTitle = struct_titles[ "default" ]>
</cfif>
<title><cfoutput>#strTitle#</cfoutput></title>

Check out the structure they offer over at cfmsource:
http://www.cfmsource.com/pages/cfwebsite.cfm

Without your database I am not certain of exactly what all the data you have looks like. But I think you may be able to simplify the output using one query and using the GROUP attibute on the CFOUPUT tags as seen in the attachment.

First is the query, then the simple output you metioned. Then using the same logic the full code you included has been modified to use the menioned solution. Best of luck.

<cfquery name="get_sites" datasource="books">
	SELECT DISTINCT	*
	FROM	enr_report
	ORDER BY	site
				, sess
				, type
				, majr
</cfquery>

<!---	the simple structure you said you were aiming for --->

<!--- loop through the data, making the first itteration each time the site is unique	--->
<cfoutput query="get_sites" group="site">
<br><strong>---#site#</strong>

	<!--- loop through the subset of data while the site is the same	--->
	<cfoutput group="sess">
		<br>------#sess#

		<!---	while session stays the same the following code repeats	--->
		<cfoutput>
		 <br>--------#majr# #type# ...... #number_students#
		</cfoutput>
		<!---	/while session stays the same the following code repeats	--->
		
	</cfoutput>
	<!--- /loop through the subset of data while the site is the same	--->
	
</cfoutput>
<!--- /loop through the data, making the first itteration each time the site is unique	--->

<!---	/the simple structure you said you were aiming for --->



<!---	the structure applied to your table formatting	--->

<!---	using font tags is no way to go through life, tags removed, style added	--->
<style>
	.a3 {
		font-family:Arial;
		font-size:12pt;
		text-align:left;
		background-color:#003194;
	}
	.red {
		color:red; …