Datetime työt

We need a blue pop up where we can adjust the time and which page it display for insttance we want the pop up to display 45 seconds after the 3rd page view the pop up will ask for name + email address after they hit submit it will send an email with a code to their email address and write their email to a database table emailOptIn { emailDate datetime, name text, email text } view screenshots

...display a text box for a price they are offering and a box for their email address sample see 3) after they enter the information and hit submit it will display a message "Thanks for your offer. We will review it and email you with our answer" it will write their offer into a table below with a distinct hash key create table offerMaster ( offerKey varchar2(20) primary key, offerTime datetime not null, email text not null, item_no int not null int, offerPrice decimal(20,2) not null, accepted int(1) default 0 ); 4) next i need a jsp to view the offers next to each offer there will be an accept button and re-offer button the accept button will set accepted=1 in the table and email the customer an email We have accepted your offer. please click here...

...text box for a price they are offering and a box for their email address sample see 3) after they enter the information and hit submit it will display a message "Thanks for your offer. We will review it and email you with our answer" it will write their offer into a table below with a distinct hash key create table offerMaster ( offerKey varchar2(20) primary key, offerTime datetime not null, email text not null, item_no int not null int, offerPrice decimal(20,2) not null, accepted int(1) default 0 ); 4) next i need a jsp to view the offers next to each offer there will be an accept button and re-offer button the accept button will set accepted=1 in the table and email the customer an email We have accepted your offer. please cl...

Need a SQL Server function that returns the number of working days in a month. We work Monday to Friday. I have found a function that returns the number of days in a month: CREATE FUNCTION [dbo].[fn_GetDaysInMonth] ( @pDate DATETIME ) RETURNS INT AS BEGIN RETURN CASE WHEN MONTH(@pDate) IN (1, 3, 5, 7, 8, 10, 12) THEN 31 WHEN MONTH(@pDate) IN (4, 6, 9, 11) THEN 30 ELSE CASE WHEN (YEAR(@pDate) % 4 = 0 AND YEAR(@pDate) % 100 != 0) OR (YEAR(@pDate) % 400 = 0) THEN 29 ELSE 28 END END END GO This returns the total number of days. I want the number days between Monday to Friday only. For eample this month there are 31 days but only 21 working days.

...(textarea) ** Why are you here? (select box) * PHP functionality - On page load, save in MySQL: * Unique AdWord reference in URL * Unique Session Identification * Start DateTime * Page Layout Identification Id (hardcoded string) * Marketing Content Identification Id (hardcoded string) * Corporate Identitty Identification Id (hardcoded string) * Basic User-Agent Information (Which Elements, TBD) - On abandon, save in MySQL: * End DateTime * Abandoned Flag = True * Conversion Flag = False - On form submit, the page will update/save the following in MySQL: * End DateTime * Abandoned Flag = False * Email Address * First Name * Last Name * Phone Number * Comments * Selected Reason * Conversion = True * Date/Time ...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

...Second the Customized Section 1.) login page 2.) Product page that could only be seen if user is logged in seen by both factory or sales office 3.) Product administration, Auto generate product ID, width, length, price, description. Add product with product image, Update product delete is not a hard delete but instead a hide with meta data. This will be the meta data LastModifiedBy DateTime LastModifiedDate Active Inactive Deleted Archived 4.) Product picker that could only be used by the sales office (Like a shopping cart) to pick products for an order - we will be ordering from our factory to our front end store. 5.) a shipping page to let the store know that the factory shipped it with date of shipment, shipment number, Order detail, details of shi...

...";s:4:"skin";s:7:"default";} ---- If i try to import this part from mysql backup i get this error: ---- Fout SQL-query: CREATE TABLE `index_process` ( `process_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT , `indexer_code` varchar( 32 ) NOT NULL , `status` enum( 'pending', 'working', 'require_reindex' ) NOT NULL default 'pending', `started_at` datetime default NULL , `ended_at` datetime default NULL , `mode` enum( 'real_time', 'manual' ) NOT NULL default 'real_time', PRIMARY KEY ( `process_id` ) , UNIQUE KEY `IDX_CODE` ( `indexer_code` ) ) ENGINE = InnoDB AUTO_INCREMENT =9 DEFAULT CHARSET = utf8; MySQL retourneerde: Documentatie #1005 - Can't ...

I would like a small Project Created in Codeontime. * The database will consist of two tables. * A table which will contain a l... [Email] [nvarchar] (50) NULL, [Insurance] [nvarchar] (50) NULL, [Description] [nvarchar] (4000) NULL, [CreatedDate] [datetime] NULL, [Comment] [varchar] (100) NULL, [Status] [int] NULL ) CREATE TABLE [dbo].[Communication]( [CommunicationID] [int] IDENTITY(1,1) NOT NULL, [CustomerID] [int] NULL, [Type] [varchar] (50) NULL, [Subject] [varchar] (200) NULL, [Text] [varchar] (8000) NULL, [CreatedDate] [datetime] NULL, [CreatedBy] [varchar] (50) NULL, [UpdatedBy] [varchar] (50) NULL, [UpdatedDate] [da...

...upload. 3. The address of the webserver will be read from a *.ini file in the Symbian phone, which can be updated from time to time. 4. The webserver uses a mySQL database 5. The webserver code to update the database should be in ruby on rails or php. 6. The database structure format is as follows, mysql> CREATE TABLE Calllog ( -> device mobile number, -> callstarttime datetime, -> callendtime datetime, -> calltype varchar(20), -> callerid varchar(1000), -> filelocation varchar(1000), -> recording status -> ); device mobile number - the caller id onumber of the mobile phone that callstart/endtime ??" the call date and start time obtained from the call log. calltype varchar(20) ??" Incoming/outgoing/missed. Dire...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

...XML: (per keyword phrase) <KeywordPhrase> <Word>holiday</Word> <Word>Egypt</Word> </KeywordPhrase> <SearchEngine Description= “description” Language=”NL” Region=”NL”> <Identifier URL=”” Position=”1” DateTime=”8/9/2010 13:43:22”/> <Identifier URL=” ” Position=”2” DateTime=”8/9/2010 13:43:22”/> <Identifier URL=” ” Position=”3” DateTime=”8/9/2010 13:43:22”/> . . <Identifier URL=”” Position=”23” DateTime=”8/9/2010 13:43:22”/> . </SearchEngine> <SearchEngine> </SearchEngine> . . Per mon...

1.) login page 2.) Product page that could only be seen if user is logged in seen by both factory or sales office 3.) Product administration, Auto generate product ID, width, length, price, description. Add product with product image, Update product delete is not a hard delete but instead a hide with meta data. This will be the meta data LastModifiedBy DateTime LastModifiedDate Active Inactive Deleted Archived 4.) Product picker that could only be used by the sales office (Like a shopping cart) to pick products for an order - we will be ordering from our factory to our front end store. 5.) a shipping page to let the store know that the factory shipped it with date of shipment, shipment number, Order detail, details of shipment weight, cost, arrival. 6...

I want to fetch data from twitter using JAVA So if i search for "Raajneeti" then i want all tweets, users and datetime in an excel file. it should be dynamic and shld fetch data for all urls. ## Deliverables requirements notice: As originally posted, this bid request does not have complete details. Should a dispute arise and this project go into arbitration "as is", the contract's vagueness might cause it to be interpreted against you, even though you were acting in good-faith. So for your protection, if you are interested in this project, please work-out and document the requirements onsite.

I need a print logging module for Delphi 2007. It should be in delphi2007 (cause I should embedd it in to an existing delphi logging application) It should work on a windows (xp/2003 or later both 32 and 64bit OS) computer and log every (successfully completed) print job with detailed information (datetime, user, copycount, pagecount, documentname, printername) for any printer connected to this computer, regardless of the printer type/brand/model/connection type (virtual/serial/parallel/usb/network/shared, wireless... whatever kind of printer connection is possible) (A System Driver -c++- solution may be acceptable with a delphi controller) NOTE: Demo is a must to get the job. ## Deliverables 1) All deliverables will be considered "work made for hire" under U.S. Copyrig...

DEVELOP GPRS DEVICE THAT CAN COUNT NUMBER OF INCOMMING PULSES FROM A REED SWITCH (MAX 100 PULSES PER SEC). SEND FOLLOWING DATA EVERY HOUR. <PULSECOUNT_32BIT>,<GPRS IMEI NO>, <DATETIME>,<BATTERY LEVEL> BATTERY POWERED, MICRO SLEEP MOST OF THE TIME, WAKE ON INCOMMING PULSE, INCREMENT COUNTER THEN GO TO SLEEP. REAL TIME CLOCK MUST WAKE UP MICRO EVERY OUR TO TRANSMIT THE ABOVE HTTP GET QUERYSTRING. PLEASE ALSO INTEGRATE RS232 TO PROGRAM DEVICE LATER, MUST BE ABLE TO CONFIGURE HTTP ADDRESS USING RS232, EG SEND: URL = , MICRO WILL RESPOND "ok" PLEASE USE SIM COM MODULE + EAGLE FOR PCB IS PREFERRED. PLEASE USE PIC MICRO, DEVELOP SOFTWARE FOR MPLAB IDE. YOU DESIGN THE SCHEMATIC/BOARDLAYOUT, CHOOSE MATERIALS TO KEEP MANUF COSTS TO MIN.

****1 MYSQL QUERY! ** Should not take...the server limit or not. I will be putting it on a CronJob. I've managed to get my host to extend it to 500 recipients, but thats still not enough. It says "the mail servers will automatically unblock/reset your account one hour after the first message that was sent." Currently before an email is sent it gets added to a table in the database. THEN after the email is sent, it adds the datetime to when it was sent. It needs to calculate to see if it has passed the limit. If not, continue to send. If so, stop sending. PLEASE SEE: Here is some scripts if it helps. - -

...right. You can see the admin here on the test site user: admin password: admin Database looks like this CREATE TABLE IF NOT EXISTS `system_info` ( `system_key` varchar(50) DEFAULT NULL, `script_version` varchar(10) DEFAULT 'v1.1', `last_cron` datetime DEFAULT '0000-00-00 00:00:00', `last_optimize` date DEFAULT '0000-00-00', `last_upgrem` date DEFAULT '0000-00-00', `last_sreset` date DEFAULT '0000-00-00', `last_access` datetime DEFAULT '0000-00-00 00:00:00', `access_ip` varchar(15) DEFAULT NULL, `reg_domain` varchar(255) DEFAULT NULL, UNIQUE KEY `system_key` (`system_key`), UNIQUE KEY `script_version` (`script_version`), UNIQUE KEY `reg_domain` (`reg_domain`) ) EN...

...document types into the table (DocTypes) We also need another combo box where the user can pick the priority value of the document. (A number 1-5 [5 being the most important]) Then we need a description field that can take up to 255 characters - needs to be larger than what is already on the existing form. We need a date field where the user can input the actual date of the document . The scan datetime would be taken when the document was originally scanned. Next we need a small grid where the user can add his keywords to associate with this document. Each keyword or keyword phrase would be saved as a single record that links back to the record that saved the document descriptive data. It would link back by saving the parentrecid - which is the original recid of the record descri...

...[DF_SalesToolDemoMenuItems_SortSeq]? DEFAULT ((0)), ? ? ? ? ? ? ? ? ? ? ? [Inactive] [bit] NOT NULL CONSTRAINT [DF_SalesToolDemoMenuItems_Inactive]? DEFAULT ((0)), ? ? ? ? ? ? ? ? ? ? ? [CreateDateTime] [datetime] NOT NULL CONSTRAINT [DF_SalesToolDemoMenuItems_CreateDateTime]? DEFAULT (getdate()), ? ? ? ? ? ? ? ? ? ? ? [CreateUserGUID] [varchar](50) NULL, ? ? ? ? ? ? ? ? ? ? ? [ModifyDateTime] [datetime] NOT NULL CONSTRAINT [DF_SalesToolDemoMenuItems_ModifyDateTime]? DEFAULT (getdate()), ? ? ? ? ? ? ? ? ? ? ? [ModifyUserGUID] [varchar](50) NULL, ? ? ? ? ? ? ? ? ? ? ? [GMTDateTime] [datetime] NOT NULL CONSTRAINT [DF_SalesToolDemoMenuItems_GMTDateTime]? DEFAULT (getutcdate()) ) ON [PRIMARY] ? Developer does not need to procide a SQL Database just a dataset w...

...each of the rows in the table and check how many times they appear on? Google? and save it to the? field 3. Go over each of the rows in the table and check how many times they appear on twitter and save it to the? field the? APPSUGGESTION ? table should have these columns: CREATIONTIME (datetime when this row was created) SUGGESTIONDATE (datetime when this suggestion was made on tweeter)? SUGGESTION (string with up to 1000 characters) SOURCETYPE (string with up to 40 characters? should say TWITTER by default , we might add more sources in the future)? SOURCE (string with up to 40 characters - twitter user that tweeted this suggestion) GOOGLEOCCURRENCECOUNT (long - number of times the same suggestion

...the alerts to. ? Alerts: 1.? ? ? ? ? ? Create a php Cron file, that will go through the database table and check all the websites and to see if they are up or down. ( there are a few php open source classes you can use to check the status, just google “php ping class?? a.? ? ? ? ? ? Cron will run every 1 minute, but will check only websites based on user selected interval and last checked datetime vs now. b.? ? ? ? ? Cron will send email to user recipients in the account, including the default user email when there is a status change. It should send email either when status changes from Up to Down and also from Down to Up. 2.? ? ? ? ? ? Create an Email folder on the site, which will contain html email templates that I can modify easily. ? Templates should have dy...

I need a simple .exe program which can download a HTML page from a URL provided and extract some data from a HTML table on that page. The table, rows and cells all have UIDs provided by css class names. Data needs to be saved to an XML in a certain format. The data ...extract the position from within the<td class=??c1??> cell and the team name from within the A tag of the<td class=??c2?? cell. Goal Difference can be collected from <td class=??c14??>and Points from <td class=??c15??> Once all of this has been collected, simple write the lineto the XML and repeat for the next row in the list. Format for XML file: <leagueTable competitionName="xxx" updated="[datetime]" season="2010" > <entry rank="x" ...

...private) class list : Country DownloadType Fabricant FileType Ip Keywords Language Member_type Navigateur // (is the web navigator) Os (windows, linux, mac) Page PaymentType Pc //(Computer) PluginNavigator RedirectionType Referer Resolution Status StatusType Stat_id //for later to make a script of statistics in any domains) TimeArrived //datetime the visitor arrive on the site TimeGone //datetime he quit the site (after i make the calcule to know how time is stayed) VisitorType I need for class all function to insert , update, delete, count in my database Don't use SELECT instruction i not need for the moment Don't hesitate to contact me. (Sorry for my bad English) Best regards NOT WESTERN UNION PAYMENT DO...

I require a windows service application (written in c# or vb.net / framework 2.0+) that will capture packets and extract SMTP traffic. I have license for IP*works 8 for .NET so IpMonitor component can be used for low-level packet capturing. WinPCap solutions are OK too. ## Deliverables * I normally will use this to capture SMTP traffic extraction that will include the header fields (datetime, fromAddress, toAddress, subject, size, options, attachments). I don't need the contents of attachments but it's a plus if the bidder can implement this * It must use an OOP model for delivering TCP session data so that I can extend the project for use with other protocols (say HTTP) * I must fire an event so that I can process the e-mail object captured. * * *This bro...

...any ideas as to how to do this, but ideally I want the information written to my own database. *Please note that I CANNOT make any changes to the server that receives and runs the SCORM package; the only thing I control is my own database/web server.* My SQL Server 2005 database table contains four columns to be written to: StudentName (nvarchar), StudentId (nvarchar), Score (float), and Time (datetime). The values I need written to the database are the student name, the student ID, the exam score, and a timestamp. The server itself is Windows Server 2003, IIS6, .NET framework 3.5. Inside the SCORM package, the best place to access the score is in the file /js/os_learningObject.js. In this file, there is a function called DataSaveX(). This function is called when the Score Test b...

...the modifications work. ## Deliverables As mentioned, the attached package is a SCORM e-learning exam. You can upload and run the package for free, as well as learn more about what SCORM is, at My SQL Server 2005 database table contains four columns to be written to: StudentName (nvarchar), StudentId (nvarchar), Score (float), and Time (datetime). The values I need written to the database are the student name, the student ID, the exam score, and a timestamp. Once I accept your bid, I will provide you with a login ID with read and write permissions; please let me know what other information I need to provide you with to allow you to connect to the database. The best place to access the score is in the file /js/

I have a merchant account setup through netbilling. I need this integrated with my existing site which is made ...have a merchant account setup through netbilling. I need this integrated with my existing site which is made with cakePHP. Further, I need integration with twitter and facebook connect. I also have a chat support script that I need integrated. The fourth thing I need is a tracking table in mysql. Every click into the site should be captured and cookied. The table should have columns: datetime, subid, referrerUrl, currentURL, previousVisitID, memberID, isExistingMember. The memberID should be saved here if/when the person signs up through the site. Please msg with your previous experience. I need a clean integration. Knowing jquery or something similar is a h...

...SysUptime Added / Maintained by scan function LastScanAttempt Added / Maintained by scan function (DateTime) LastContact** Added / Maintained by scan function (DateTime) ContactMethod*** Added / Maintained by scan function * MAC Address is the primary key in the database ** may not be available for all devices *** Ping, SNMP, FTP, etc. The Network Scan This routine is separate from the discovery routine. The purpose is to monitor the real time state of all the devices originally discovered by the network discovery routine or manually entered into the NetDevices table by a user. Every device listed in the table will be probed. In all cases, the LastScanAttempt will be set to the datetime when the first attempt to contact the device is sent. The first...

...nightly. ? **Photo Upload** -? ? ? ? ? ? ? ? ? The user will be able to upload JPG files only using a ‘browse local machine’ facility. -? ? ? ? ? ? ? ? ? Once a photo is chosen and uploaded a preview is available with a continue/cancel option. -? ? ? ? ? ? ? ? ? A textbox will allow the user to provide an email address which is stored in a separate XML file together with student ID and datetime. -? ? ? ? ? ? ? ? ? Multiple entries in the XML file are NOT permitted. -? ? ? ? ? ? ? ? ? Photos will be saved using the student ID as the filename with the .jpg extension. -? ? ? ? ? ? ? ? ? Existing photos for the same user will be overwritten! -? ? ? ? ? ? ? ? ? Once submitted show a ‘thank you’ message. ? **Photo Admin** -? ? ? ? ? ? ? ? ? ...

Require development of a Joomla 1.5 component that has elements querying both a MySQL and a MSSQL database and displays the returned data in joomla paginated format. There should be a configuration options in the admi...admin backend to specify alternate database name, and username and password variables, as the database will not necessarily be the standard Joomla database. The code should be well documented. The database structure is detailed below: Table Name: DataTable Field 1: ID INT - sequence/primary key Field 2: FieldName VARCHAR(15) Field 3: FieldDescription VARCHAR(MAX) Field 4: CreatedDate DATETIME Field 5: CreatedBy VARCHAR(50) The front end should be able to return basic data in the following column format: ID, FieldName, FieldDescription, CreatedDate,...

...do this demo app using the trial version of the DevExpress suite. The app needs to be able to create, update, delete and display bookings in resource view. The tricky part is each booking will be for three seperate resources. ## Deliverables I expect the application to work with a atabase structure as follows: * * * tblBooking ---- BookingID (int) StartDate (datetime) EndDate (datetime) Description (varchar(250)) InstructorID (int) StudentID (int) Classroom (int) tblInstructor ----- InstructorID (int) FullName (varchar(250)) tblStudent ---- StudentID (int) FullName (varchar(250)) tblClassroom ---- ClassroomID (int) ClassName (varchar(250)) * * * Only the instructors and classrooms need to be disp...

I have the following running on mssql express 2008 and need to script or a application to dump the table to a csv file, if the file exist then it needs to be over wrote. here is the dump from the mssql server ...needs to be over wrote. here is the dump from the mssql server USE [trbonet] GO /****** Object: Table [dbo].[Locations] Script Date: 07/08/2010 00:01:19 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Locations]( [Date] [datetime] NULL, [Latitude] [float] NULL, [Longitude] [float] NULL, [Speed] [float] NULL, [Direction] [int] NULL, [Precision] [float] NULL, [RadioID] [int] NULL, [ID] [int] NULL, [Name] [nvarchar](200) NULL, [ExportDate] [datetime] NULL, [Mph] AS ([Speed]*(0.62)) ) ON ...

This is a one-off project. I have a Visual Foxpro database that I need to parse information from and have that? information saved into a text file. ## Deliverables The database to pull the information from has eight fields: DATETIME MSGTYPE IP PORT ACTION MSG SRC_FNAME SRC_FPATH The information in this? database goes back to 2008, but I am interested only in SEP09 - JUN10. The only fields we are concerned with are DATETIME, MSG and SRC_FNAME. The MSG fields that start with 'MSH' contain the data that needs to written to text file.? The name of the text file is contained in the SRC_FNAME field for that record. I can supply actual message files for reference. The system that produces the original messages resets its nam...

Hello, We need an Email2SMS setup that runs with postfix mail server running on Cent OS and could be easily integrated with our SMS Gateway API. The domains for which the mail2sms will work should be configurable using an config file. Eg., If someone sends a...should read the config file whether the domain is configured for sending mail2sms alerts and if found should do the processing for sending the sms alert via sms gateway. Please note that there could be several domains that would be enabled to accept the mail2sms requests. The required parameters by SMS Gateway API are, Username, Password, Message, MessageType, Mobile, Sender, Schedule, Datetime , GMT. I would like to know more details and a detailed plan about how it could be done. Kin...

...również pasek magnetyczny lub chip. '); -- -------------------------------------------------------- -- -- Struktura tabeli dla `zbyster_comment` -- CREATE TABLE IF NOT EXISTS `zbyster_comment` ( `id` int(11) NOT NULL auto_increment, `user` text character set utf8 collate utf8_unicode_ci NOT NULL, `information` text character set utf8 collate utf8_unicode_ci NOT NULL, `date` datetime NOT NULL, `card` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ; -- -- Zrzut danych tabeli `zbyster_comment` -- gg:4730889 zbyster@gmail.com...

SharePoint 2010 Visual Web Part: World Clock Web part with active (ticking)? analog and (ticking)digital options.? The developer will deliver 5 analog and 5 digital clocks that can be chosen and configured using the Web Part Tool Pane and displayed in the customer's environment in a grid format of one or more clocks.? In addition to deliveri...and family css for location title (for example: "font-family:arial;font-size:10px; font-weight:bold") * The 5 analog must have the following * different backgrounds * different borders * different hands * The 5 digital clocks should all have different * Configurable fonts * Configurable background colors * Tool pane configured date/time format using C# datetime() formatting * All code ...

Thanks for looking! Here's what I have: *CakePHP project, very basic. Project is an Incident reporting/Invoicing/Customer/Accounting/Parts system for my business. *A customer database table with name, phone number and ID, etc. An invoice table that includes customer_id. -------- AJAX-based form elemen...this element without too much work on other pages. I have about 20 other projects that I would love to find a good programmer to work on. CREATE TABLE customers ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50), type VARCHAR(50), phone1 VARCHAR(50), phone2 VARCHAR(50), phone3 VARCHAR(50), phone4 VARCHAR(50), created DATETIME DEFAULT NULL, modified DATETIME DEFAULT NULL, notes TEXT, ...

1. The app would make a call to the server and will get a fixed number of news (say 25) through XML output. 2. Each element of the XML output retrieved through ajax call will have the following: A. Header B. Caption C. Content D. Source Name and Source Link E. Link to the News F. Publish DateTime G. Category H. Image Thumbnail URL (Optional) 3. The app will display all the news in a list format with header, caption, source and time span from now and publish time (e.g. Posted 2 hour ago). If available, thumbnail of a fixed size will also be displayed. News can be filtered through a Category filter. 4. On clicking the News Header/ Next button / More link the user will see the news in the browser. Please note that the user should not leave the app. The browser should open wi...

...MEALLOG FIELD CONTRACTTYPE SHOULD CONTAIN THE LETTER 'L' -------------------------------------------------------------------------------------------------- INSERT THE RESULT INTO A NEW TABLE CALL IT AS LUNCH-TRIPSHEET WITH FOLLOWING FIELDS -------------------------------------------------------------------------------------------------- SHEET-ID - AUTONUMBER (AUTOINCREMENT) TRIPSHEETDATE - DATETIME- INPUT VALUE OF TRIPSHEET-DATE DRIVERNAME - VARCHAR(50) GET THE DRIVERNAME FROM DRIVERS TABLE WITH DRIVERID INPUT COMPANYNAME - VARCHAR(70) COMPANYNAME MOTTA - INTEGER MV - INTEGER BARIK - INTEGER BV - INTEGER CHAPATI - INTEGER BVC - INTEGER MVC - INTEGER OTHER - INTEGER REFER THE ATTACHED TRIPSHEET HTML FOR REFERENCE 1=SUN,2=MON,3=TUE,4=WED,5=T...

Needsomebody to develop or provide firmware to perform the following action: 1. Power on GPRS device via PWRKEY/VBAT outputs on PIC. Send the following test message via GPRS/SMS. 2. <datetime> TEST1 <TestNo> where <dateime> is current time from SIM900 RTC and <TestNo> is in incrementing number starting at 1 then 2, 3 and so on... 3. Power off GPRS device via PWRKEy/VBAT outputs on PIC

...the jobid received from success response from gateway - smsid: stores the smsid received from success response from gateway - sentdatetime: datetime when message was sent Table name: MessagesIn Messages received from SMS provider, which originated from a mobile user sending a text to a shortcode. - msgid: (identity column) - distinguishes messages from each other. - mobilenumber: phone number of the sender of the message. - operatorid: denotes which service provider connection was used to receive message. - msg: text of the message. - smsinboxid: SMS provider’s reference number for all incoming messages. - received: datetime message was received. - shortcode: short code the message was sent to. I think this is very clear, but contact me ...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

...When files are processed, they are copied to an archive folder that contains a certain number of archive files. Code is already in place to properly import data. ? The trick in the new routine is going to be looking for records that are no longer in the source data that need to be deleted. ? this may need to be done as a separate cleanup routine that could run nightly. ? If we add an updated datetime stamp to each record, then we could delete records that have not been updated in the past X days, that would be fine...

...When the user submits the form; four things need to occur 1 - A table called "incident" needs to be inserted with: *incident_id (int)(pk) <-- This is autoincrement so no need to specify *incident_number (int) <-- From the Incident Number textbox above *incident_short (text) <-- From the Short Description text area above *incident_start (datetime) <-- From Start Date and time above *incident_end (datetime) <-- From End Date and time above *incident_priority (int) <-- From Priority drop down list above) 2 - The table called rel_incident_problem needs to be updated with a new record: *rel_incident_problem_id (int)(pk) <-- This is autoincrement so no need to specify *incident_id (int) <-- From the incident_id generated by the...

...enter date, servername, server IP) 3. Once a day the script checks for Status = false entries and submits the account to GR database. Once submitted the status is changed to “true” and submits the datetime in the “enter date” field, also submit the servername, and server IP. a. Only does 45 entries a day b. Create loop to enter one every 20 seconds 4. Independent server scripts – scripts that are on a different server, once a day connect to the sever, pulls the next 45 entries, enter it into GR server then update server (1 entry every 20 seconds), change the status to “true” and submit the “datetime“, “servername”, “serverIP” -Please create admin like the attached file. It is base on admin...

...drive 2. Attempt to connect to? the new? webservice. 3. If successful will? go through some authentication (i.e. we do not want anyone uploading!) 4. If successful it will send this timesheet data: - ProjectID? int? - TaskID? int? - StartTime? datetime? - EndTime? datetime? - LastUpdate? datetime? - Notes? nvarchar? 50 - TimeID? int? - Status? bit? - Minutes? int? - Source? nchar? 1 - Charge? float? -? CheckSum? nvarchar? 50 5. Will update a column called LastSynced datetime with the current date/time for all successfully synced entries. The webservice will: 1. Allow client applications to connect and authenticated 2.? Accept the timesheet data and save that data to a SQL Server 2008 database ta...

dbma - ms access requirement build sql query to update running totals on a table. The table has a format as follows: BankTotalID Autonumber, BankAccountID Number, BankTotalDate DateTime, BankTotalAmount Currency, BankRunningTotal Currency BankTotalAmount is the total for the day's trade and the running total must be the sum of earlier days, eg opening balance = 30 day1 tot = 10, running = 40 day2 tot =67, running = 107 day3 tot = 89, running = 196 This must be a sinlge sql query to update the table or insert into a new table the running totals. There is NO programming for the task

...--values: Completed, Error, NULL Zillow_StreetAddress VARCHAR(1000), Zillow_City VARCHAR(100), Zillow_State VARCHAR(100), Zillow_ZipCode VARCHAR(100), Zillow_Latitude FLOAT, Zillow_Longitude FLOAT, Zillow_Zestimate FLOAT, Zillow_LastUpdated DATETIME, Zillow_ValuationRange_High FLOAT, Zillow_ValuationRange_Low FLOAT, Zillow_UseCode INT, Zillow_UseCode_Description VARCHAR(1000), Zillow_TaxAssessment_Year INT, Zillow_TaxAssessment FLOAT, Zillow_YearBuilt INT, Zillow_LastSoldDate DATETIME, Zillow_LastSoldPrice FLOAT, Zillow_ErrorCode INT, Zillow_ErrorCode_Description VARCHAR(1000) ) 7) Set RecordStatus = 'completed' if the address is returned from Zillow without an error. Set = 'Error' if Zillow re...