Forgot your password?
Sign in with
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View Python questions
View C++ questions
View Java questions
All Message Boards...
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Design and Architecture
Internet of Things
C / C++ / MFC
ATL / WTL / STL
Objective-C and Swift
Hardware & Devices
Hosting and Servers
.NET (Core and Framework)
Site Bugs / Suggestions
Spam and Abuse Watch
The Insider Newsletter
The Daily Build Newsletter
Most Valuable Professionals
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
What is 'CodeProject'?
Ask a Question
Bugs and Suggestions
Article Help Forum
Comments by Eagle32 (Top 15 by date)
Thanks for sharing that, my application does not have a UI so i will refer to link you shared.
My XML is not being correctly parsed when i pasted it into the post. How can i fix this?
Thanks for the response. Yeah i see what you mean, the end users can provide various combinations so i will need to look deeper into your suggestions etc.
At which point do i invoke .ToList() method so i get just a List<product> at the end.
Thanks, Now instead of a List of Products in the dictionary if i have just a Dictionary<string, product=""> how would i achieve the above i.e filtering and converting to a list?
Apologies, i have updated my actual problem and my SQL.
I have checked the API, the Product_Code is actually always populated in the database and will contain a real value (i.e not "UNKNOWN") and the Product_Type is not always populated with an actual value.
What i would like to do is filter the dictionary collection and return just a List<products>. I want to filter using the user provided ProductCodes List and the ProductTypes List.
I want to match on the ProductCode using the ProductCodeList provided by the end user. This list will never contain "UNKNOWN".
Now regarding user providedlist called ProductTypes List, if the value contains "UNKNOWN", i want to match on the null value of the ProductType property of the Product that exist in that List<product> in the Dictionary i mentioned. I then want to replace the null value of the property with "UNKNOWN".
Apologies, I have updated my actual problem and my SQL. I have looked at the API i am working with and the ProductCode in the Products table is always populated and therefore never null.
However ProductType can be null and the data i am working with have several entries which the ProductType is NULL. I want to match on this value and if the value is NULL and the value in the user provided list called ProductTypes is "UNKNOWN" i want to replace the value of the ProductType where the value is NULL which exists in the Dictionary<string, list<product="">> with "UNKNOWN".
I am asking how would i filter the data that i get back based on the user provided inputs where the return value's data structure is of the following format Dictionary<string, list<product="">>();
Mika, regarding your commen "works fine as long as you choose a value that cannot exist in the original data. Otherwise you could have false results, depending on the logic" can you elaborate on this please? Thanks
Is there a way to store byte array of data in PL/SQL. Here is what i have:
but i don't know how to store the byte array of data in the BLOB column. Currently i can only insert the physical file into the database:
l_dir VARCHAR2(10) := 'IMAGES';
l_file VARCHAR2(25) := 'test.jpg';
INSERT INTO IMAGE_TBL (IMG_ID, IMG_DESC, IMAGE_DATA, IMG_EXT)
VALUES (IMAGE_TBL_SEQ.NEXTVAL, l_file, empty_blob(), '.jpg')
RETURN IMAGE_DATA INTO l_blob;
l_bfile := BFILENAME(l_dir, l_file);
--Opens BFILE for read-only access. BFILE data may not be written through the database.
--Copies all or part of the source external LOB to a destination internal LOB
--Release the resource.
--Save the changes. This will do the actual insert of the image
Ok, thats great. I will give that a go.
Yeah that is also true. In regards to Oracle and PL/SQL for writing images is there anything to for me to remember? I could be passing in 1MB images.
Yes that's correct. I should have made myself clearer, the insert statement i have used isn't the actual code i am going to use as final solution. It is merely for debugging purposes.
Also in addition to my previous question, how can i adapt this code so that i only insert the studentBioID that belongs to the student? i.e if that student doesn't have a studentBioID then we do not populate it for that student.
I appreciate your assistance. Would this work in PL/SQL as I am using PL/SQL developer?
Last Updated 1 Jan 1900
All Rights Reserved.