Search results for query: *

In the form, I only want the person creating, or approving or the managers to see their own data. So, I put a where clause on the datablock for security within the form. However, my problem is when I try to query on JUST ONE record it still brings me all the records in my set. Any ideas...

Hey I have created my table with a LONG datatype. In the form it will only let me put a 400000 char limit on the field size before it starts erroring out. If I make the char field more than 400000, when I do a query it says "query caused no records to be retrieved", when I change it...

I am using Forms 5. I have a field (FSC) with a LOV attached. There are essentially 2 values in the lov, 0 = no MSDS 1-7000 = various descriptions for the MSDS(material Safety Data Sheets) if they choose 1-7000 it populates the field (DESCR) with the description of the MSDS they chose and...

Hey is there a way to have the report print out 0, or something other than nothing when there are no rows returned from my query?? Is there something that I can set to tell it to print a value (like "no rows returned") when no rows are retrieved from the query??? Thanks in advance!

I am still new to Oracle and we want to explore the capabilities of the Reports Server. We have a copy of Oracle Developer/2000 Reports 3.0.5.8.0. We have no documentation. We normally just create reports and call them from forms. If the Reports Server is included in Developer/2000, please...

When I check my scheduler.log file I get this. It is great that it submitted successfully, but look at the date??? for the year 2000 it showed 100 & for year 2001 it shows 101. We havent realized this before...

We are installing Crystal Reports on our server. Is there a default password for the User ID administrator or any default User ID's & passwords??? During the set up it asked for a NT user name & password so we put in the administrator UN & PW in that dialog box, it said we could change it if...

Hey everyone, we finally figured out how to place a button on a form that will call a web page (internally or externally) and now I have encountered a new problem.. A folder that is referenced in teh hyperlink has an " ' " in it. This is causing problems in the compilation of the...

I am trying to do some documentation at work. Can anyone give me a clue as to what is happening in this part of the code? I am very new to CF and would like some help. <cfset strtoe_code = ''> <cfloop query=&quot;getOracleData&quot; > <cfset strtoe_code = strtoe_code & &quot;,&quot; &...

Hey I am wanting to put a button on a menu form & get it to pull up a web site when you click on the button. any ideas? Thanks a bunch!

hey, this is my first big project using forms & reports. I do have a general understanding and have created several general reports & forms. But this is a little more complicated. We have a user that wants to be...

hey, this is my first big project using forms & reports. I do have a general understanding and have created several general reports & forms. But this is a little more complicated. We have a user that wants to be able to pull specific info from a PO. (I got that) then be able to do a...

hey, this is my first big project using forms & reports. I do have a general understanding and have created several general reports & forms. But this is a little more complicated. We have a user that wants to be able to pull specific info from a PO. (I got that) then be able to do a...

I have my html file that only has text & graphics, its very simple. My boss wants this in CF. I have played around in CF Studio (4.0) and I have already saved my html file as .cfm (very easy) but I also know that I have to &quot;wrap&quot; my html file in CF. How can I do this? Please help I...