Search results for query: *

Hi, I am not overly farmiliar with crystal although as i am mainly a programmer, what i would like to do is this. I would like to display a graphical timetable, rather than just a list of activities. All my activities are stored in a database with a start date/time, end date/time, and a week...

Hi everyone, I have a strange problem with sql select statements ignoring the first field in the select statement if joining 2 or more tables when accessing data from ASP pages. For example "select c1, c2 from t1" returns a recordset with 2 columns c1 & c2 "select c1, c2 from t1, t2 Where...

Hello people, quite an obscure request here but i'm desperate :) Does anyone know of / can think of a way in which it is possible to lock an oracle record for the duration of a page being open. I know you can lock the record using the "select for update nowait" sql commands but this obviously...

Hi, I have an xml & xsd file that has been downloaded from a reputable site ready to use. The xsd file at the present moment has no SQL field mappings as i just want to run the process with no errors before i start adapting the file. I currently get this error when executing the Bulkload...

Hi, I have an xml & xsd file that has been downloaded from a reputable site ready to use. The xsd file at the present moment has no SQL field mappings as i just want to run the process with no errors before i start adapting the file. I currently get this error when executing the Bulkload...

Im not sure if this is the best forum to post in but i've looked through the list and cant really find anything better. I have a lot of learning resources that need to be catalogued. Each one of these resources has an XML file that details all of the details about that resource (including...

I have come across the command SessionWrite(sSessionName) used as the name of a form element on a html page which, when the form, is submittted, writes the value of that form element to the relevant element. I have never come across this code before and the people responsible say it is a...

Hi there, I am using Crystal Reports 10, I am new to the crystal scene and so started off looking at the examples that can be downloaded from the business objects website for opening reports from asp pages. I am using the example for simpleselectionformula.asp, which basically just allows you...

How can i get Indexing Service to index content that is put on the page by asp. i.e <% strTemp = &quot;Testing&quot; %> Title = <%=strTemp%> How can i get indexing service to register that the word testing is on this page?

Hi all, I'm having a problem comparing two lots of text that is stored in a sql server db as long text datatypes. All I want to do is a simple compare statement like: --------------------------- If var1 <> var2 then booTest = True Else booTest = False End If...

I want to populate a field with a user Login ID which consists of thier surname and the first letter of thier surname. The problem occurs when I get 2 people with the same initial and Surname if this happens then I want to then use the first 2 letters of thier first name i.e if there was a...

I have a field that contains forenames. If a person has more than one forename they are listed in this field seperated by spaces. I want to seperate the first forename from the rest of the field. How can I do this? Basically i want everything up to the first space. Thanks again. Mark

Hello Again, Next problem, I want to compare a list of codes in one table(tblA) to a list of codes in another table(tblB). Any codes that are in tblB but NOT in tblA should be written to tblC. --------------------------- INSERT tblC select Code from tblA where not exists (select * from tblB...

Hello people, I have reference numbers for staff that vary from 1-4 characters long. Basically I want to make all numbers 7 characters long by adding 0's to the front of the number. The field is varchar(7). How can i do this? Thanks