Comments by Geofferz (Top 34 by date)

Thank you very much that did the trick :)

I m using PLSQL (Oracle)

haha nice! Ok thanks I will try find another way maybe searching for records in the system UI should hopefully find all locations, its just long winded that's all.

But thank you so much for all your help really appreciate it! :)

So for example i have the following loctions:

K:\FILE_DELIVERIES\OTHER\
K:\FINISHED\TRANSCODE_OUTPUT\Profile_2\
R:\ITV\ITV_Compliance\
K:\OUTGOING\LONDON_LIVE\SOURCE\

Normally they should show like this at the end having the file name that is starting with the M0 or EHD etc:

K:\FILE_DELIVERIES\OTHER\M0123456
K:\FINISHED\TRANSCODE_OUTPUT\Profile_2\M0123456
R:\ITV\ITV_Compliance\M0123456
K:\OUTGOING\LONDON_LIVE\SOURCE\M0123456

but like i have explained above the issue is that they coming up as

K:\FILE_DELIVERIES\OTHERM0123456

removing the \ between the \Other (\) and M0

So what i m trying to do is run an sql to be able to find any location and filename without a \ in between the end of path or folder and the file name itself. Because all the devices are different names it could probably be difficult to do or maybe using a loop some sort?

I have another question, If i want to return all items say in all location available that have the path as D:\CHANNEL_FIVE\BROADCAST\COMPLETEDEHD0152368

So here the path should be D:\CHANNEL_FIVE\BROADCAST\COMPLETED\EHD0152368 with a \ between the COMPLETED and the filename EHD0152368. So i want to find anything that has not \ between any filename that might start with M0/EHD/2-

so if there is anything other than a \ at the beginning of these filename starting with M0... it should return. But if there is a \ then then filename it should not.

That make any sense?

Thanks again

Awesome thanks OriginalGriff that worked using the like clause

Still removing the % does not bring back anything when i run the sql

I have the following sql that i want to try and run to return all the items on the following location but doesnt seem to bring back anything. Is the sql correct:

select t.*, t.rowid from tm_mis t where M_CTNR_LOC = '|J:\WIP\ITV\ITV_COMP\COMPLETED\%|'

Hi, the only code I have is the code creating the table in the database. I think rest is done through the application which has been written by someone else. So the information is entered from a thick client system UI and then it just gets stored into the database table.

I have no access to the code creating the records unfortunately.

So basically I just wanted pointers for example, select * from devices where TM_LOC is...and then an update TM_LOC to ....

if that makes sense?

Thanks for your help :)

Thanks Du

Yeah think didnt explain it properly there, i want to start with joining the query

Kschuler Thank you so much for your help that worked!

I have never used quickwatch before. Could you please briefly explain how to do this. Thanks Sorry I m new to this!

my email id is geoffreymk@hotmail.com thanks

Hey, thanks for your help. I would really appreciate a sample code if you can please! At the moment I just have a text box and I want that to be linked to my database so when user starts typing name of a customer it searches what already exists in the database and provide what matches to what they typing. Thanks again!

Thanks mate!! works well

thanks mate, that was very helpful really appreciate it! i m just putting some ideas together and then going to make some designs and start building the application. Thanks again for your help

thanks for that mate :-)

I have just updated the question added more details of what i want, I am new to SQL so i just don't know where to start with the pivot table. Hope the details above would explain more clearly what i want to achieve. Thanks

I am having problems understanding the sum function? everytime i enter pivot ( it keeps giving me an error saying syntax is not correct?

Dont know how to create a pivot table...!

I tried that it didnt work mate kept removing the uploaded file

I have just updated the question and added more code! When i tried with your code it did not work! Maybe it will help understand it better with the new code added. Thanks

Thanks!

Thank you very much it worked :-)

Now that the temp table has been created, can i in same procedure create another table where i can sort out the date. (pick and choose what i want to display)
So for example, in the dbo.WFRELDATA.DESCRIPTION i have data that i want to place as table header i.e. employee name, employee no, address etc. All the data is to go under the headers is in dbo.WFDATASET_VALUE.VALUE_TEXT i want to be able to pick up this table and put it under the headers. So when i use the stored procedure in a gridview (asp.net app) it will show me a nice table with headers and the list of details below it! I hope this makes sense!

Thanks again

Thank you very much it worked :-)

Now that the temp table has been created, can i in same procedure create another table where i can sort out the date. (pick and choose what i want to display)
So for example, in the dbo.WFRELDATA.DESCRIPTION i have data that i want to place as table header i.e. employee name, employee no, address etc. All the data is to go under the headers is in dbo.WFDATASET_VALUE.VALUE_TEXT i want to be able to pick up this table and put it under the headers. So when i use the stored procedure in a gridview (asp.net app) it will show me a nice table with headers and the list of details below it! I hope this makes sense!

Thanks again