16,000,645 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Eagle32 (Top 15 by date)
Eagle32
13-Jan-17 8:28am
View
Thanks for sharing that, my application does not have a UI so i will refer to link you shared.
Eagle32
28-Nov-16 16:53pm
View
Ok thanks.
Eagle32
28-Nov-16 14:21pm
View
My XML is not being correctly parsed when i pasted it into the post. How can i fix this?
Eagle32
19-Nov-16 11:20am
View
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.
Eagle32
21-Oct-16 5:48am
View
At which point do i invoke .ToList() method so i get just a List<product> at the end.
Eagle32
21-Oct-16 4:16am
View
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?
Eagle32
19-Oct-16 10:08am
View
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".
Eagle32
19-Oct-16 9:58am
View
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="">>();
Eagle32
16-Oct-16 12:56pm
View
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
Eagle32
28-May-16 16:10pm
View
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:
DECLARE
l_dir VARCHAR2(10) := 'IMAGES';
l_file VARCHAR2(25) := 'test.jpg';
l_bfile BFILE;
l_blob BLOB;
BEGIN
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.
DBMS_LOB.fileopen(l_bfile, DBMS_LOB.file_readonly);
--Copies all or part of the source external LOB to a destination internal LOB
DBMS_LOB.loadfromfile(l_blob,
l_bfile,
DBMS_LOB.getlength(l_bfile));
--Release the resource.
DBMS_LOB.fileclose(l_bfile);
--Save the changes. This will do the actual insert of the image
COMMIT;
END;
Eagle32
27-May-16 12:23pm
View
Ok, thats great. I will give that a go.
Eagle32
27-May-16 11:15am
View
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.
Eagle32
27-May-16 11:08am
View
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.
Eagle32
23-Jun-15 14:52pm
View
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.
Eagle32
23-Jun-15 11:55am
View
I appreciate your assistance. Would this work in PL/SQL as I am using PL/SQL developer?
Show More