Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Line Breaks Not Inserted In Exported RTF Document
@Feherke, Didn't know what you were talking about re: "\par"; so I did a little research. Learned that MS Word recognize "\par" as a paragraph mark. So, I made the following change to my code and it now works. $t_newline = "\par"; ..... (see above) $vAppB = implode(" "... -
Line Breaks Not Inserted In Exported RTF Document
I am exporting content from an MySQL database to a Word Template (RTF) via PHP. There is a section, "Appendix B", which should display all the Acronyms found for a record. The minimum records to appear for this section is 90 (i.e. these are standard acronyms (tblAcronyms) that each record will... -
Extracting Data
Hi All! First, thank you in advance to anyone who can provide assistance. I'm a newbie to XML and this is my first XML project which is a very challenging one. I've been assigned a task where I need to update data within a 3rd party's XML file (the structure is in XML format but the file... -
View Microsoft Project (MPP) file in CF
Does anyone know how to view/pull in data from a MS Project file (*.mpp) via ColdFusion? Are there any CF objects/plug-ins/Custom Tags that has this capability? I've been doing some research on various forums and what I have found thus far is writing VBA code to convert the MPP file to an... -
Request Assistance w/Looping
I need another pair of eyes to try to assist me. What I am trying to do is display records from a view within SQL Server 2000 to the PHP web page. The records are already grouped/sorted on the db backend. I would like my output to be as follows: Status: [Value] Team: [Value]... -
Records Not Showing w/Page Navigation
Thank you Borvik! I will take a look at it. -
Records Not Showing w/Page Navigation
...defined, use it as page number if(isset($_GET['intpage'])) { $intpageNum = $_GET['intpage']; } // counting the offset $offset = ($intpageNum - 1) * $introwsPerPage; //connect to a DSN ('Name of DSN', 'UserName', 'Password') //odbc_connect: Connect to a datasource $conn =... -
Dropdown values not populating for existing record
I figured it out myself. This is for anyone else who may be having the same issue. I changed ... if(!$_GET[ctrCandidate]){ //new record echo "<option value=\"$ctrCompany\">$txtCompany</option>"; } else { //existing record if($intCompany == $ctrCompany) { echo "<option... -
Dropdown values not populating for existing record
...<td><select name="intCompany"> <option value=""> <? //the SQL statement that will query the database $qryCompany = "select * from tblCompany order by txtCompany ASC"; //perform the query //odbc_exec: Prepare and execute a SQL statement $qrycompanyresult=odbc_exec($conn... -
Problem inserting fields of datatype Money
Thank you r937 & cfSearching for your assistance! cfSearching, I did as you instructed re: JDBC Driver (obviously what I did in prev response was still within the ODBC -- lack of sleep is to blame! LOL)... I removed the old DSN and re-created it using Microsoft SQL Server as the driver. (I... -
Problem inserting fields of datatype Money
cfSearching, How do I go about using JDBC??? Connecting the DSN via ODBC is how I was taught (via former mentors, not formal training), so that's what I've been accomstomed(sp) to. (I don't have a more logical reason for using ODBC). But if there is a another and more efficient way, then... -
Problem inserting fields of datatype Money
BTW, I took it a step further, for testing purposes and I entered values in those fields. And receive the following error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Optional feature not implemented -
Problem inserting fields of datatype Money
Thank you cfsearching for responding! [smile] I removed the <cfparam> and left the cfsqltype as cf_sql_decimal intact as you and r937 suggested. But, I'm still receiving the same error: Invalid data '' for CFSQLTYPE CF_SQL_DECIMAL. I have checked and triple checked to ensure the values... -
Problem inserting fields of datatype Money
I'm even more puzzled ... As indicated in prev post, I have cfparam values for various fields. <cfparam name="Form.curSalary" default="0"> So, I decided to add the following to the page to see the actual output since non-entered values weren't displaying in my cfdump. <b>Salary... -
Problem inserting fields of datatype Money
r937 and Members, If my statement came off as being rude or anything, I didn't mean it to be. Just a little frustrated with this error ... And I really don't want to change the datatype to varchar as (IMO) that's poor db design. I still welcome any resolutions to this problem. I also welcome... -
Problem inserting fields of datatype Money
r937, I tried that too. I even removed the quotes and still received the same error. I've been seeing red for the past week+ on this error. I just don't know what it could be ... SMS (Shrugging My Shoulders). I'm determined to resolve this problem w/o changing the datatype. Again, thank... -
Problem inserting fields of datatype Money
The debugger informs me that the error occured on the line beginning the insert action. I can see the form values entered via the cfdump. Since I didn't enter a value for that field (i.e. curSalary), I'm making my assumption on that it is barfing on this <cfparam name="Form.curSalary"... -
Problem inserting fields of datatype Money
Hi r937! <voice type="marge"> You telling me!!! </voice> LOL First thank you for taking time out to respond. [smile] I left my cfparam values in place and changed the cfsqltype as you indicated ... I then received the following error: [b]Invalid data '' for CFSQLTYPE CF_SQL_DECIMAL.[b] -
Problem inserting fields of datatype Money
First, thanks in advance to anyone who may be able to assist me. I haven't worked with CF for 2+ years and am trying to get back to re-acquiring my skills in this language. Needless to say, I'm having a rough time. Within a table, I have three fields that are of datatype "money". (I'm using... -
ODBC: Change Username & Password
Thank you to all for responding. [bigsmile] Synapsevampire, I will try making those changes based on your instructions. However, please explain why "proprietary logins" is a bad idea. I thought having it set as a generic userid/password would be better to prevent the issues we're having now...- dnayana
- Post #5
- Forum: Business Objects: Crystal Reports 3 Integrate
