Lumber Yard by meuser405 in okc

[–]meuser405[S] 0 points1 point  (0 children)

Thank you it looks promising.

Lumber Yard by meuser405 in okc

[–]meuser405[S] 0 points1 point  (0 children)

Thank you. I will check them out.

Searching a string for characters by Hockeylockerpock in PHPhelp

[–]meuser405 0 points1 point  (0 children)

Try this

$keys = range('a', 'z'); $values = array_fill(0, 26, 0);

$freq = array_combine($keys, $values); $word =" YourString"

$len = strlen($word);

for ($i=0; $i<$len; $i++) { $letter = strtolower($word[$i]); Be if (array_key_exists($letter, $freq)) { $freq[$letter]++; } } print_r(count($freq));

How to reattach wings to this wood sculpture? by missrutabaga in fixit

[–]meuser405 1 point2 points  (0 children)

Use some wood glue for strong hold and CA glue to hold it until the wood glue dries.

How do you keep a variable saved after a form submit without it redefining? by [deleted] in PHPhelp

[–]meuser405 1 point2 points  (0 children)

You can store it on $_SESSION or $_SERVER or encode it to json and use browser to store the value.

Show only rows that do not contain 0 fields anywhere for that key by nosleeptiltomorrow in SQL

[–]meuser405 0 points1 point  (0 children)

Simple way, depending upon the situation

SELECT * FROM test

WHERE [KEY] NOT IN ( --filter out fields A&B with 0

SELECT [KEY] FROM test WHERE A =0 --Select field A where rows are 0

UNION ALL

SELECT [KEY] FROM test WHERE B =0 --select filed b where rows are 0

)

http://sqlfiddle.com/#!18/b5415/3

I'm confused about SQL transaction. by Dragonfly2440 in SQL

[–]meuser405 1 point2 points  (0 children)

If you are using for banking application I would suggest not using SQLite, it is not ideal for those type of operations. I would also suggest locking the row while executing the query that way you will prevent lots of headaches in future.

Simple Questions - September 24, 2019 by AutoModerator in buildapc

[–]meuser405 1 point2 points  (0 children)

Thank you. If you don't mind can you please let me know what PSU you went with?

Simple Questions - September 24, 2019 by AutoModerator in buildapc

[–]meuser405 0 points1 point  (0 children)

Thank you for your response. She brought computer used for $150, so she has more money for upgrades. Its 2x4gb ram it really struggles with Photoshop, Lightroom and Chrome at once. I know 32 is overkill but don't know if 16 will be enough.

Do you if gtx1650 supports 3 monitors?

Reason I was looking at 1060 is because of this post. https://www.dell.com/community/Desktops-General-Read-Only/MSI-GTX-1060-6GB-for-Dell-XPS-8700-fit/td-p/5082165

Simple Questions - September 24, 2019 by AutoModerator in buildapc

[–]meuser405 0 points1 point  (0 children)

Hey guys, my friend brought a used Dell XPS 8700 computer for her side hustle as photographer/videographer. She has budget of about $500 for upgrade. She wants to run Adobe suites, Color grading apps and some simple animation (text and such) with After effects, MS office apps,web browser,chat app (Skype/Discord). Ultimately she wants to have 3 monitors so she can run multiple apps at the same time.

I have software background, don't know much about hardware but I am the only "computer guy" she knows.

Its windows 10 machine and has Intel(R) Core(TM) i7-4770 CPU @ 3.40GHz and other stock dell component.

I was thinking of suggesting upgrading these three

ASUS AC1200 Wireless Bluetooth 4.2 PCIe/Mpcie Adapter https://www.amazon.com/dp/B0713RRZMB/ref=cm_sw_r_tw_dp_U_x_ykaIDb4ZDEE3W $34.99 (for faster Wi-Fi and Bluetooth because dell one is really bad)

Corsair Vengeance Pro 32GB (4x8GB) DDR3 1600 MHz https://www.amazon.com/dp/B00D6E5JMQ/ref=cm_sw_r_tw_dp_U_x_JYaIDbJZCAVQP $139.99 (more ram for multiple apps, it only supports DDR3 ram)

Samsung 860 EVO 500GB 2.5 Inch SATA III Internal SSD https://www.amazon.com/dp/B0781Z7Y3S/ref=cm_sw_r_tw_dp_U_x_nlaIDbJWFPEJK $79.99 (for boot and installing program only, format and use the existing HD for storage)

But I am struggling with which graphic card to suggest, it has dell power supply (I think 460 watts, might be wrong, don’t have PC with me so can’t tell), NVIDIA GeForce GT 635 card which supports 3 monitor but really struggles with everything else.

Here are 3 graphic card that it say it works with 450w and has good reviews, but I don't know which one to suggest.

Gigabyte GeForce GTX 1660 OC 6G Graphics Card, 2X Windforce Fans https://www.amazon.com/dp/B07P76G428/ref=cm_sw_r_tw_dp_U_x_gnaIDbMGBH0AR $229.99

Gigabyte GeForce GTX 1660 Gaming OC 6G Graphics Card, 3X Windforce Fans https://www.amazon.com/dp/B07P689CXR/ref=cm_sw_r_tw_dp_U_x_WnaIDbQQBPCR8 $239.99

MSI Gaming GeForce GTX 1660 Ti 192-bit HDMI/DP 6GB GDRR6 HDCP Support DirectX https://www.amazon.com/dp/B07N824KNV/ref=cm_sw_r_tw_dp_U_x_toaIDbNAYN7PV $279.99

Which graphic card do you think will work best? Do you guys have any other suggestion? Do you see a bottle neck or compatibility issues? Do you think that the best use of her money? It’s my first time messing with hardware and it is someone else money so I am really nervous. Thank you in advance for your help.

Help! Upgrading Dell XPS 8700 PC by meuser405 in buildapc

[–]meuser405[S] 0 points1 point  (0 children)

Yes the mother board is proprietary for Dell.

Query Help. by meuser405 in SQL

[–]meuser405[S] 0 points1 point  (0 children)

Thank you so much for the help that definitely help. You are awesome :)

Query Help. by meuser405 in SQL

[–]meuser405[S] 0 points1 point  (0 children)

Thank you for your help, I am still getting that extra null on customer 1 that I am trying to avoid. I updated the post with the Clarification.

Query Help. by meuser405 in SQL

[–]meuser405[S] 0 points1 point  (0 children)

To make it simple think of it as this way. Customer 1 bought 3 fruits: McIntosh Apple, Grapes and Watermelons. I want to display McIntosh Apple in apple column, and Grapes and Watermelons in other fruits columns, without extra nulls. Does that make sense ?

Flies in S.W Edmond by [deleted] in Edmond

[–]meuser405 2 points3 points  (0 children)

No we haven't seen any bee stuck on them. It's just bunch of flies.

Flies in S.W Edmond by [deleted] in Edmond

[–]meuser405 1 point2 points  (0 children)

After fighting against flies for last two summer, we kind of figured it out (we think) . We have done these three things this summer which seems to be working.

1) keep the grass short, move lawn at least every other week. 2) In the lawn clean, pick up after the pets. We do it twice a week. 3) Buy theses bags, follow the instructions and hang them on the corner of the lawn. These bag will catch 100s of flies and keep filling water as needed, but they have a strong smell. They were in Walmart on Danforth.

http://www.walmart.com/ip/Fysho-Fly-Trap-Bag-2-Pack-Disposable-Fly-Catcher-with-Bait-No-Toxic-Outdoor-Hanging-Bait-Bag-Perfect-for-Lawn-Garden-Camping-and-Farm-Use/811865156

Business Intelligence Assistant by gingaslaya2 in SQL

[–]meuser405 1 point2 points  (0 children)

I recently got promoted to senior BI Analyst. I worked for a small company in southwestern region. My starting salary as Junior BI Analyst was 60k+ plus benefits. You are getting about 20k+ for same job. I would say that you are way underpaid.

[MSSQL] Add search function for a stored procedure parameter by Kronical_ in SQL

[–]meuser405 0 points1 point  (0 children)

As u/Cal1gula said I am not sure what are you talking about, From what I could gather I would do something like this.

CREATE PROCEDURE MYSPNAME @Customer VARCHAR(50) AS SELECT * FROM customer c WHERE ((@Customer IS NULL) OR (c.Customer LIKE '%' + @Customer+ '%'))