Search:

Yeah, no.... you can't. And for good reason. Think about it, if you could embed your video player, then someone could embed a virus. That's why it's not possible. you can make a reference to it, but...

you need just rooms right? Not clients?
Ugh.... easy... first select the single rooms:


Select clientId from yourTable where RoomWithClientId = 0

That gets you all the singles...
OK, now get...

Great, then if your issue is resolves, can you mark this thread as such? You cna do that by usuing th Thread tools at the top right of post #1.

-tg

No it doesn't. Firstly you might want to rethink using the term client when dealing with hotel info... unless you're in the red light district, you don't want clients at your hotel. IF you have to...

hmm... apparently I'm not sure then...




aaaaah.... I found it...
bloody global variables...

try clearing them out when you're done... or before you start using them.

Its hard to read, but it looks like you're missing an .EndDocument...that's what tells the PrintDocument object that you're done with the document and to release it to the printer.

-tg

I'm in the office at work, where are you?
I don't jsut download the code of random people. Heck I don't even download the code of most people I do know on here.
Downloading code and fixing it on...

ok... hang on... WordPress is a template-based website. So if there is no title for your website, then it's because you didn't enter one on the configuration of your WordPress admin area. It's that...

If it works, why does it need to be modified?

-tg

Wouldn't this have worked?



Select Case mySingle
Case Is < 12
'
Case 12
'
Case Is < 24

In otherwords... it looks like you're only using the .Text property anyways... which is probably a String... so declare the parameter as a String, and rather than pass in the object, passing the...

I'll have to check those out. Ragnarok was really good.
For the most part sub-titles don't bother me, except that I may miss something on screen while trying to read the captions...


-tg

Yes! I was annoyed to get to the end of that episode and find out there weren't more waiting. I find myself watching more and more of these imports on Netflix. IT started with Money Heist (original...

I think that right there is the issue... I could be wrong about this, it's been some time since dealing with transactions like this, but the transactions are tied to the connection... and if you have...

Looks like the problem is lack of a EOL terminator... there's no way to know when you've reached the end of the data. That's a problem. That's why Mc_Vb suggested changing the output to include a...

But it isn't just diskspace... though is it? It's pagespace... it's the allocation of rowspace by the DBMS too. Because there's always more than just the image. There's the metadata that goes with...

That was my thought... it referrs to the currently running application,Word, Excel, Powerpoint... I don't think you can overwrite it like that.

Just what are you trying to do?

-tg

Agreed it was a general blanket statement, I just want to make sure that the OP does it with their eyes wide open. I've been in too many situations where blinders were on and this was "the solution"...

Yes. Yes. Yes. A million times yes.

-tg

I wasn't trying to be mean... I'm confused. But then again, that's not unusual for this forum... we tried to help and give you the best possible solution and you went off on a tangent with something...

If you can help it... don't. Do what you can to avoid it. If you can't make sure you're using the smallest images with high compression and making it as small as possible before storing it.
Trust...

So to recap:
"I need would like to do X, but can't figure it out."
"To do X, the best way, would be to do A and B, along with C."
"But it's not that simple because of L M N O P."
"Would have been...

I'm the reverse... I'd prefer to invest in the slim form that I can move about. Take the two worlds I live in: work & home. For work, they gave me an Apple MacBook Pro. My setup includes two...

In short: no. That's like asking if you're bank would know if your private wallet in your pocket would know if you had $20 or $10... the list is private, meaning it is only visible to the scope in...

.NET doesn't use OCX files. In fact it doesn't rely on COM in the first place, which is what OCX files are based upon. It's what makes them easily usable in VB6. So in order to use them in VB.NET,...

Hmmm... I see the problem -- it became apparent when I tried to re-write it...


" GROUP BY PersonID) AS T2 ON T2.PersonID = T1.PersonID where T1.PersonID= 2"

Dont join your second table to...

LEft join is what you want... but you need to handle NULL values.... when you add NULL vlaues, the whole expression becomes null...
So when you get to this point: SELECT TarifTotal + RecetteTotal AS...

Well it means that something on the line on which occurred us null or nothing. Your best bet is to examine each object from left to right when it happens. From experience, I can tell right off the...

Tack on "0000000" to the front, then take the right 8 ...

-tg

Who says it references anything? It should be the PKey for the table. At least that's what I'd expect it to be given the info.

-tg

Yeah, that's the kind of things the groups tble handled in the schema I used to work in... and it also tracked it over time, with begin and end dates... It just depends on how important it is. From...

In a previous life I used to work on a CMS that did fundraising... so households were something we had to deal with... along with deaths, divorces.... and other things... in fact, it was actually...

I think the issue might be thqt your Household table is really an Address table... I'd rename it to Address, and then create a Household table where you can create a Household ("John and Jane Sith")...

Then there must be something wrong with your data...

Here is a script I just used to replicate your tables and data:



create table Item_Tbl (
ID INTEGER,
Item CHAR(10 CHAR)
);

That's all fine and dandy (and quite possibly dandy and fine) but it still doesn't address the problem at hand, which is how to deal with CSV data when the data also has a comma in it somewhere.
...

Wait... are you talking about that 0 in the last column there where there is no data above it?
If there's no data, the default for numbers will be 0... that's probably what's happening here......

Be sure to let us know when your third eye grows... an pictures too... we demand pictures...

-tg

Awesome... I didn't realize you were resource hopping at first, otherwise I would have pointed you in that direction at first. Man, that drags up some (not so) fond memories. :D

-tg

But 0 is greater than -70 or -80... so if it's part of the dataset you're looking at, then that's the correct result. If it isn't, then there's something else that's wrong.
Idealy you should be...

Also, I don't think IIS_IUSRS is a global account, or a network account, it's a local machine account... it's used to access local resources when necessary. So the IIS_IUSRS account on machine A...