For those new to message boards please try to follow a few simple rules when posting your question.
Choose the correct forum for your message. Posting a VB.NET question in the C++ forum will end in tears.
Be specific! Don't ask "can someone send me the code to create an application that does 'X'. Pinpoint exactly what it is you need help with.
Keep the subject line brief, but descriptive. eg "File Serialization problem"
Keep the question as brief as possible. If you have to include code, include the smallest snippet of code you can.
Be careful when including code that you haven't made a typo. Typing mistakes can become the focal point instead of the actual question you asked.
Do not remove or empty a message if others have replied. Keep the thread intact and available for others to search and read. If your problem was answered then edit your message and add "[Solved]" to the subject line of the original post, and cast an approval vote to the one or several answers that really helped you.
If you are posting source code with your question, place it inside <pre></pre> tags. We advise you also check the "Encode "<" (and other HTML) characters when pasting" checkbox before pasting anything inside the PRE block, and make sure "Use HTML in this post" check box is checked.
Be courteous and DON'T SHOUT. Everyone here helps because they enjoy helping others, not because it's their job.
Please do not post links to your question into an unrelated forum such as the lounge. It will be deleted. Likewise, do not post the same question in more than one forum.
Do not be abusive, offensive, inappropriate or harass anyone on the boards. Doing so will get you kicked off and banned. Play nice.
If you have a school or university assignment, assume that your teacher or lecturer is also reading these forums.
No advertising or soliciting.
We reserve the right to move your posts to a more appropriate forum or to delete anything deemed inappropriate or illegal.
In this case Shipment_date is an actual DATE data type whereas the Sales_Order_Ship_Date is a VARCHAR(42) data type.
It works really well on the condition that the original string data represents a date of at least 2010-01-01. The string data is formatted as follows: YYYYMMDD so 2010-01-01 is 20100101 in the string version. It converts perfectly to 2010-01-01 and the same is true for later dates. Any string representing a date before 2010-01-01 though comes out as 0000-00-00.
Does anyone have any ideas as to what is causing this?
Then I corrected my colleague's original code as you described and sure enough it now works exactly as expected.
Why it ended up producing 0000-00-00 is still a mystery but once the dissection of the string is done properly it now accepts any date
I'm trying to add both text and a picture filename to an Access database. The actual .jpg file is stored separately in another folder. I want to use a File control in classic ASP to do this. If I create a page for the text fields and a separate page for the File control, everything works fine but the users are confused by having to go to two pages.
Ideally, they would use the Browse button of the File control to select their picture then the picture's filename would be passed down to the "ImageLink" field in the database Insert SQL command. Any ideas?
Here's my two sections of code:
<formaction="marketplaceentryadd.asp"method="post"><!-- Begin data entry table --><tableborder=1 cellpadding=3 cellspacing=1><tr><tdsize="110"><fontcolor="#FFFFFF">Country:<br/></font></td><td><inputname="txtCountry"type="text"size="50"maxlength="50"/></td></tr><tr><td><fontcolor="#FFFFFF">Description:<br/>(255 char. max)
Numbers only with optional decimal point
</font></td><td><inputname="txtPrice"type="text"size="50"maxlength="50"/></td></tr><tr><td><fontcolor="#FFFFFF">Your Name:<br/></font></td><td><inputname="txtSeller"type="text"size="50"maxlength="50"/></td></tr><tr><td><fontcolor="#FFFFFF">Contact Info:<br/>
(255 char. max)
(255 char. max)
</font></td><td><inputname="txtMoreInfo"type="text"size="50"maxlength="255"/></td></tr><tr><td><fontcolor="#FFFFFF">Picture Filename:<br/>Do not include spaces in the filename<br/>Be sure to include extension (.jpg)</font></td><td><inputname="txtImagelink"type="text"size="50"maxlength="50"/></td></tr><tr><td><inputtype="submit"value="Add Item"/></tr></table></form>
Second page code:
Please select picture to be saved for this item:<br/><br/><FORMmethod="post"encType="multipart/form-data"action="ToFileSystem.asp"><INPUTtype="File"name="File1"><br/><br/><INPUTtype="Submit"value="Upload Picture"></FORM>
We are more than willing to help those that are stuck: but that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for us to do it all for you.
So we need you to do the work, and we will help you when you get stuck. That doesn't mean we will give you a step by step solution you can hand in!
Start by explaining where you are at the moment, and what the next step in the process is. Then tell us what you have tried to get that next step working, and what happened when you did.
Consider this: just posting your homework question and hoping somebody will give you the answer so you can just tick a multiple choice box is futile. You have no idea if the answer you're given is right or wildly wrong ... and unless you actually learn this stuff you will have no idea at all!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
Now I feel sorry for missing this question. Normalization is one of the things you have to learn, and not just for databases. It will give you more insight into data. Let me stress that again, you want to master this, it is what makes a master.
Can you give me a real life analogy for your abstract question? Otherwise, I'd just have to reply with the rules which you already know.
And BCNF comes after 3NF; if it in 3NF, it not guaranteed to be BCNF, so answer one falls. Leaves you with three. Also, 3NF and BCNF rather close - if you can answer it, you master it.
Bastard Programmer from Hell
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
select I."ItemOCode" as "Id", I."ItemNameA" as "Item",
S."ACCNAME" as "SalesMan", sum(Decode(T."TransKind", 504, T."QtyIO")|| Decode(T."TransKind", 506, T."QtyIO")) * -1 as "Sales",
sum(Decode(T."TransKind", 504, T."BonusIO")|| Decode(T."TransKind", 506, T."BonusIO")) * -1 as "Sales Bonus",
sum(Decode(T."TransKind", 504, T."NetTL")||Decode(T."TransKind", 506, T."NetTL" ) * -1) as "Total Sales",
round((sum(Decode(T."TransKind", 504, T."BonusIO")||Decode(T."TransKind", 506, T."BonusIO")) * -1) / (sum(Decode(T."TransKind", 504, T."QtyIO")||Decode(T."TransKind", 506, T."QtyIO")) * -1) * 100,0) as "Bonus Rate",
H."VHFNo" as "Invoice", H."AccCode", H."AccName" from "TransActn_S" T, "Item_Card" I, "Header_S" H , "SALESMEN" S
where I."ItemOCode" = T."ItemOCode" and
H."TransNo" = T."TransNo" and
H."VHFNo" = T."VHFNo" and
H."TransKind" = T."TransKind" AND
(H."TransKind" = 504 OR H."TransKind" = 506) AND
H."SalesManNo" in (00016,00034,00036,00119,00108,01000,00007) AND
S."SALESNO" = TO_CHAR(H."SalesManNo") AND H."VHFDate" between '01/08/2020' and
'24/08/2020' AND H."Stock_Code" = 1 group by I."ItemOCode", I."ItemNameA",S."ACCNAME",H."VHFNo" ,H."AccCode" ,H."AccName"
order by I."ItemOCode"
I've install SQL Server Express 2014 named instance with mixed mode authentication.
one more SQL Server 2005 version installed with default instance and TCP port has been assigned 1433.
following error occurred
Server Name: .\sqlexpress
Error Number: 18456
Line Number: 65536
-I want to connect locally (with dot) but not able to connect, I also want to connect from outside network
-with static IP still getting the same problem.
following changes I've done
-remove dynamic TCP port from configuration manager ipall
-instead of dynamic port I've place static tcp port 1438 and 1440 both are listening
-try 1434 TCP port but SQL service not able start so I've change into 1438 and 1440.
-and same has been configured from firewall inbound and outbound rule.
--also tried through dbeaver to make connection but following error occurred
SQLEXPRESS,1438 failed. Error: "java.net.UnknownHostException: 126.96.36.199:3390: invalid IPv6 address". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.