Search results for query: *

Hello All, I don’t know if I should add to an existing database or create additional ones. This is what I have: content.mdb (holds all site html/txt content) 2,685 KB, heavy use site.mdb (admin and configuration settings) 724 KB, light use users.mdb (user accounts and form data) 1,429 KB...

EZ Q EZ A what can I say... Thanks, tsar mossimo

I have a simple amateur question. This is my SQL code: SELECT PassWrd, UID FROM tblUsers WHERE UID='"&Session("UID")&"' And this is the same code after MS Access applied its formatting: SELECT PassWrd, UID FROM tblUsers WHERE (((UID)='"&Session("UID")&"')); They both work fine so my question...

Please allow me to clarify my vagueness, - Page is ASP VBScript - vToMatch should have been intValOne,intValTwo,intValThree Very true lespaul a single SQL call is much better. I used your union query bellow to make a complete working solution. Witch is really the same as scriverb's original...

Thanks scriverb and yes vToMatch is a string value but I really don’t know how to implement your code. The examples I’ve found have been for access forms not asp pages? Could you give an example of how your code would fit into the database call? mossimo

My code below works fine but I’m not sure if it’s valid since I’ve never seen it done this way. I’m checking one field each in three different tables to see if it has data or is null. I only care if all three fields are null (false) or if any one of them has data (true). If someone with more...

Thanks dhookom, It works great, I was trying to make it to complex your soulution is simple. By the way you had a paren out of place should be: SELECT Max(Mid(Link,Instr(Link,".jpg")-2,2)) as MaxNum Not picking on you just trying to save someone else the troubleshooting. Cheers:) mossimo

I have a simple access 2003 database that contains links to pictures in a directory. Example: link = http://www.mysite.com/upload/MO_07191_02.jpg link = http://www.mysite.com/upload/MO_07191_08.jpg link = http://www.mysite.com/upload/MO_07191_05.jpg link =...

Yes you are correct it should actually be Select Case sVariable. It looks like copy and pasting wasn’t a good idea because it should be "1" and not “1” Thanks tsuji Cheers mossimo

Is there any real difference between these two ways of writing select case statements? Select Case(sVariable) Case “1” : Do(this) : Do(that) Case “2” : Do(thistwo) : Do(thattwo) End Select OR THIS: Select Case(sVariable) Case “1” Do(this) Do(that) Case “2” Do(thistwo)...

Yes it helps a little Mark. Only about half the variables can be found this way but it’s a start. I was trying to re-code the standard 500-100 page shipped with IIS to loop through and report all non dim’d variables but it’s been a little difficult, still I think this is a good idea.

I have been stuck with the task of converting a large web sites code so that all local variables are explicitly declared. Currently <% Option Explicit %> is not used at all. I’m looking for a way to list all local variables by page or site wide. This would save a lot of time.

Re-Installation failed to fix the problem so I just finished a disk format and clean install of XP so it’s all working now. I believe the problem may have been a result of my recent upgrade to DirectX 9 but I’m not sure. Really to bad I couldn’t find the source but I didn’t have the time to...

First off let me say I deeply appreciate everybody’s help. Linney I tried all your ideas and no luck so I am now doing a re-installation of XP I will let you know how it turns out. Cheers mossimo

Uninstalled (Q824145) and no change, Microsoft Office is also up to date and bcastner I empty all my temp folders and ran disk clean up. No miracles. Linney I admit I did copy and past. I simplified the problem for brevity. The whole story is this: I can always make a selection by clicking at...

Yes right click is what meant. Ok bcastner I ran Fix_IE.cmd and registered the dll’s but it didn’t fix it. “slight greater than 50%” doesn’t sound to good to me are you suggesting that this may be a more serious problem like an unrecoverable OS corruption or something else sinister?

I have lost the ability to select and copy text with the mouse. I can highlight a selection but when I left click to open the copy past context menu my selection is lost. This behavior occurs in any file or application (system wide). I’m running XP Pro with all current service packs and...