Search results for query: *

I need a little assistance. I'm trying to include a menu system at the top of my webpage, and have need to insert an include in every page (the include has the menu system in it). I'm using Dreamweaver CS3 - and when I do a server side include (in php), the link is made, and the include...

I need a little assistance. I'm trying to include a menu system at the top of my webpage, and have need to insert an include in every page (the include has the menu system in it). I'm using Dreamweaver CS3 - and when I do a server side include (in php), the link is made, and the include...

Greetings All - A quick answer to this, if possible, please - to keep me from losing it.... I have a photoshop file with about 30 layers in it - many of which contain drop shadows. For some reason, they've all disappeared! Does anyone know of a often-errored method of losing your...

My brain is totally shot - anyone remember what the syntax is for pulling a ton of data into a temp table? It was something like Select into #temptablename ...Fieldnames from ...tablename where ...constraints Thanks, //sse Sean Engle Admin/DirIS ssengle@bswusa.com

Before I start pulling my hair out... Does anyone know of any real specific 'gotchas' with respect to Win2kSvr and it's print services? I just moved my company to a new print server with Win2kSP3 on it - and loaded the drivers (all HP) - it seemed to work fine. Now the spooler is being shut...

Help..... I have a old Fujitsu line printer DX2400 - which requires us to create a user-defined paper type for us to print check stock on. A consultant set this up years ago - and that box has died - so I've moved our AP person to a new box - but - that's right - I have no idea of how to set...

Our bank wants reports - which is not a problem - but they want numeric fields that are completely filled - so that if a nine digit numeric is for 10.00 - it would appear like this: 00000010.00 How on earth do I do THAT??? :( //sse Sean Engle Admin/DirIS ssengle@bswusa.com

Anyone know if an easy way to convert a datetime field to a MMddyy format? Thanks for your help! :) Sean Engle Admin/DirIS ssengle@bswusa.com

Ok - so this is the last issue - and I swear I'll stop whining... I have a numeric field that I converted to a decimal field. I need to now convert that decimal field to a varchar or char so that my ASPMail app can pick up the whole string (right now, it only picks up non-zero values - so...

I have a numeric field - one that I need to convert to char or varchar - so it will only display two decimal places. When I attempt to use the numeric field itself (without conversion), adjusting the decimals down to two, it rounds the value off (so $159.62 becomes $160.00). Does anyone know...

I have a (SQL2k) field set up as a decimal, 9 - 18,2 - and for some reason the values following the decimal places will not show when they are zero ($3.00, for example comes up as $3). I'm using ASPQMail - and they swear that they just pump out whatever is in the field (which is $3.00) Anyone...

I'm using the Money Data Type becuase I need an automated email to spit out dollar amounts. Do any of you have any idea how I use the Money Data Type to show it with 2 decimal places instead of 4? Am I wrong to use this data type - should I be using something else? Thanks in advance! :)...

Ok - I really need some help. I'm trying to build a trigger on a table that with every insertion will look at the record inserted, and then, if it meets two condtions (SOPTYPE 2 and today's date in DOCDATE), will kick out an email via SQL Mail. This is what I have...

I'm building a job in SQL7.0 that includes a call to an executable on the root drive of the server. On the command line for that particular step, I have: CmdExec C:\Ship_Notify\NotifyShip.exe but it keeps failing to find the file. The exe file is there - and can be executed by double...

I have three tables I'm trying to use in a query (to pull up a list of RECNUM and PO Numbers, but not those in a resricted table SEANR), two of which I need to do a left outer joint on. My script: select PO20301.RECNUM, PO20302.PONUMWRK from PO20301 LEFT OUTER JOIN PO20302 on...

We're using Great Plains eEnterprise, and I want to create an auto-numbering account number creator in VBA. I want to write a VBA bit that will go to a specified text file, take the number contained in it, use it for the account number, then write back that number to the file, plus one...

I'm a little confused...I want to use xp_sendmail to kick out some shipment notifications to customers, and generally understand the syntax, but do not understand where it specifies the table that contains the data. Could someone give me a nice, easy example of a simple xp_sendmail statement...

I wrote the following script to update a field on a table. That table is related to two others by customer number and document number. When I run this, I get a completion notice, but no rows (and I know it's supposed get one row I prepared for it). Anyone see where I've screwed up? Thanks...

We want to implement outbound email from SQL - that is, I want to write a sproc that executes daily, and looks for certain table conditions, and then sends out email (basically shipment notifications). I understand that CDONTS is supposed to be the way to do this ... Does anyone have any...

This is seem pretty stupid to most of you, but I need help writing a select statement that will pull a datetime field. The deal is, however, that I need it to pull just the year, month and day (YYYY, MM,DD) and not the time. Does anyone know the short easy way to do that - or -...