Search results for query: *

Hmm, I posted this already, but it doesn't appear to be on the site? Quick question. If I have a one MB file in Windows, and store it as a BLOB, does that BLOB item take up one MB of space in DB2? Basically, what I'm wondering is if our 3.8 GBs worth of files will take up 3.8 GBS of disk...

It's stored as quot; We also appear to have some issues with some characters getting translated into little boxes..... I assume this if from users using special charactes on a french keyboard. (we're in Canada) Is this a safe assumption

This is probably very simple, but I'm not sure how to handle this. We have a app built on jsp, beans, struts, and uses DB2 as the database. users enter information on forms, which gets stored on the DB. If they use quotes on the form, it gets stored as &quot. Is this a DB2 thing that does...

Thanks alot PHV!

Ok, i found on Google (but not in the Access help menu) that there is supposedly a HEX function that returns the character represented. To test it out, I try: SELECT * FROM TMSG WHERE MSG_TXT_FRC Like '*HEX(41)*'; and get no results, even though that hex characer is in the database. I...

Sorry to ressurect an old thread, but I have recently created a few more of these and have some more questions. I need to replace some apostrophe characters that are unique to French keyboards. When I try this: UPDATE TMSG SET MSG_TXT_FRC = Replace([MSG_TXT_FRC], ''(the french one', ''')...

The only functions I have in Access 2000 here at work are to convert Hex into Decimal, or Hex into Octal, or into Binary. Nothing shows up in my help menu but those.

Here's my problem. I have a table that is used to create a text file that is loaded onto an os390 mainframe, which is EBCIDAC. In my table, there are some characters that do not translate properly during the conversion from Unicode to EBCIDAC. What I need to so is search for these characters...

The app is a JSP app running under jboss, so on the server side..... (unless my coffee hasn't kicked in yet)

What's the easiest way to accompish this? We currently have the following code that takes what the user enters into a text box and retrieves the item. <html:link href="" titleKey="itracker.web.header.quickview.alt" onclick="document.lookupForm.submit();" styleClass="headerLinks">...

Ok, I got it working now. Thanks a lot for the help guys. If I could send a beer over the 'net, I'd buy a round!

I have tried both with and without the outside parenthesis. And I have just created a query in Access, and am running it. I am wondering if I"m simply confusing Access and it's trying to set all my TXT_MSG_FRC field to a string of "REPLACE(etc etc...")

Ok, I've tried the following and it doesn't work: UPDATE TMSG SET MSG_TXT_FRC = (REPLACE(MSG_TXT_FRC,"BN","dog")); I don't have a WHERE clause because I want to go through every row in the table. When I try this query, it tells me it's going to change 4701 rows (my table), but then when I...

Randell, does the replace function work for one character, or the whole field? update tblname set fldname = replace(fldname, "oldval", "newvale") where <criteria> almost looks to me like it will wipe out the entire field. Or maybe I'm just thinking wrong.....

I would like to be able to do a find and replace on a text field in a database table automatically. In Excel, there appears to be a macro where you can do this, but I don't see the same thing in Access? I'm not replacing the whole field, just a single character to "clean" my data. Any...

Actually, I figured it out. It seemed when I tried to use the PDF writer from the Print menu, it didn't work. When I used the Acrobat menu and converted it, it worked fine...... I don't know what the difference would be, but it works!

I'm using Acrobat 5.0, trying to convert a Word 2000 document into a PDF. In the past, everything has worked. Now, today when I convert the document, the table of contents no longer functions. Any ideas of what to look for from anybody who's had this problem before?

I have spreadsheets that I need to regularly import into an Access database. However, most times the spreadsheets contain updates to exisiting rows, and not brand new data. So, when I try to use the simple import command, it complains about the key violations. is there a way to do an...

But when I set my base, then my table of contents in the document doesn't work. It simply opens an Explorer window up to the directory of my Base, instead of going to the page it's supposed to. There has to be some way to do this in Word. They claim if I type my file in instead of selecting...

I am having a similar problem in Word 2000. I am typing out the link directly, using UNC: //server/share/path But whenever I send the document in an email, the linking get's changed to relative, which is no good for others on my network. HOw do I get the link to be direct and STAY direct?