Search:

Not sure if this will be of any assistance...

App I wrote a while ago had 4 services running listening on HTTPListener's - that's besides the point.

For transmitting data, I created a CLASS,...

I'm interested in implementing Azure AD authentication to my web app.

https://docs.microsoft.com/en-us/azure/active-directory/fundamentals/auth-saml

Anyone doing with with IIS on the backend?
...

Basic

My backend webservices most likely do not conform fully to REST protocols

https://www.ics.uci.edu/~fielding/pubs/dissertation/rest_arch_style.htm

...but faking it works as well...


Option...

I'm busy for a few days, come back to check the Post Race and, wow, yikes - I got no words.

Let's move on, nothing to see here!

Random word of the day: Branch

Shaggy - at least you looked at the code!

Teaching people is not about telling them what not to do. It's about helping them navigate what they are trying to do!

fwiw...I am making progress.

I've decided to separate how to "determine" the print style to instead working on "print suggestion" logic. That work has to be done regardless.

Right now I'm...

btw - this is the source of the data - the SlickGrid in a browser window

I'm changing this logic to now take the grid of data and pass it back to the web server, where I've got a report writer engine that will render it into a PDF and deliver it to the client.

So far,...

This might seem like a web post at first - it is not.

Currently I use a SlickGrid in my web apps and when my users go to print these grids, I render the grid content into an HTML TABLE, and drop...

That's nuts! Who would have done that? We need a penetration test! I feel violated!

Seems it might have been VisualAd - it's odd what memories I have in this head of mine...

https://www.vbforums.com/showthread.php?551070-Christmas-Avatar&p=3406194&viewfull=1#post3406194

In my opinion, maintainability is very important in all my queries - client support goes on for decades and enhancements always come down the pike.

If you want to limit the JOIN'd rows, the...

You found me - yup - can't seem to flee! It's my safe space - I just have to remember to keep out of the political threads!

I just realized you have a c-clamp in your avatar, lol!

Put a sock on it!

Needing to see "detail orders" but based on "total quantity", might help in how they will fulfill said orders. Unique requirement for sure.

If I was doing this - I would usually be in a SPROC anyway, and I would build a TEMP TABLE with ITEM and COLOR and the TOTAL QUANTITY as the three fields. Build that in advance and then JOIN to it. ...

@Zvoni - so his query is correct - he needs the "detail rows" NOT GROUPED BY - they need to be in detail, but sorted by the total quantity for that ITEM/STYLE. Not even including the ID in the join...

GROUP BY is the simple, old school syntax, for reducing rows by a column(s) and using aggregate functions like SUM() and MAX()


Select id,item,color, sum(qty) "totalqty" from mytable a group by...

Not my server - not my IT department unfortunately...

My web app was denying logins - LOG disk on the server was full. I found an old 6GB backup of something - deleted it, just to allow logins -...

I just had to use this command to shrink a 350 GB log file!


BACKUP LOG Acctfiles TO DISK='NUL:'

DBCC SHRINKFILE ( Acctfiles_Log, 1)


NUL: - a null device. I feel like I'm back in my...

It is not a C# only world - classes have constructors.

In VB - it's a SUB NEW().

And you can have several - with different signatures. And then be able to create your class in a variety of...

imo, you made two right choices here - good luck. I left VB6 eleven years ago, then a small painful time in .Net Winforms and now all web/jquery/ajax and .Net running in IIS. I've got an online web...

Olaf - wow - you sure are committed to this. That was quite a post!

I never read his other thread - I just saw this DB thread and JMC scolding him for asking too many questions at once, lol!
...

Wow - I can see from your story that lots of opinions were dropped onto a pile with no one controlling direction!

As soon as I saw DB and SQL, I got happy. When I saw your need to store different...

XML is great for "transporting" information. You can use it to deliver an AJAX POST to a web service from a web page. I use JSON for that since my web app is written in JavaScript and JSON is a...

That was true in a much prior time of life. All kinds of odd things happen now. Two "educational" levels can certainly be in the same room with a teacher at the same time. Teachers and assistant...

This layout works fine for lower grade levels - in the US we would call this Elementary School. All students in the same grade level move from room to room as a group - as if all tied together with...

This should work


insert into #table_Northwind (column_name)
(SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
where TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='Northwind' )
declare...

Where did you get this? And what is it supposed to do?


Set @tbl_name = (SELECT (select column_name from #table_Northwind where RowID=@i) 'TableName' , o.name, [Scehma]=schema_name(o.schema_id),...

I've never even seen this type of OPENROWSET use to create XLS files. That was a link given to you by JDC2000 in the second post here in this thread.



while @i <= @max begin

Set...

Ok - so you limit yourself when you say you want an older version .XLS format file.

And I cannot imagine how a STORED PROCEDURE would interact with EXCEL.

Now you can flip the issue and...

How to you intend on creating the .XLSX file?

I am assuming you are creating this type of EXCEL file and not the older .XLS type.

I am also assuming you are not creating a .TDF file - which...

This might not be safe for work...here goes anyway! Google search for Chata Maxov. Go to Maps... satellite view...scroll to the right a bit and check out that odd roof top! Someone had a lot of...

You can write two "test" apps in the same project. One is the listener, waiting to get a request for a file, the other is the requester, ready to request a file.

This is my code to setup a...

I've used http listener logic just like that, to have 4 remote services communicating and sending files over the wire.

I'm assuming that the backend code running on the GoDaddy web server will...

Interesting - thanks for the links.

Is this similar to Android namespaces where you can call on "external" code? It's been a while since I played with Android - I might be using wrong terminology...

Just a suggestion - and sometimes the path I follow when building up new efforts in code.

Start with a few fields - even a single field. I always like to see that the plumbing works, especially...

If you had access via SSMS, you should be able to get access via the exact same connection method in your VB code.

To see how SSMS is connecting, right click the DATABASE from the EXPLORER pane...

Dim strQuery as String

strQuery = "SELECT" _
& "p.ID AS 'Order ID'," _
& "p.post_date AS 'Purchase Date',
& "MAX( CASE WHEN pm.meta_key = '_billing_email' AND p.ID...